Example #1
0
 public void ConvertToSqlTest()
 {
     Assert.AreEqual("True", SqlStatements.ConvertToSql(ColTypes.Boolean, true));
     Assert.AreEqual(@"timestamp '2017-01-01 00:00:00'", SqlStatements.ConvertToSql(ColTypes.Date, new DateTime(2017, 1, 1)));
     Assert.AreEqual("9", SqlStatements.ConvertToSql(ColTypes.Numeric, 9));
     Assert.AreEqual(@"'ab'", SqlStatements.ConvertToSql(ColTypes.Text, "a'b"));
     Assert.AreEqual("NULL", SqlStatements.ConvertToSql(ColTypes.Text, null));
 }