Class
DbSchemaReaderImp

Definition

Namespace:Telerik.OpenAccess.Runtime.Schema

Assembly:Telerik.OpenAccess.Runtime.dll

Syntax:

cs-api-definition
public abstract class DbSchemaReaderImp : DbSchemaReader, DbSchemaReader.ISchemaReaderInformation, DbSchemaReader.IServerVersion, DbSchemaReader.IToken

Inheritance: objectDbSchemaReaderDbSchemaReaderImp

Derived Classes: ADSSchemaReaderFirebirdSchemaReaderMssqlSchemaReaderOracleSchemaReaderPostgreSQLSchemaReaderSQLiteSchemaReaderSqlCESchemaReaderVistaDBSchemaReader

Implements: DbSchemaReader.ISchemaReaderInformationDbSchemaReader.IServerVersionDbSchemaReader.IToken

Inherited Members DbSchemaReader.Create(DbConnection)DbSchemaReader.Create(DbConnection, Backend)DbSchemaReader.OnProgress(DbSchemaReader.SchemaReadEventArgs.SchemaReadPhase, int, int)DbSchemaReader.GetObjectNames(string)DbSchemaReader.ReadTablesDbSchemaReader.ReadViewsDbSchemaReader.ReadColumnsDbSchemaReader.ReadProceduresDbSchemaReader.ReadFunctionsDbSchemaReader.ReadConstraintsDbSchemaReader.ReadIndexesDbSchemaReader.ReadPrimaryKeysDbSchemaReader.SchemaFilterDbSchemaReader.LoggingProviderDbSchemaReader.MetadataContainerDbSchemaReader.Progress

Constructors

DbSchemaReaderImp(DbConnection, Backend)

Declaration

cs-api-definition
public DbSchemaReaderImp(DbConnection dbConnection, Backend backendType)

Parameters

dbConnection

DbConnection

backendType

Backend

Fields

additionalDatabases

Declaration

cs-api-definition
protected readonly Dictionary<string, AdditionalDatabase> additionalDatabases

Field Value

Dictionary<string, AdditionalDatabase>

backendType

Declaration

cs-api-definition
protected Backend backendType

Field Value

Backend

columnPropertyToName

Declaration

cs-api-definition
protected Dictionary<MetadataConstants, string> columnPropertyToName

Field Value

Dictionary<MetadataConstants, string>

dbConnection

Declaration

cs-api-definition
protected DbConnection dbConnection

Field Value

DbConnection

defaultSchema

Declaration

cs-api-definition
protected string defaultSchema

Field Value

string

lDelim

Declaration

cs-api-definition
protected char lDelim

Field Value

char

parameterPrefix

Declaration

cs-api-definition
protected char? parameterPrefix

Field Value

char?

procedures

Declaration

cs-api-definition
protected List<RelationalProcedure> procedures

Field Value

List<RelationalProcedure>

providerTypeToTypeName

Declaration

cs-api-definition
protected Dictionary<int, string> providerTypeToTypeName

Field Value

Dictionary<int, string>

rDelim

Declaration

cs-api-definition
protected char rDelim

Field Value

char

readerPrepared

Declaration

cs-api-definition
protected bool readerPrepared

Field Value

bool

schemaCollections

Declaration

cs-api-definition
protected Dictionary<DbSchemaReaderImp.SchemaCollection, string> schemaCollections

Field Value

Dictionary<DbSchemaReaderImp.SchemaCollection, string>

serverVersion

Declaration

cs-api-definition
protected ServerVersion serverVersion

Field Value

ServerVersion

sqlDriver

Declaration

cs-api-definition
protected SqlDriver sqlDriver

Field Value

SqlDriver

systemSchemas

Declaration

cs-api-definition
protected readonly List<string> systemSchemas

Field Value

List<string>

systemStoredProcedures

Declaration

cs-api-definition
protected readonly List<string> systemStoredProcedures

