Class SqlServerSchemaProvider

Namespace

LinqToDB.Internal.DataProvider.SqlServer

Assembly

linq2db.dll

public class SqlServerSchemaProvider : SchemaProviderBase, ISchemaProvider

Inheritance

object

SchemaProviderBase

SqlServerSchemaProvider

Implements

ISchemaProvider

Inherited Members

SchemaProviderBase.GetDataType(string, string, int?, int?, int?)

SchemaProviderBase.GetTables(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetPrimaryKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

SchemaProviderBase.GetColumns(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetForeignKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

SchemaProviderBase.GetProviderSpecificTypeNamespace()

SchemaProviderBase.GetProcedures(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetProcedureParameters(DataConnection, IEnumerable<ProcedureInfo>, GetSchemaOptions)

SchemaProviderBase.IncludedSchemas

SchemaProviderBase.ExcludedSchemas

SchemaProviderBase.IncludedCatalogs

SchemaProviderBase.ExcludedCatalogs

SchemaProviderBase.GenerateChar1AsString

SchemaProviderBase.DataTypesSchema

SchemaProviderBase.GetProcedureSchemaExecutesProcedure

SchemaProviderBase.BuildSchemaFilter(GetSchemaOptions, string, Action<StringBuilder, string>)

SchemaProviderBase.GetSchema(DataConnection, GetSchemaOptions)

SchemaProviderBase.ForeignKeyColumnComparison(string)

SchemaProviderBase.GetHashSet(string[], IEqualityComparer<string>)

SchemaProviderBase.GetProviderSpecificTables(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetProviderSpecificProcedures(DataConnection)

SchemaProviderBase.BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema, string)

SchemaProviderBase.LoadProcedureTableSchema(DataConnection, GetSchemaOptions, ProcedureSchema, string, List<TableSchema>)

SchemaProviderBase.BuildProcedureParameter(ParameterSchema)

SchemaProviderBase.GetProviderSpecificType(string)

SchemaProviderBase.GetDataType(string, DataType?, GetSchemaOptions)

SchemaProviderBase.GetDataTypeByProviderDbType(int, GetSchemaOptions)

SchemaProviderBase.GetProcedureSchema(DataConnection, string, CommandType, DataParameter[], GetSchemaOptions)

SchemaProviderBase.GetProcedureResultColumns(DataTable, GetSchemaOptions)

SchemaProviderBase.GetServerVersion(DataConnection)

SchemaProviderBase.GetDataSourceName(DataConnection)

SchemaProviderBase.GetDatabaseName(DataConnection)

SchemaProviderBase.InitProvider(DataConnection, GetSchemaOptions)

SchemaProviderBase.GetDataTypes(DataConnection)

SchemaProviderBase.GetSystemType(string, string, DataTypeInfo, int?, int?, int?, GetSchemaOptions)

SchemaProviderBase.GetDbType(GetSchemaOptions, string, DataTypeInfo, int?, int?, int?, string, string, string)

SchemaProviderBase.ToValidName(string)

SchemaProviderBase.ToTypeName(Type, bool)

SchemaProviderBase.ProcessSchema(DatabaseSchema, GetSchemaOptions)

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

SqlServerSchemaProvider(SqlServerDataProvider)

public SqlServerSchemaProvider(SqlServerDataProvider provider)

Parameters

provider SqlServerDataProvider

Methods

BuildProcedureParameter(ParameterSchema)

protected override DataParameter BuildProcedureParameter(ParameterSchema p)

Parameters

p ParameterSchema

Returns

DataParameter

BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema, string)

Builds table function call command.

protected override string BuildTableFunctionLoadTableSchemaCommand(ProcedureSchema procedure, string commandText)

Parameters

procedure ProcedureSchema

commandText string

Returns

string

GetColumns(DataConnection, GetSchemaOptions)

protected override List<ColumnInfo> GetColumns(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<ColumnInfo>

GetDataType(string?, string?, int?, int?, int?)

protected override DataType GetDataType(string? dataType, string? columnType, int? length, int? precision, int? scale)

Parameters

dataType string

columnType string

length int?

precision int?

scale int?

Returns

DataType

GetDataTypes(DataConnection)

Returns list of database data types.

protected override List<DataTypeInfo> GetDataTypes(DataConnection dataConnection)

Parameters

dataConnection DataConnection

Database connection instance.

Returns

List<DataTypeInfo>

List of database data types.

GetDbType(GetSchemaOptions, string?, DataTypeInfo?, int?, int?, int?, string?, string?, string?)

protected override string? GetDbType(GetSchemaOptions options, string? columnType, DataTypeInfo? dataType, int? length, int? precision, int? scale, string? udtCatalog, string? udtSchema, string? udtName)

Parameters

options GetSchemaOptions

columnType string

dataType DataTypeInfo

length int?

precision int?

scale int?

udtCatalog string

udtSchema string

udtName string

Returns

string

GetForeignKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

protected override IReadOnlyCollection<ForeignKeyInfo> GetForeignKeys(DataConnection dataConnection, IEnumerable<TableSchema> tables, GetSchemaOptions options)

Parameters

dataConnection DataConnection

tables IEnumerable<TableSchema>

options GetSchemaOptions

Returns

IReadOnlyCollection<ForeignKeyInfo>

GetPrimaryKeys(DataConnection, IEnumerable<TableSchema>, GetSchemaOptions)

protected override IReadOnlyCollection<PrimaryKeyInfo> GetPrimaryKeys(DataConnection dataConnection, IEnumerable<TableSchema> tables, GetSchemaOptions options)

Parameters

dataConnection DataConnection

tables IEnumerable<TableSchema>

options GetSchemaOptions

Returns

IReadOnlyCollection<PrimaryKeyInfo>

GetProcedureParameters(DataConnection, IEnumerable<ProcedureInfo>, GetSchemaOptions)

protected override List<ProcedureParameterInfo> GetProcedureParameters(DataConnection dataConnection, IEnumerable<ProcedureInfo> procedures, GetSchemaOptions options)

Parameters

dataConnection DataConnection

procedures IEnumerable<ProcedureInfo>

options GetSchemaOptions

Returns

List<ProcedureParameterInfo>

GetProcedureSchema(DataConnection, string, CommandType, DataParameter[], GetSchemaOptions)

protected override DataTable? GetProcedureSchema(DataConnection dataConnection, string commandText, CommandType commandType, DataParameter[] parameters, GetSchemaOptions options)

Parameters

dataConnection DataConnection

commandText string

commandType CommandType

parameters DataParameter[]

options GetSchemaOptions

Returns

DataTable

GetProcedures(DataConnection, GetSchemaOptions)

protected override List<ProcedureInfo>? GetProcedures(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<ProcedureInfo>

GetProviderSpecificType(string?)

protected override string? GetProviderSpecificType(string? dataType)

Parameters

dataType string

Returns

string

GetProviderSpecificTypeNamespace()

protected override string GetProviderSpecificTypeNamespace()

Returns

string

GetSystemType(string?, string?, DataTypeInfo?, int?, int?, int?, GetSchemaOptions)

protected override Type? GetSystemType(string? dataType, string? columnType, DataTypeInfo? dataTypeInfo, int? length, int? precision, int? scale, GetSchemaOptions options)

Parameters

dataType string

columnType string

dataTypeInfo DataTypeInfo

length int?

precision int?

scale int?

options GetSchemaOptions

Returns

Type

GetTables(DataConnection, GetSchemaOptions)

protected override List<TableInfo> GetTables(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions

Returns

List<TableInfo>

InitProvider(DataConnection, GetSchemaOptions)

protected override void InitProvider(DataConnection dataConnection, GetSchemaOptions options)

Parameters

dataConnection DataConnection

options GetSchemaOptions