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