Field Value

List<string>

systemTables

Declaration

cs-api-definition
protected readonly List<string> systemTables

Field Value

List<string>

tables

Declaration

cs-api-definition
protected Dictionary<string, RelationalTable> tables

Field Value

Dictionary<string, RelationalTable>

typename2type

Declaration

cs-api-definition
protected StringTypeInfoMap typename2type

Field Value

StringTypeInfoMap

udts

Declaration

cs-api-definition
protected Dictionary<string, RelationalUDT> udts

Field Value

Dictionary<string, RelationalUDT>

Properties

ADODriver

Declaration

cs-api-definition
public override AssemblyName ADODriver { get; }

Property Value

AssemblyName

Overrides DbSchemaReader.ADODriver

ActualPhase

Declaration

cs-api-definition
protected int ActualPhase { get; }

Property Value

int

Backend

Declaration

cs-api-definition
public override DbSchemaReader.ISchemaReaderInformation Backend { get; }

Property Value

DbSchemaReader.ISchemaReaderInformation

Overrides DbSchemaReader.Backend

BackendType

Declaration

cs-api-definition
public Backend BackendType { get; }

Property Value

Backend

Implements DbSchemaReader.ISchemaReaderInformation.BackendType

Build

Declaration

cs-api-definition
public short Build { get; }

Property Value

short

Implements DbSchemaReader.IServerVersion.Build

ConstraintsAsIndexes

Declaration

cs-api-definition
protected virtual bool ConstraintsAsIndexes { get; }

Property Value

bool

Edition

Declaration

cs-api-definition
public string Edition { get; }

Property Value

string

Implements DbSchemaReader.IServerVersion.Edition

LeftDelimiter

Declaration

cs-api-definition
public char LeftDelimiter { get; }

Property Value

char

Implements DbSchemaReader.IToken.LeftDelimiter

MajorVersion

Declaration

cs-api-definition
public short MajorVersion { get; }

Property Value

short

Implements DbSchemaReader.IServerVersion.MajorVersion

MinorVersion

Declaration

cs-api-definition
public short MinorVersion { get; }

Property Value

short

Implements DbSchemaReader.IServerVersion.MinorVersion

ParameterPrefix

Declaration

cs-api-definition
public virtual string ParameterPrefix { get; }

Property Value

string

ProgressMaxPhases

Declaration

cs-api-definition
protected int ProgressMaxPhases { get; }

Property Value

int

RelationalProcedures

Declaration

cs-api-definition
public override List<RelationalProcedure> RelationalProcedures { get; }

Property Value

List<RelationalProcedure>

Overrides DbSchemaReader.RelationalProcedures

RelationalTables

Declaration

cs-api-definition
public override Dictionary<string, RelationalTable> RelationalTables { get; }

Property Value

Dictionary<string, RelationalTable>

Overrides DbSchemaReader.RelationalTables

RelationalUDTs

Declaration

cs-api-definition
public override Dictionary<string, RelationalUDT> RelationalUDTs { get; }

Property Value

Dictionary<string, RelationalUDT>

Overrides DbSchemaReader.RelationalUDTs

RightDelimiter

Declaration

cs-api-definition
public char RightDelimiter { get; }

Property Value

char

Implements DbSchemaReader.IToken.RightDelimiter

SupportsSchemas

Declaration

cs-api-definition
public virtual bool SupportsSchemas { get; }

Property Value

bool

Implements DbSchemaReader.ISchemaReaderInformation.SupportsSchemas

Version

Declaration

cs-api-definition
public string Version { get; }

Property Value

string

Implements DbSchemaReader.IServerVersion.Version

Methods

BeginExecute(Action<DbSchemaReader>)

Declaration

cs-api-definition
public override void BeginExecute(Action<DbSchemaReader> action)

Parameters

action

Action<DbSchemaReader>

Overrides DbSchemaReader.BeginExecute(Action<DbSchemaReader>)

