public string GetSql()
{
Template result = TemplateLibrary.Insert;
result.Append(SnippetLibrary.Table(this.TableName, this.Format));
result.Append(SnippetLibrary.Columns(this.Columns.GetSql(this.TableAlias)));
result.Append(SnippetLibrary.Values(this.Values.GetSql()));
return(result.GetSql(this.Format));
}
public void TemplateInsert()
{
ITemplate t = TemplateLibrary.Insert;
t.Append(SnippetLibrary.Table("users"),
SnippetLibrary.Columns("[a],[b],[c]"),
SnippetLibrary.Values("@a,@b,@c"));
string sql = t.GetSql();
Assert.AreEqual(sql, "INSERT INTO [users]([a],[b],[c]) VALUES(@a,@b,@c);");
}
public string GetSql(bool EndOfStatement = true)
{
string table = Reflection.GetTableName <T>();
ITemplate result = TemplateLibrary.Insert;
result.Append(SnippetLibrary.Table(table));
result.Append(SnippetLibrary.Columns(this.Columns.GetSql(this.TableAlias)));
result.Append(SnippetLibrary.Values(this.Values.GetSql()));
return(result.GetSql(EndOfStatement));
}