Class SapHanaOdbcSqlBuilder

Namespace

LinqToDB.Internal.DataProvider.SapHana

Assembly

linq2db.dll

public class SapHanaOdbcSqlBuilder : SapHanaSqlBuilder, ISqlBuilder

Inheritance

object

BasicSqlBuilder

SapHanaSqlBuilder

SapHanaOdbcSqlBuilder

Implements

ISqlBuilder

Inherited Members

SapHanaSqlBuilder.CreateSqlBuilder()

SapHanaSqlBuilder.ConcatStyle

SapHanaSqlBuilder.CommandCount(SqlStatement)

SapHanaSqlBuilder.BuildCommand(SqlStatement, int)

SapHanaSqlBuilder.LimitFormat(SelectQuery)

SapHanaSqlBuilder.OffsetFormat(SelectQuery)

SapHanaSqlBuilder.IsNestedJoinParenthesisRequired

SapHanaSqlBuilder.BuildDropTableStatement(SqlDropTableStatement)

SapHanaSqlBuilder.BuildStartCreateTableStatement(SqlCreateTableStatement)

SapHanaSqlBuilder.BuildDataTypeFromDataType(DbDataType, bool, bool)

SapHanaSqlBuilder.BuildFromClause(SqlStatement, SelectQuery)

SapHanaSqlBuilder.Convert(StringBuilder, string, ConvertType)

SapHanaSqlBuilder.BuildCreateTableIdentityAttribute1(SqlField)

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

SapHanaSqlBuilder.BuildJoinType(SqlJoinedTable, SqlSearchCondition)

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

SapHanaSqlBuilder.BuildCreateTableCommand(SqlTable)

SapHanaSqlBuilder.BuildIsDistinctPredicate(SqlPredicate.IsDistinct)

SapHanaSqlBuilder.GetProviderTypeName(IDataContext, DbParameter)

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

SapHanaSqlBuilder.BuildInsertOrUpdateQuery(SqlInsertOrUpdateStatement)

SapHanaSqlBuilder.SupportsColumnAliasesInSource

SapHanaSqlBuilder.IsValuesSyntaxSupported

SapHanaSqlBuilder.FakeTable

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

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

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

Parameters

provider IDataProvider

mappingSchema MappingSchema

dataOptions DataOptions

sqlOptimizer ISqlOptimizer

sqlProviderFlags SqlProviderFlags

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

Convert(StringBuilder, string, ConvertType)

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

Parameters

sb StringBuilder

value string

convertType ConvertType

Returns

StringBuilder

CreateSqlBuilder()

protected override ISqlBuilder CreateSqlBuilder()

Returns

ISqlBuilder