public void TestInt64PrimaryKey()
{
InitTestObjects();
var before = GetCountOfTestObjects();
Assert.AreNotEqual(0, before);
var dw = GetDataWorker();
var dwt = new DataWorkerTask();
dwt.CommandText = "InsertTestObjectWithReallyBigID";
dwt.CommandType = CommandType.StoredProcedure;
dwt.ReadResults = true;
dwt.Mode = DataWorkerMode.AllProperties;
var testObject = new SampleClassPoco {
ID = 0
};
var result = dw.DoWorkDirect <SampleClass>(dwt, testObject);
Assert.AreEqual(0, result.Count);
Assert.AreEqual(1, dwt.RowsAffected);
Assert.AreNotEqual(0, testObject.ID);
Assert.AreEqual(long.MaxValue, testObject.ID);
var after = GetCountOfTestObjects();
Assert.AreNotEqual(0, after);
Assert.AreEqual(before + 1, after);
}
public void Test_DW_FetchByAllProps_NoResults_ExpectNull()
{
InitSamples();
var before = GetCountOfSamples();
Assert.AreNotEqual(0, before);
var dw = GetDataWorker();
int loadID = -1;
var testobject = new SampleClassPoco {
ID = loadID
};
Assert.AreNotEqual(0, testobject.ID);
Assert.IsNullOrEmpty(testobject.Name);
var result = dw.FetchByAllProps <SampleClassPoco>(testobject);
var after = GetCountOfSamples();
var expectedAfter = before;
Assert.IsNull(result);
}
public void TestSelectFilteredFromNormalObject()
{
var dw = GetDataWorker();
var dwt = new DataWorkerTask();
dwt.CommandText = "select * from samples where id <= @ID";
dwt.CommandType = CommandType.Text;
dwt.ReadResults = true;
dwt.Mode = DataWorkerMode.AllProperties;
var normalObject = new SampleClassPoco {
ID = 2
};
var result = dw.DoWorkDirect <SampleClass>(dwt, normalObject);
Assert.AreNotEqual(0, result.Count);
foreach (var item in result)
{
Assert.IsTrue(item.ID <= 2);
}
}
