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