public static void WithColumnNames()
{
var statement = new InsertStatement(ObjectName.Parse("t1"), new [] {
"first_name", "last_name", "age"
}, new [] {
new SqlExpression[] {
SqlExpression.Constant("Antonello"),
SqlExpression.Constant("Provenzano"),
SqlExpression.Constant(34)
},
});
var sql = statement.ToString();
var expected = new StringBuilder();
expected.Append("INSERT INTO t1(first_name, last_name, age) ");
expected.Append("VALUES ('Antonello', 'Provenzano', 34)");
Assert.AreEqual(expected.ToString(), sql);
}