Class PostgreSQLSchemaProvider

Namespace

LinqToDB.Internal.DataProvider.PostgreSQL

Assembly

linq2db.dll

public class PostgreSQLSchemaProvider : SchemaProviderBase, ISchemaProvider

Inheritance

object

SchemaProviderBase

PostgreSQLSchemaProvider

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

PostgreSQLSchemaProvider(PostgreSQLDataProvider)

public PostgreSQLSchemaProvider(PostgreSQLDataProvider provider)

Parameters

provider PostgreSQLDataProvider

Methods

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?, DataType?, GetSchemaOptions)

protected override DataTypeInfo? GetDataType(string? typeName, DataType? dataType, GetSchemaOptions options)

Parameters

typeName string

dataType DataType?

options GetSchemaOptions

Returns

DataTypeInfo

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>

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

GetSchema(DataConnection, GetSchemaOptions?)

Returns database schema. Note that it is recommended to call this method outside of transaction as some providers do not support it or behave incorrectly. At least following providers shouldn't be called in transaction:

• MySQL;
• Microsoft SQL Server;
• Sybase;
• DB2.

public override DatabaseSchema GetSchema(DataConnection dataConnection, GetSchemaOptions? options = null)

Parameters

dataConnection DataConnection

Data connection to use to read schema from.

options GetSchemaOptions

Schema read configuration options.

Returns

DatabaseSchema

Returns database schema information.

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>