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