Class MySqlSqlBuilder

Namespace

LinqToDB.Internal.DataProvider.MySql

Assembly

linq2db.dll

public abstract class MySqlSqlBuilder : BasicSqlBuilder<MySqlOptions>, ISqlBuilder

Inheritance

object

BasicSqlBuilder

BasicSqlBuilder<MySqlOptions>

MySqlSqlBuilder

Implements

ISqlBuilder

Derived

MariaDBSqlBuilder

MySql57SqlBuilder

MySql80SqlBuilder

Inherited Members

BasicSqlBuilder<MySqlOptions>.ProviderOptions

BasicSqlBuilder.AliasesContext

BasicSqlBuilder.OptimizationContext

BasicSqlBuilder.MappingSchema

BasicSqlBuilder.StringBuilder

BasicSqlBuilder.SqlProviderFlags

BasicSqlBuilder.DataOptions

BasicSqlBuilder.NullabilityContext

BasicSqlBuilder.DataProvider

BasicSqlBuilder.ValueToSqlConverter

BasicSqlBuilder.Statement

BasicSqlBuilder.Indent

BasicSqlBuilder.BuildStep

BasicSqlBuilder.SqlOptimizer

BasicSqlBuilder.AliasMode

BasicSqlBuilder.IsNestedJoinSupported

BasicSqlBuilder.IsNestedJoinParenthesisRequired

BasicSqlBuilder.CteFirst

BasicSqlBuilder.WrapJoinCondition

BasicSqlBuilder.IsOverRequiredWithinGroup

BasicSqlBuilder.CanSkipRootAliases(SqlStatement)

BasicSqlBuilder.RequiresUniqueRootColumnNames

BasicSqlBuilder.IsUpsertUpdateWhereAfterSet

BasicSqlBuilder.CommandCount(SqlStatement)

BasicSqlBuilder.InlineComma

BasicSqlBuilder.Comma

BasicSqlBuilder.OpenParens

BasicSqlBuilder.RemoveInlineComma()

BasicSqlBuilder.ConvertElement<T>(T)

BasicSqlBuilder.Optimize(IQueryElement, bool)

BasicSqlBuilder.BuildSql(int, SqlStatement, StringBuilder, OptimizationContext, AliasesContext, NullabilityContext, int)

BasicSqlBuilder.BuildSetOperation(SetOperation, StringBuilder)

BasicSqlBuilder.BuildSql(int, SqlStatement, StringBuilder, OptimizationContext, int, BasicSqlBuilder.ColumnAliasMode, NullabilityContext)

BasicSqlBuilder.MergeSqlBuilderData(BasicSqlBuilder)

BasicSqlBuilder.BuildCommand(SqlStatement, int)

BasicSqlBuilder.FinalizeBuildQuery(SqlStatement)

BasicSqlBuilder.BuildSqlBuilder(SelectQuery, int, BasicSqlBuilder.ColumnAliasMode)

BasicSqlBuilder.CreateSqlBuilder()

BasicSqlBuilder.WithStringBuilderBuildExpression(ISqlExpression)

BasicSqlBuilder.WithStringBuilderBuildExpression(int, ISqlExpression)

BasicSqlBuilder.WithStringBuilder<TContext>(Action<TContext>, TContext)

BasicSqlBuilder.ParenthesizeJoin(List<SqlJoinedTable>)

BasicSqlBuilder.BuildSql()

BasicSqlBuilder.BuildSqlForUnion()

BasicSqlBuilder.BuildDeleteQuery(SqlDeleteStatement)

BasicSqlBuilder.BuildDeleteQuery2(SqlDeleteStatement)