Execute()

Declaration

cs-api-definition
public override sealed void Execute()

Overrides DbSchemaReader.Execute()

FinishDatabase()

Declaration

cs-api-definition
public virtual void FinishDatabase()

FinishExecute()

Declaration

cs-api-definition
public virtual void FinishExecute()

FixAndAddConstraintsToTable(RelationalTable, ICollection<RelationalConstraint>, bool, bool)

Declaration

cs-api-definition
protected void FixAndAddConstraintsToTable(RelationalTable table, ICollection<RelationalConstraint> constraints, bool validOnly, bool sortByName)

Parameters

table

RelationalTable

constraints

ICollection<RelationalConstraint>

validOnly

bool

sortByName

bool

FixTypeMapping()

Declaration

cs-api-definition
protected virtual void FixTypeMapping()

GetAllSchemaNames()

Declaration

cs-api-definition
public override List<string> GetAllSchemaNames()

Returns

List<string>

Overrides DbSchemaReader.GetAllSchemaNames()

GetColumns(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected abstract void GetColumns(QualifiedNameMap<RelationalTable> tables)

Parameters

tables

QualifiedNameMap<RelationalTable>

GetColumnsCollection(string[])

Declaration

cs-api-definition
protected DataTable GetColumnsCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetConstraints(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected abstract void GetConstraints(QualifiedNameMap<RelationalTable> tables)

Parameters

tables

QualifiedNameMap<RelationalTable>

GetContainer()

Declaration

cs-api-definition
protected override MetadataContainer GetContainer()

Returns

MetadataContainer

Overrides DbSchemaReader.GetContainer()

GetControlParams()

Declaration

cs-api-definition
protected ControlParams GetControlParams()

Returns

ControlParams

GetCurrentDatabase()

Declaration

cs-api-definition
protected virtual string GetCurrentDatabase()

Returns

string

GetDatabases()

Declaration

cs-api-definition
public override List<string> GetDatabases()

Returns

List<string>

Overrides DbSchemaReader.GetDatabases()

GetDatabasesCollection(string[])

Declaration

cs-api-definition
protected DataTable GetDatabasesCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetDefaultSchema()

Declaration

cs-api-definition
public override string GetDefaultSchema()

Returns

string

Overrides DbSchemaReader.GetDefaultSchema()

GetDefaultSchemaImp()

Declaration

cs-api-definition
protected abstract string GetDefaultSchemaImp()

Returns

string

GetForeignKeysCollection(string[])

Declaration

cs-api-definition
protected DataTable GetForeignKeysCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetIndexes(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected abstract void GetIndexes(QualifiedNameMap<RelationalTable> tables)

Parameters

tables

QualifiedNameMap<RelationalTable>

GetIndexesCollection(string[])

Declaration

cs-api-definition
protected DataTable GetIndexesCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetMetaResultSetColumnFromDataRow(DataRow)

Declaration

cs-api-definition
protected virtual MetaResultSetColumn GetMetaResultSetColumnFromDataRow(DataRow row)

Parameters

row

DataRow

Returns

MetaResultSetColumn

GetParameterName(MetaStoredProcedureParameter)

Declaration

cs-api-definition
protected virtual string GetParameterName(MetaStoredProcedureParameter parameter)

Parameters

parameter

MetaStoredProcedureParameter

Returns

string

GetPrimaryKeys(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected abstract void GetPrimaryKeys(QualifiedNameMap<RelationalTable> tables)

Parameters

tables

QualifiedNameMap<RelationalTable>

GetProcedureParameterCollection(string[])

Declaration

cs-api-definition
protected DataTable GetProcedureParameterCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetProcedureParameters(Dictionary<string, RelationalProcedure>)

Declaration

cs-api-definition
protected virtual void GetProcedureParameters(Dictionary<string, RelationalProcedure> procedures)

Parameters

procedures

Dictionary<string, RelationalProcedure>

GetProcedureResultShape(MetaStoredProcedure)

Declaration

cs-api-definition
public override MetaStoredProcedure GetProcedureResultShape(MetaStoredProcedure procedure)

Parameters

procedure

MetaStoredProcedure

Returns

MetaStoredProcedure

Overrides DbSchemaReader.GetProcedureResultShape(MetaStoredProcedure)

GetProcedures()

Declaration

cs-api-definition
protected virtual Dictionary<string, RelationalProcedure> GetProcedures()

Returns

Dictionary<string, RelationalProcedure>

GetProceduresCollection(string[])

Declaration

cs-api-definition
protected DataTable GetProceduresCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetSchemasCollection(string[])

Declaration

cs-api-definition
protected DataTable GetSchemasCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetSqlDriver()

Declaration

cs-api-definition
protected abstract SqlDriver GetSqlDriver()

Returns

SqlDriver

GetTablesAndViews()

Declaration

cs-api-definition
protected abstract QualifiedNameMap<RelationalTable> GetTablesAndViews()

Returns

QualifiedNameMap<RelationalTable>

GetTablesCollection(string[])

Declaration

cs-api-definition
protected DataTable GetTablesCollection(string[] restrictionValues)

Parameters

restrictionValues

string[]

Returns

DataTable

GetUDTs()

Declaration

cs-api-definition
protected virtual Dictionary<string, RelationalUDT> GetUDTs()

Returns

Dictionary<string, RelationalUDT>

HandleProcedureExecutionFailure(Exception)

Declaration

cs-api-definition
protected virtual void HandleProcedureExecutionFailure(Exception ex)

Parameters

ex

Exception

InitializeColumnPropertyMap()

Declaration

cs-api-definition
protected virtual void InitializeColumnPropertyMap()

InitializeProviderTypeMap()

Declaration

cs-api-definition
protected virtual void InitializeProviderTypeMap()

IsDefaultSchema(string)

Declaration

cs-api-definition
protected virtual bool IsDefaultSchema(string schemaName)

Parameters

schemaName

string

Returns

bool

IsDeterministicFunction(string)

Declaration

cs-api-definition
protected static bool IsDeterministicFunction(string deterministicData)

Parameters

deterministicData

string

Returns

bool

IsFunction(string)

Declaration

cs-api-definition
protected static bool IsFunction(string routineType)

Parameters

routineType

string

Returns

bool

IsProcedure(string)

Declaration

cs-api-definition
protected static bool IsProcedure(string routineType)

Parameters

routineType

string

Returns

bool

IsScalarFunction(MetaStoredProcedure)

Declaration

cs-api-definition
protected static bool IsScalarFunction(MetaStoredProcedure procedure)

Parameters

procedure

MetaStoredProcedure

Returns

bool

IsSystemObject(string, SchemaCollection)

Declaration

cs-api-definition
protected virtual bool IsSystemObject(string objectName, DbSchemaReaderImp.SchemaCollection objectType)

Parameters

objectName

string

objectType

DbSchemaReaderImp.SchemaCollection

Returns

bool

MapDataType2OpenAccessType(string, string, int)

Declaration

cs-api-definition
protected virtual OpenAccessType MapDataType2OpenAccessType(string name, string clr, int code)

Parameters

name

string

clr

string

code

int

Returns

OpenAccessType

MapSqlType(string)

Declaration

cs-api-definition
protected TypeInfo MapSqlType(string name)

Parameters

name

string

Returns

TypeInfo

ObtainServerVersion()

Declaration

cs-api-definition
protected abstract void ObtainServerVersion()

PrepareDatabase()

Declaration

cs-api-definition
public virtual void PrepareDatabase()

PrepareExecute()

Declaration

cs-api-definition
public virtual void PrepareExecute()

PrepareReader()

Declaration

cs-api-definition
protected virtual void PrepareReader()

ProcedureReturnsResultSet(MetaStoredProcedure)

Declaration

cs-api-definition
protected virtual bool ProcedureReturnsResultSet(MetaStoredProcedure procedure)

Parameters

procedure

MetaStoredProcedure

Returns

bool

ReadAdditionalDatabase(string)

Declaration

cs-api-definition
public override AdditionalDatabase ReadAdditionalDatabase(string databaseName)

Parameters

databaseName

string

Returns

AdditionalDatabase

Overrides DbSchemaReader.ReadAdditionalDatabase(string)

ReadCurrentDatabase()

Declaration

cs-api-definition
protected void ReadCurrentDatabase()

Reset()

Declaration

cs-api-definition
protected virtual void Reset()

SetupGetResultShapeCommand(MetaStoredProcedure, DbCommand)

Declaration

cs-api-definition
public void SetupGetResultShapeCommand(MetaStoredProcedure procedure, DbCommand command)

Parameters

procedure

MetaStoredProcedure

command

DbCommand

ToReferentialAction(string)

Declaration

cs-api-definition
protected static ReferentialAction ToReferentialAction(string s)

Parameters

s

string

Returns

ReferentialAction

In this article
DefinitionConstructorsDbSchemaReaderImp(DbConnection, Backend)FieldsadditionalDatabasesbackendTypecolumnPropertyToNamedbConnectiondefaultSchemalDelimparameterPrefixproceduresproviderTypeToTypeNamerDelimreaderPreparedschemaCollectionsserverVersionsqlDriversystemSchemassystemStoredProceduressystemTablestablestypename2typeudtsPropertiesADODriverActualPhaseBackendBackendTypeBuildConstraintsAsIndexesEditionLeftDelimiterMajorVersionMinorVersionParameterPrefixProgressMaxPhasesRelationalProceduresRelationalTablesRelationalUDTsRightDelimiterSupportsSchemasVersionMethodsBeginExecute(Action<DbSchemaReader>)Execute()FinishDatabase()FinishExecute()FixAndAddConstraintsToTable(RelationalTable, ICollection<RelationalConstraint>, bool, bool)FixTypeMapping()GetAllSchemaNames()GetColumns(QualifiedNameMap<RelationalTable>)GetColumnsCollection(string[])GetConstraints(QualifiedNameMap<RelationalTable>)GetContainer()GetControlParams()GetCurrentDatabase()GetDatabases()GetDatabasesCollection(string[])GetDefaultSchema()GetDefaultSchemaImp()GetForeignKeysCollection(string[])GetIndexes(QualifiedNameMap<RelationalTable>)GetIndexesCollection(string[])GetMetaResultSetColumnFromDataRow(DataRow)GetParameterName(MetaStoredProcedureParameter)GetPrimaryKeys(QualifiedNameMap<RelationalTable>)GetProcedureParameterCollection(string[])GetProcedureParameters(Dictionary<string, RelationalProcedure>)GetProcedureResultShape(MetaStoredProcedure)GetProcedures()GetProceduresCollection(string[])GetSchemasCollection(string[])GetSqlDriver()GetTablesAndViews()GetTablesCollection(string[])GetUDTs()HandleProcedureExecutionFailure(Exception)InitializeColumnPropertyMap()InitializeProviderTypeMap()IsDefaultSchema(string)IsDeterministicFunction(string)IsFunction(string)IsProcedure(string)IsScalarFunction(MetaStoredProcedure)IsSystemObject(string, SchemaCollection)MapDataType2OpenAccessType(string, string, int)MapSqlType(string)ObtainServerVersion()PrepareDatabase()PrepareExecute()PrepareReader()ProcedureReturnsResultSet(MetaStoredProcedure)ReadAdditionalDatabase(string)ReadCurrentDatabase()Reset()SetupGetResultShapeCommand(MetaStoredProcedure, DbCommand)ToReferentialAction(string)
Not finding the help you need?
Contact Support