Here are the examples of the csharp api RepoDb.QueryBuilder.Append(string) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
69 Examples
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Delete()
{
return Append("DELETE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Average(Field field,
IDbSetting dbSetting,
IResolver<Field, IDbSetting, string> convertResolver)
{
var name = convertResolver == null ? field.Name.AsField(dbSetting) :
convertResolver.Resolve(field, dbSetting);
return Append(string.Concat("AVG (", name, ")"));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Sum(Field field,
IDbSetting dbSetting,
IResolver<Field, IDbSetting, string> convertResolver)
{
var name = convertResolver == null ? field.Name.AsField(dbSetting) :
convertResolver.Resolve(field, dbSetting);
return Append(string.Concat("SUM (", name, ")"));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder CountBig(Field field,
IDbSetting dbSetting)
{
var name = field != null ? field.Name.AsField(dbSetting) : "*";
return Append(string.Concat("COUNT_BIG (", name, ")"));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder TableNameFrom(string tableName,
IDbSetting dbSetting)
{
return Append(tableName?.AsQuoted(true, dbSetting));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Using()
{
return Append("USING");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder WhereFrom(QueryGroup queryGroup,
int index,
IDbSetting dbSetting)
{
return (queryGroup != null) ? Append(string.Concat("WHERE ", queryGroup.GetString(index, dbSetting))) : this;
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder And()
{
return Append("AND");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Space()
{
return Append(" ");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder WriteText(string text)
{
return Append(text);
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Min(Field field,
IDbSetting dbSetting,
IResolver<Field, IDbSetting, string> convertResolver)
{
var name = convertResolver == null ? field.Name.AsField(dbSetting) :
convertResolver.Resolve(field, dbSetting);
return Append(string.Concat("MIN (", name, ")"));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder FieldFrom(Field field)
{
return Append(field?.Name);
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder FieldsAndParametersFrom<TEnreplacedy>(int index,
IDbSetting dbSetting)
where TEnreplacedy : clreplaced
{
return Append(FieldCache.Get<TEnreplacedy>()?.AsFieldsAndParameters(index, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder FieldsAndParametersFrom(IEnumerable<Field> fields,
int index,
IDbSetting dbSetting)
{
return Append(fields?.AsFieldsAndParameters(index, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder FieldsAndAliasFieldsFrom<TEnreplacedy>(string alias,
IDbSetting dbSetting)
where TEnreplacedy : clreplaced
{
var fields = PropertyCache.Get<TEnreplacedy>()?.Select(property => property.GetMappedName());
return Append(fields?.AsFieldsAndAliasFields(alias, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder FieldsAndAliasFieldsFrom(IEnumerable<Field> fields,
string alias,
IDbSetting dbSetting)
{
return Append(fields?.AsFieldsAndAliasFields(alias, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder AsAliasFieldsFrom<TEnreplacedy>(string alias,
IDbSetting dbSetting)
where TEnreplacedy : clreplaced
{
var fields = PropertyCache.Get<TEnreplacedy>()?.Select(property => property.GetMappedName());
return Append(fields?.AsAliasFields(alias, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder AsAliasFieldsFrom(IEnumerable<Field> fields,
string alias,
IDbSetting dbSetting)
{
return Append(fields?.AsAliasFields(alias, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder From()
{
return Append("FROM");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder GroupByFrom(IEnumerable<Field> fields,
IDbSetting dbSetting)
{
return Append(string.Concat("GROUP BY ", fields?.AsFields(dbSetting).Join(", ")));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder HavingCountFrom(QueryField queryField,
int index,
IDbSetting dbSetting)
{
return Append(string.Concat("HAVING COUNT(", queryField.Field.Name, ") ", queryField.GetOperationText(), ", ", queryField.AsParameter(index, dbSetting)));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Insert()
{
return Append("INSERT");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder GroupBy()
{
return Append("GROUP BY");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder HavingCount()
{
return Append("HAVING COUNT");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Into()
{
return Append("INTO");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Values()
{
return Append("VALUES");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder OrderByFrom(IEnumerable<OrderField> orderBy,
string alias,
IDbSetting dbSetting)
{
return orderBy?.Any() == true ?
Append(string.Concat("ORDER BY ", orderBy.Select(orderField => orderField.AsField(alias, dbSetting)).Join(", "))) :
this;
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder As(string alias)
{
return string.IsNullOrEmpty(alias) ? Append("AS") : Append(string.Concat("AS ", alias));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder With()
{
return Append("WITH");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Set()
{
return Append("SET");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Join()
{
return Append("JOIN");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder JoinQualifiersFrom(Field field,
string leftAlias,
string rightAlias,
IDbSetting dbSetting)
{
return Append(field.AsJoinQualifier(leftAlias, rightAlias, dbSetting));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Merge()
{
return Append("MERGE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Table()
{
return Append("TABLE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder ParametersFrom(IEnumerable<Field> fields,
int index,
IDbSetting dbSetting)
{
return Append(fields?.AsParameters(index, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder ParametersAsFieldsFrom(IEnumerable<Field> fields,
int index,
IDbSetting dbSetting)
{
return Append(fields?.AsParametersAsFields(index, dbSetting).Join(", "));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Select()
{
return Append("SELECT");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Top()
{
return Append("TOP");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder TopFrom(int? rows)
{
return rows > 0 ? Append(string.Concat("TOP (", rows, ")")) : this;
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Limit()
{
return Append("LIMIT");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder LimitFrom(int? skip,
int? take)
{
return skip > 0 ? Append(string.Concat("LIMIT ", skip, ", ", take)) : Append(string.Concat("LIMIT ", take));
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder OrderBy()
{
return Append("ORDER BY");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Where()
{
return Append("WHERE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Update()
{
return Append("UPDATE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder RowNumber()
{
return Append("ROW_NUMBER()");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Over()
{
return Append("OVER");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Or()
{
return Append("OR");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Replace()
{
return Append("REPLACE");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder End()
{
return Append(";");
}
19
Source : QueryBuilder.cs
with Apache License 2.0
from mikependon
with Apache License 2.0
from mikependon
public QueryBuilder Max(Field field,
IDbSetting dbSetting,
IResolver<Field, IDbSetting, string> convertResolver)
{
var name = convertResolver == null ? field.Name.AsField(dbSetting) :
convertResolver.Resolve(field, dbSetting);
return Append(string.Concat("MAX (", name, ")"));
}
See More Examples