RepoDb.QueryBuilder.Append(string)

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 7

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Delete()
        {
            return Append("DELETE");
        }

19 Source : QueryBuilder.cs
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

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

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

public QueryBuilder TableNameFrom(string tableName,
            IDbSetting dbSetting)
        {
            return Append(tableName?.AsQuoted(true, dbSetting));
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Using()
        {
            return Append("USING");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder And()
        {
            return Append("AND");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Space()
        {
            return Append(" ");
        }

19 Source : QueryBuilder.cs
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

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

public QueryBuilder FieldFrom(Field field)
        {
            return Append(field?.Name);
        }

19 Source : QueryBuilder.cs
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

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

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

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

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

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

public QueryBuilder From()
        {
            return Append("FROM");
        }

19 Source : QueryBuilder.cs
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

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

public QueryBuilder Insert()
        {
            return Append("INSERT");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder HavingCount()
        {
            return Append("HAVING COUNT");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Into()
        {
            return Append("INTO");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Values()
        {
            return Append("VALUES");
        }

19 Source : QueryBuilder.cs
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

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

public QueryBuilder With()
        {
            return Append("WITH");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Set()
        {
            return Append("SET");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Join()
        {
            return Append("JOIN");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder Merge()
        {
            return Append("MERGE");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Table()
        {
            return Append("TABLE");
        }

19 Source : QueryBuilder.cs
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

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

public QueryBuilder Select()
        {
            return Append("SELECT");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Top()
        {
            return Append("TOP");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder Limit()
        {
            return Append("LIMIT");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder OrderBy()
        {
            return Append("ORDER BY");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Where()
        {
            return Append("WHERE");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Update()
        {
            return Append("UPDATE");
        }

19 Source : QueryBuilder.cs
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

public QueryBuilder Over()
        {
            return Append("OVER");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Or()
        {
            return Append("OR");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder Replace()
        {
            return Append("REPLACE");
        }

19 Source : QueryBuilder.cs
with Apache License 2.0
from mikependon

public QueryBuilder End()
        {
            return Append(";");
        }

19 Source : QueryBuilder.cs
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