Class MySqlSchemaProvider

Namespace

LinqToDB.Internal.DataProvider.MySql

Assembly

linq2db.dll

public class MySqlSchemaProvider : SchemaProviderBase, ISchemaProvider

Inheritance

object

SchemaProviderBase

MySqlSchemaProvider

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

MySqlSchemaProvider(MySqlDataProvider)

public MySqlSchemaProvider(MySqlDataProvider provider)

Parameters

provider MySqlDataProvider

Properties

GetProcedureSchemaExecutesProcedure

If true, provider doesn't support schema-only procedure execution and will execute procedure for real.

protected override bool GetProcedureSchemaExecutesProcedure { get; }

Property Value

bool

Methods

BuildProcedureParameter(ParameterSchema)

protected override DataParameter BuildProcedureParameter(ParameterSchema p)

Parameters

p ParameterSchema

Returns

DataParameter

ForeignKeyColumnComparison(string)

protected override StringComparison ForeignKeyColumnComparison(string column)

Parameters

column string

Returns

StringComparison

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.

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>

GetProcedureResultColumns(DataTable, GetSchemaOptions)

protected override List<ColumnSchema> GetProcedureResultColumns(DataTable resultTable, GetSchemaOptions options)

Parameters

resultTable DataTable

options GetSchemaOptions

Returns

List<ColumnSchema>

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>