public string GetSql(bool EndOfStatement = true) { string table = Reflection.GetTableName <T>(); ITemplate result = TemplateLibrary.Select; result.Append(SnippetLibrary.Table(table, this.TableAlias)); result.Append(SnippetLibrary.Columns(this.Columns.GetSql(this.TableAlias))); if (this.Join.Count > 0) { string joinTable = string.IsNullOrEmpty(this.TableAlias) ? table : this.TableAlias; result.Append(SnippetLibrary.Join(this.Join.GetSql(joinTable))); } if (this.Where.Count > 0) { result.Append(SnippetLibrary.Where(this.Where.GetSql(this.TableAlias))); } if (this.GroupBy.Count > 0) { result.Append(SnippetLibrary.GroupBy(this.GroupBy.GetSql(this.TableAlias))); } if (this.OrderBy.Count > 0) { result.Append(SnippetLibrary.OrderBy(this.OrderBy.GetSql(this.TableAlias))); } return(result.GetSql(EndOfStatement)); }
public string GetSql() { Template result = TemplateLibrary.Select; result.Append(SnippetLibrary.Table(this.TableName, this.Format, this.TableAlias)); result.Append(SnippetLibrary.Columns(this.Columns.GetSql(this.TableAlias))); if (this.Join.Count > 0) { string joinTable = string.IsNullOrEmpty(this.TableAlias) ? this.TableName : this.TableAlias; result.Append(SnippetLibrary.Join(this.Join.GetSql(joinTable))); } if (this.Where.Count > 0) { result.Append(SnippetLibrary.Where(this.Where.GetSql(this.TableAlias))); } if (this.GroupBy.Count > 0) { result.Append(SnippetLibrary.GroupBy(this.GroupBy.GetSql(this.TableAlias))); } if (this.OrderBy.Count > 0) { result.Append(SnippetLibrary.OrderBy(this.OrderBy.GetSql(this.TableAlias))); } return(result.GetSql(this.Format)); }
public string GetSql(bool endOfStatement = true) { var table = Reflection.GetTableName <T>(); var result = TemplateLibrary.Select; result.Append(SnippetLibrary.Table(table, TableAlias)); result.Append(SnippetLibrary.Columns(Columns.GetSql(TableAlias))); if (Join.Count > 0) { var joinTable = string.IsNullOrEmpty(TableAlias) ? table : TableAlias; result.Append(SnippetLibrary.Join(Join.GetSql(joinTable))); } if (Where.Count > 0) { result.Append(SnippetLibrary.Where(Where.GetSql(TableAlias))); } if (GroupBy.Count > 0) { result.Append(SnippetLibrary.GroupBy(GroupBy.GetSql(TableAlias))); } if (OrderBy.Count > 0) { result.Append(SnippetLibrary.OrderBy(OrderBy.GetSql(TableAlias))); } return(result.GetSql(endOfStatement)); }