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()); }