public void GetBasicPagingRequest()
{
var target = new UnitTestDataAccess();
SqlCommand cmd = CreateTextCommand("Select * from sysobjects");
DataTable dt = target.ExecuteDataTable(cmd, new PagingRequest(10, 0, "ID"));
Assert.AreEqual(10, dt.Rows.Count);
}
public void BaseDb2ObjectTranslatorTestTimeSpanMapping()
{
var da = new UnitTestDataAccess();
da.ExecuteNonQuery(DropTestTableSQL());
da.ExecuteNonQuery(CreateTestTable("time(0)"));
da.ExecuteNonQuery(InsertTestDataSQL("'01:02:03'"));
var target = new BaseDb2ObjectTranslator<TestClassTimeSpan>();
var cmd = CreateTextCommand(SelectTestDataSQL());
var result = target.Translate(ExecuteDataRow(cmd));
Assert.AreEqual(new TimeSpan(1,2,3), result.Col);
da.ExecuteNonQuery(DropTestTableSQL());
}
public void BaseDb2ObjectTranslatorTestCharMapping()
{
var da = new UnitTestDataAccess();
da.ExecuteNonQuery(DropTestTableSQL());
da.ExecuteNonQuery(CreateTestTable("char(1)"));
da.ExecuteNonQuery(InsertTestDataSQL("'T'"));
var target = new BaseDb2ObjectTranslator<TestClassChar>();
SqlCommand cmd = CreateTextCommand(SelectTestDataSQL());
var result = target.Translate(ExecuteDataRow(cmd));
Assert.AreEqual('T', result.Col);
da.ExecuteNonQuery(DropTestTableSQL());
}
