Table of Contents

Class SqlServer2012SqlBuilder

Namespace
LinqToDB.Internal.DataProvider.SqlServer
Assembly
linq2db.dll
public class SqlServer2012SqlBuilder : SqlServerSqlBuilder, ISqlBuilder
Inheritance
object
SqlServer2012SqlBuilder
Implements
Derived
Inherited Members
Extension Methods

Constructors

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

public SqlServer2012SqlBuilder(IDataProvider? provider, MappingSchema mappingSchema, DataOptions dataOptions, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)

Parameters

provider IDataProvider
mappingSchema MappingSchema
dataOptions DataOptions
sqlOptimizer ISqlOptimizer
sqlProviderFlags SqlProviderFlags

SqlServer2012SqlBuilder(BasicSqlBuilder)

protected SqlServer2012SqlBuilder(BasicSqlBuilder parentBuilder)

Parameters

parentBuilder BasicSqlBuilder

Properties

Name

public override string Name { get; }

Property Value

string

OffsetFirst

protected override bool OffsetFirst { get; }

Property Value

bool

Methods

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).

BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement)

protected override void BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement insertOrUpdate)

Parameters

insertOrUpdate SqlInsertOrUpdateStatement

BuildMergeInto(NullabilityContext, SqlMergeStatement)

protected override void BuildMergeInto(NullabilityContext nullability, SqlMergeStatement merge)

Parameters

nullability NullabilityContext
merge SqlMergeStatement

BuildMergeOperationDeleteBySource(NullabilityContext, SqlMergeOperationClause)

protected override void BuildMergeOperationDeleteBySource(NullabilityContext nullability, SqlMergeOperationClause operation)

Parameters

nullability NullabilityContext
operation SqlMergeOperationClause

BuildMergeOperationUpdateBySource(NullabilityContext, SqlMergeOperationClause)

protected override void BuildMergeOperationUpdateBySource(NullabilityContext nullability, SqlMergeOperationClause operation)

Parameters

nullability NullabilityContext
operation SqlMergeOperationClause

BuildMergeStatement(SqlMergeStatement)

protected override void BuildMergeStatement(SqlMergeStatement merge)

Parameters

merge SqlMergeStatement

BuildMergeTerminator(NullabilityContext, SqlMergeStatement)

Allows to add text after generated merge command. E.g. to specify command terminator if provider requires it.

protected override void BuildMergeTerminator(NullabilityContext nullability, SqlMergeStatement merge)

Parameters

nullability NullabilityContext
merge SqlMergeStatement

BuildSqlConditionExpression(SqlConditionExpression)

protected override void BuildSqlConditionExpression(SqlConditionExpression conditionExpression)

Parameters

conditionExpression SqlConditionExpression

CreateSqlBuilder()

protected override ISqlBuilder CreateSqlBuilder()

Returns

ISqlBuilder

LimitFormat(SelectQuery)

protected override string? LimitFormat(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

Returns

string

OffsetFormat(SelectQuery)

protected override string OffsetFormat(SelectQuery selectQuery)

Parameters

selectQuery SelectQuery

Returns

string