public static void WithIdentityColumn()
{
var statement = new CreateTableStatement(new ObjectName("test_table"),
new[] {
new SqlTableColumn("id", PrimitiveTypes.Integer()) {
IsIdentity = true
},
new SqlTableColumn("name", PrimitiveTypes.String()),
});
var sql = statement.ToString();
var expected = new StringBuilder();
expected.AppendLine("CREATE TABLE test_table (");
expected.AppendLine(" id INTEGER IDENTITY,");
expected.AppendLine(" name STRING");
expected.Append(")");
Assert.AreEqual(expected.ToString(), sql);
}