BasicSqlBuilder.BuildUpdateQuery(SqlStatement, SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildSelectQuery(SqlSelectStatement)

BasicSqlBuilder.BuildCteBody(SelectQuery)

BasicSqlBuilder.BuildInsertQuery(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildInsertQuery2(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildMultiInsertQuery(SqlMultiInsertStatement)

BasicSqlBuilder.BuildUnknownQuery()

BasicSqlBuilder.BuildObjectName(StringBuilder, SqlObjectName, ConvertType, bool, TableOptions, bool)

BasicSqlBuilder.BuildObjectNameSuffix(StringBuilder, SqlObjectName, bool)

BasicSqlBuilder.ConvertInline(string, ConvertType)

BasicSqlBuilder.Convert(StringBuilder, string, ConvertType)

BasicSqlBuilder.IsRecursiveCteKeywordRequired

BasicSqlBuilder.IsCteColumnListSupported

BasicSqlBuilder.SupportsMaterializedCteHint

BasicSqlBuilder.SupportsNotMaterializedCteHint

BasicSqlBuilder.SuppressCteAsKeyword(CteClause)

BasicSqlBuilder.BuildCteHeaderHint(CteClause)

BasicSqlBuilder.BuildWithClause(SqlWithClause)

BasicSqlBuilder.BuildSelectClause(SelectQuery)

BasicSqlBuilder.BuildDistinctModifier(SelectQuery)

BasicSqlBuilder.BuildDistinctOnExpressions(SelectQuery)

BasicSqlBuilder.StartStatementQueryExtensions(SelectQuery)

BasicSqlBuilder.BuildColumns(SelectQuery)

BasicSqlBuilder.BuildOutputColumnExpressions(IReadOnlyList<ISqlExpression>)

BasicSqlBuilder.BuildColumnExpression(SelectQuery, ISqlExpression, string, ref bool)

BasicSqlBuilder.BuildAlterDeleteClause(SqlDeleteStatement)

BasicSqlBuilder.BuildDeleteClause(SqlDeleteStatement)

BasicSqlBuilder.BuildUpdateWhereClause(SelectQuery)

BasicSqlBuilder.BuildUpdateClause(SqlStatement, SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildUpdateTable(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.BuildUpdateTableName(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.UpdateKeyword

BasicSqlBuilder.UpdateSetKeyword

BasicSqlBuilder.BuildUpdateSet(SelectQuery, SqlUpdateClause)

BasicSqlBuilder.OutputKeyword

BasicSqlBuilder.DeletedOutputTable

BasicSqlBuilder.InsertedOutputTable

BasicSqlBuilder.BuildInsertClause(SqlStatement, SqlInsertClause, bool)

BasicSqlBuilder.BuildEmptyInsert(SqlInsertClause)

BasicSqlBuilder.BuildOutputSubclause(SqlStatement, SqlInsertClause)

BasicSqlBuilder.BuildInsertValuesOverrideClause(SqlStatement, SqlInsertClause)

BasicSqlBuilder.BuildOutputSubclause(SqlOutputClause)

BasicSqlBuilder.BuildInsertClause(SqlStatement, SqlInsertClause, string, bool, bool)

BasicSqlBuilder.BuildGetIdentity(SqlInsertClause)

BasicSqlBuilder.BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement)

BasicSqlBuilder.BuildInsertOrUpdateQueryAsOnConflictUpdateOrNothing(SqlInsertOrUpdateStatement)

BasicSqlBuilder.BuildInsertOrUpdateQueryAsMerge(SqlInsertOrUpdateStatement, string)

BasicSqlBuilder.EndLine

BasicSqlBuilder.BuildInsertOrUpdateQueryAsUpdateInsert(SqlInsertOrUpdateStatement)

BasicSqlBuilder.BuildTruncateTableStatement(SqlTruncateTableStatement)

BasicSqlBuilder.BuildTruncateTable(SqlTruncateTableStatement)

BasicSqlBuilder.BuildDropTableStatement(SqlDropTableStatement)

BasicSqlBuilder.BuildDropTableStatementIfExists(SqlDropTableStatement)

BasicSqlBuilder.BuildCreateTableCommand(SqlTable)

BasicSqlBuilder.BuildStartCreateTableStatement(SqlCreateTableStatement)

BasicSqlBuilder.BuildEndCreateTableStatement(SqlCreateTableStatement)

BasicSqlBuilder.BuildCreateTableStatement(SqlCreateTableStatement)

BasicSqlBuilder.BuildCreateTableFieldType(SqlField)

BasicSqlBuilder.BuildCreateTableNullAttribute(SqlField, DefaultNullable)

BasicSqlBuilder.BuildCreateTableIdentityAttribute1(SqlField)

BasicSqlBuilder.BuildCreateTableIdentityAttribute2(SqlField)

BasicSqlBuilder.BuildCreateTablePrimaryKey(SqlCreateTableStatement, string, IEnumerable<string>)

BasicSqlBuilder.BuildDeleteFromClause(SqlDeleteStatement)

BasicSqlBuilder.BuildFromClause(SqlStatement, SelectQuery)

BasicSqlBuilder.BuildFromExtensions(SelectQuery)

BasicSqlBuilder.BuildPhysicalTable(ISqlTableSource, string, string)

BasicSqlBuilder.BuildSqlValuesTable(SqlValuesTable, string, out bool)

BasicSqlBuilder.BuildEmptyValues(SqlValuesTable, bool)

BasicSqlBuilder.BuildEmptyValuesFrom()

BasicSqlBuilder.BuildTableName(SqlTableSource, bool, bool)

BasicSqlBuilder.BuildTableExtensions(SqlTable, string)

BasicSqlBuilder.BuildTableNameExtensions(SqlTable)

BasicSqlBuilder.GetExtensionBuilder(Type)

BasicSqlBuilder.BuildTableExtensions(StringBuilder, SqlTable, string, string, string, string)

BasicSqlBuilder.BuildTableExtensions(StringBuilder, SqlTable, string, string, string, string, Func<SqlQueryExtension, bool>)

BasicSqlBuilder.BuildQueryExtensions(StringBuilder, List<SqlQueryExtension>, string, string, string, Sql.QueryExtensionScope)

BasicSqlBuilder.BuildJoinTable(SelectQuery, SqlTableSource, SqlJoinedTable, ref int)

BasicSqlBuilder.BuildJoinType(SqlJoinedTable, SqlSearchCondition)

BasicSqlBuilder.ShouldBuildWhere(SelectQuery, out SqlSearchCondition)

BasicSqlBuilder.BuildWhereClause(SelectQuery)

BasicSqlBuilder.BuildGroupByClause(SelectQuery)

BasicSqlBuilder.BuildGroupByBody(GroupingType, List<ISqlExpression>)

BasicSqlBuilder.BuildHavingClause(SelectQuery)

BasicSqlBuilder.BuildOrderByClause(SelectQuery)

BasicSqlBuilder.BuildExpressionForOrderBy(ISqlExpression)

BasicSqlBuilder.SkipFirst

BasicSqlBuilder.SkipFormat

BasicSqlBuilder.FirstFormat(SelectQuery)

BasicSqlBuilder.LimitFormat(SelectQuery)

BasicSqlBuilder.OffsetFormat(SelectQuery)

BasicSqlBuilder.OffsetFirst

BasicSqlBuilder.TakePercent

BasicSqlBuilder.TakeTies

BasicSqlBuilder.NeedSkip(ISqlExpression, ISqlExpression)

BasicSqlBuilder.NeedTake(ISqlExpression)

BasicSqlBuilder.BuildSkipFirst(SelectQuery)

BasicSqlBuilder.BuildTakeHints(SelectQuery)

BasicSqlBuilder.BuildOffsetLimit(SelectQuery)

BasicSqlBuilder.BuildWhereSearchCondition(SelectQuery, SqlSearchCondition)

BasicSqlBuilder.BuildSearchCondition(SqlSearchCondition, bool)

BasicSqlBuilder.BuildSearchCondition(int, SqlSearchCondition, bool)

BasicSqlBuilder.BuildPredicate(ISqlPredicate)

BasicSqlBuilder.BuildExprExprPredicateOperator(SqlPredicate.ExprExpr)

BasicSqlBuilder.BuildExprExprPredicate(SqlPredicate.ExprExpr)

BasicSqlBuilder.BuildIsDistinctPredicate(SqlPredicate.IsDistinct)

BasicSqlBuilder.BuildIsDistinctPredicateFallback(SqlPredicate.IsDistinct)

BasicSqlBuilder.BuildInSubQueryPredicate(SqlPredicate.InSubQuery)

BasicSqlBuilder.BuildInListPredicate(SqlPredicate.InList)

BasicSqlBuilder.PrepareSearchCondition(SqlSearchCondition)

BasicSqlBuilder.BuildPredicate(int, int, ISqlPredicate)

BasicSqlBuilder.BuildLikePredicate(SqlPredicate.Like)

BasicSqlBuilder.BuildFieldTableAlias(SqlField)

BasicSqlBuilder.BuildExpression(ISqlExpression, bool, bool, string, ref bool, bool)

BasicSqlBuilder.BuildSqlCastExpression(SqlCastExpression)

BasicSqlBuilder.BuildSqlParameterCastExpression(SqlParameterCastExpression)

BasicSqlBuilder.GetParameterCastType(SqlParameter)

BasicSqlBuilder.ParameterCastResolvesUndefinedType

BasicSqlBuilder.ParameterCastMaxLength

BasicSqlBuilder.ParameterCastDecimalNullsOnly

BasicSqlBuilder.GetValueBasedParameterCastType(SqlParameter)

BasicSqlBuilder.GetWindowNullsPlacement(SqlExtendedFunction)

BasicSqlBuilder.WindowFunctionRespectNullsRequired(SqlExtendedFunction)

BasicSqlBuilder.BuildSqlExtendedFunction(SqlExtendedFunction)

BasicSqlBuilder.BuildSqlConditionExpression(SqlConditionExpression)

BasicSqlBuilder.BuildSqlConditionExpressionAsFunction(string, SqlConditionExpression)

BasicSqlBuilder.BuildSqlCaseExpression(SqlCaseExpression)

BasicSqlBuilder.BuildAnchor(SqlAnchor)

BasicSqlBuilder.TryConvertParameterToSql(SqlParameterValue)

BasicSqlBuilder.BuildParameter(SqlParameter)

BasicSqlBuilder.BuildExpression(ISqlExpression)

BasicSqlBuilder.BuildExpression(ISqlExpression, bool, bool, bool)

BasicSqlBuilder.BuildExpression(int, ISqlExpression)

BasicSqlBuilder.BuildTypedExpression(DbDataType, ISqlExpression)

BasicSqlBuilder.BuildSqlRow(SqlRowExpression, bool, bool, bool)

BasicSqlBuilder.BuildExpressionContext

BasicSqlBuilder.BuildValue(DbDataType?, object)

BasicSqlBuilder.BuildSqlValue(SqlValue)

BasicSqlBuilder.BuildBinaryExpression(SqlBinaryExpression)

BasicSqlBuilder.ConcatStyle

BasicSqlBuilder.ConcatFunctionName

BasicSqlBuilder.BuildSqlConcatExpression(SqlConcatExpression)

BasicSqlBuilder.BuildUnaryExpression(SqlUnaryExpression)

BasicSqlBuilder.BuildFunction(SqlFunction)

BasicSqlBuilder.BuildDataType(StringBuilder, DbDataType)

BasicSqlBuilder.BuildDataType(DbDataType, bool, bool)

BasicSqlBuilder.BuildDataTypeFromDataType(DbDataType, bool, bool)

BasicSqlBuilder.CorrectDecimalFacets(DbDataType, decimal, bool)

BasicSqlBuilder.GetPrecedence(ISqlPredicate)

BasicSqlBuilder.BuildTag(SqlStatement)

BasicSqlBuilder.BuildSqlComment(StringBuilder, SqlComment)

BasicSqlBuilder.IsDateDataType(ISqlExpression, string)

BasicSqlBuilder.IsTimeDataType(ISqlExpression)

BasicSqlBuilder.GetSequenceNameAttribute(SqlTable, bool)

BasicSqlBuilder.GetTableAlias(ISqlTableSource)

BasicSqlBuilder.GetPhysicalTableName(ISqlTableSource, string, bool, string, bool)

BasicSqlBuilder.AppendIndent()

BasicSqlBuilder.IsReserved(string)

BasicSqlBuilder.ConvertCaseToConditions(SqlCaseExpression, int)

BasicSqlBuilder.GetIdentityExpression(SqlTable)

BasicSqlBuilder.PrintParameterName(StringBuilder, DbParameter)

BasicSqlBuilder.GetTypeName(IDataContext, DbParameter)

BasicSqlBuilder.GetUdtTypeName(IDataContext, DbParameter)

BasicSqlBuilder.GetProviderTypeName(IDataContext, DbParameter)

BasicSqlBuilder.PrintParameterType(IDataContext, StringBuilder, DbParameter)

BasicSqlBuilder.PrintParameters(IDataContext, StringBuilder, IEnumerable<DbParameter>)

BasicSqlBuilder.PrintParameterValue(StringBuilder, object)

BasicSqlBuilder.ApplyQueryHints(string, IReadOnlyCollection<string>)

BasicSqlBuilder.GetReserveSequenceValuesSql(int, string)

BasicSqlBuilder.GetMaxValueSql(EntityDescriptor, ColumnDescriptor)

BasicSqlBuilder.Name

BasicSqlBuilder.RemoveAlias(string)

BasicSqlBuilder.GetTempAliases(int, string)

BasicSqlBuilder.BuildSubQueryExtensions(SqlStatement)

BasicSqlBuilder.BuildQueryExtensions(SqlStatement)

BasicSqlBuilder.TableIDs

BasicSqlBuilder.TablePath

BasicSqlBuilder.QueryName

BasicSqlBuilder.BuildSqlID(Sql.SqlID)

BasicSqlBuilder.SupportsColumnAliasesInSource

BasicSqlBuilder.SupportsColumnAliasesInScalarSource

BasicSqlBuilder.RequiresConstantColumnAliases

BasicSqlBuilder.IsValuesSyntaxSupported

BasicSqlBuilder.IsEmptyValuesSourceSupported

BasicSqlBuilder.FakeTable

BasicSqlBuilder.FakeTableSchema

BasicSqlBuilder.BuildMergeStatement(SqlMergeStatement)

BasicSqlBuilder.BuildMergeTerminator(NullabilityContext, SqlMergeStatement)

BasicSqlBuilder.BuildMergeOperationUpdate(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationDelete(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationInsert(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationUpdateWithDelete(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationDeleteBySource(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOperationUpdateBySource(NullabilityContext, SqlMergeOperationClause)

BasicSqlBuilder.BuildMergeOn(NullabilityContext, SqlMergeStatement)

BasicSqlBuilder.BuildMergeSourceQuery(NullabilityContext, SqlTableLikeSource)

BasicSqlBuilder.IsSqlValuesTableValueTypeRequired(SqlValuesTable, IReadOnlyList<List<ISqlExpression>>, int, int)

BasicSqlBuilder.BuildFakeTableName()

BasicSqlBuilder.BuildValues(SqlValuesTable, IReadOnlyList<List<ISqlExpression>>)

BasicSqlBuilder.BuildMergeInto(NullabilityContext, SqlMergeStatement)

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

MySqlSqlBuilder(IDataProvider?, MappingSchema, DataOptions, ISqlOptimizer, SqlProviderFlags)

protected MySqlSqlBuilder(IDataProvider? provider, MappingSchema mappingSchema, DataOptions dataOptions, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)

Parameters

provider IDataProvider

mappingSchema MappingSchema

dataOptions DataOptions

sqlOptimizer ISqlOptimizer

sqlProviderFlags SqlProviderFlags

MySqlSqlBuilder(BasicSqlBuilder)

protected MySqlSqlBuilder(BasicSqlBuilder parentBuilder)

Parameters

parentBuilder BasicSqlBuilder

Properties

ConcatStyle

SQL-emit shape for SqlConcatExpression. Defaults to Plus; override per provider.

protected override BasicSqlBuilder.ConcatBuildStyle ConcatStyle { get; }

Property Value

BasicSqlBuilder.ConcatBuildStyle

HintBuilder

protected StringBuilder? HintBuilder { get; set; }

Property Value

StringBuilder

IsNestedJoinParenthesisRequired

public override bool IsNestedJoinParenthesisRequired { get; }

Property Value

bool

IsRecursiveCteKeywordRequired

protected override bool IsRecursiveCteKeywordRequired { get; }

Property Value

bool

IsValuesSyntaxSupported

If true, provider supports list of VALUES as a source element of merge command.

protected override bool IsValuesSyntaxSupported { get; }

Property Value

bool

SupportsColumnAliasesInSource

If true, provider supports column aliases specification after table alias. E.g. as table_alias (column_alias1, column_alias2).

protected override bool SupportsColumnAliasesInSource { get; }

Property Value

bool

Methods

BuildCommand(SqlStatement, int)

protected override void BuildCommand(SqlStatement statement, int commandNumber)

Parameters

statement SqlStatement

commandNumber int

BuildCreateTableCommand(SqlTable)

protected override void BuildCreateTableCommand(SqlTable table)

Parameters

table SqlTable

BuildCreateTableIdentityAttribute1(SqlField)

protected override void BuildCreateTableIdentityAttribute1(SqlField field)

Parameters

field SqlField

BuildCreateTablePrimaryKey(SqlCreateTableStatement, string, IEnumerable<string>)

protected override void BuildCreateTablePrimaryKey(SqlCreateTableStatement createTable, string pkName, IEnumerable<string> fieldNames)

Parameters

createTable SqlCreateTableStatement

pkName string

fieldNames IEnumerable<string>

BuildDataTypeFromDataType(DbDataType, bool, bool)

protected override void BuildDataTypeFromDataType(DbDataType type, bool forCreateTable, bool canBeNull)

Parameters

type DbDataType

forCreateTable bool

canBeNull bool

Type could store NULL values (could be used for column table type generation or for databases with explicit typee nullability like ClickHouse).

BuildDeleteClause(SqlDeleteStatement)

protected override void BuildDeleteClause(SqlDeleteStatement deleteStatement)

Parameters

deleteStatement SqlDeleteStatement

BuildDropTableStatement(SqlDropTableStatement)

protected override void BuildDropTableStatement(SqlDropTableStatement dropTable)

Parameters

dropTable SqlDropTableStatement

BuildEmptyInsert(SqlInsertClause)

protected override void BuildEmptyInsert(SqlInsertClause insertClause)

Parameters

insertClause SqlInsertClause

BuildExpression(ISqlExpression, bool, bool, string?, ref bool, bool)

protected override StringBuilder BuildExpression(ISqlExpression expr, bool buildTableName, bool checkParentheses, string? alias, ref bool addAlias, bool throwExceptionIfTableNotFound = true)

Parameters

expr ISqlExpression

buildTableName bool

checkParentheses bool

alias string

addAlias bool

throwExceptionIfTableNotFound bool

Returns

StringBuilder

BuildFromClause(SqlStatement, SelectQuery)

protected override void BuildFromClause(SqlStatement statement, SelectQuery selectQuery)

Parameters

statement SqlStatement

selectQuery SelectQuery

BuildGroupByBody(GroupingType, List<ISqlExpression>)

protected override void BuildGroupByBody(GroupingType groupingType, List<ISqlExpression> items)

Parameters

groupingType GroupingType

items List<ISqlExpression>

BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement)

protected override void BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement insertOrUpdate)

Parameters

insertOrUpdate SqlInsertOrUpdateStatement

BuildInsertQuery(SqlStatement, SqlInsertClause, bool)

protected override void BuildInsertQuery(SqlStatement statement, SqlInsertClause insertClause, bool addAlias)

Parameters

statement SqlStatement

insertClause SqlInsertClause

addAlias bool

BuildIsDistinctPredicate(IsDistinct)

protected override void BuildIsDistinctPredicate(SqlPredicate.IsDistinct expr)

Parameters

expr SqlPredicate.IsDistinct

BuildMergeStatement(SqlMergeStatement)

protected override void BuildMergeStatement(SqlMergeStatement merge)

Parameters

merge SqlMergeStatement

BuildObjectName(StringBuilder, SqlObjectName, ConvertType, bool, TableOptions, bool)

Writes database object name into provided StringBuilder instance.

public override StringBuilder BuildObjectName(StringBuilder sb, SqlObjectName name, ConvertType objectType = ConvertType.NameToQueryTable, bool escape = true, TableOptions tableOptions = TableOptions.NotSet, bool withoutSuffix = false)

Parameters

sb StringBuilder

String builder for generated object name.

name SqlObjectName

Name of database object (e.g. table, view, procedure or function).

objectType ConvertType

Type of database object, used to select proper name converter.

escape bool

If true, apply required escaping to name components. Must be true except rare cases when escaping is not needed.

tableOptions TableOptions

Table options if called for table. Used to properly generate names for temporary tables.

withoutSuffix bool

If object name have suffix, which could be detached from main name, this parameter disables suffix generation (enables generation of only main name part).

Returns

StringBuilder

sb parameter value.

BuildOffsetLimit(SelectQuery)

protected override void BuildOffsetLimit(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

BuildSql()

protected override void BuildSql()

BuildSubQueryExtensions(SqlStatement)

protected override void BuildSubQueryExtensions(SqlStatement statement)

Parameters

statement SqlStatement

BuildTableExtensions(SqlTable, string)

protected override void BuildTableExtensions(SqlTable table, string alias)

Parameters

table SqlTable

alias string

BuildTruncateTable(SqlTruncateTableStatement)

protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable)

Parameters

truncateTable SqlTruncateTableStatement

BuildUpdateClause(SqlStatement, SelectQuery, SqlUpdateClause)

protected override void BuildUpdateClause(SqlStatement statement, SelectQuery selectQuery, SqlUpdateClause updateClause)

Parameters

statement SqlStatement

selectQuery SelectQuery

updateClause SqlUpdateClause

CanSkipRootAliases(SqlStatement)

protected override bool CanSkipRootAliases(SqlStatement statement)

Parameters

statement SqlStatement

Returns

bool

CommandCount(SqlStatement)

public override int CommandCount(SqlStatement statement)

Parameters

statement SqlStatement

Returns

int

Convert(StringBuilder, string, ConvertType)

public override StringBuilder Convert(StringBuilder sb, string value, ConvertType convertType)

Parameters

sb StringBuilder

value string

convertType ConvertType

Returns

StringBuilder

FinalizeBuildQuery(SqlStatement)

protected override void FinalizeBuildQuery(SqlStatement statement)

Parameters

statement SqlStatement

GetProviderTypeName(IDataContext, DbParameter)

protected override string? GetProviderTypeName(IDataContext dataContext, DbParameter parameter)

Parameters

dataContext IDataContext

parameter DbParameter

Returns

string

IsSqlValuesTableValueTypeRequired(SqlValuesTable, IReadOnlyList<List<ISqlExpression>>, int, int)

Checks that value in specific row and column in enumerable source requires type information generation.

protected override bool IsSqlValuesTableValueTypeRequired(SqlValuesTable source, IReadOnlyList<List<ISqlExpression>> rows, int row, int column)

Parameters

source SqlValuesTable

Merge source table.

rows IReadOnlyList<List<ISqlExpression>>

Merge source data.

row int

Index of data row to check. Could contain -1 to indicate that this is a check for empty source NULL value.

column int

Index of data column to check in row.

Returns

bool

Returns true, if generated SQL should include type information for value at specified position, otherwise false returned.

LimitFormat(SelectQuery)

protected override string LimitFormat(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

Returns

string

StartStatementQueryExtensions(SelectQuery?)

protected override void StartStatementQueryExtensions(SelectQuery? selectQuery)

Parameters

selectQuery SelectQuery