Back to all docs
API Reference / Telerik.OpenAccess.Runtime.Schema / MssqlSchemaReader

Class
MssqlSchemaReader

Definition

Namespace:Telerik.OpenAccess.Runtime.Schema

Assembly:Telerik.OpenAccess.Runtime.dll

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

Inheritance: objectDbSchemaReaderDbSchemaReaderImpMssqlSchemaReader

Derived Classes: AzureSchemaReader

Implements: DbSchemaReader.ISchemaReaderInformationDbSchemaReader.IServerVersionDbSchemaReader.IToken

Inherited Members DbSchemaReaderImp.backendTypeDbSchemaReaderImp.rDelimDbSchemaReaderImp.lDelimDbSchemaReaderImp.parameterPrefixDbSchemaReaderImp.serverVersionDbSchemaReaderImp.sqlDriverDbSchemaReaderImp.providerTypeToTypeNameDbSchemaReaderImp.tablesDbSchemaReaderImp.proceduresDbSchemaReaderImp.udtsDbSchemaReaderImp.dbConnectionDbSchemaReaderImp.defaultSchemaDbSchemaReaderImp.additionalDatabasesDbSchemaReaderImp.systemSchemasDbSchemaReaderImp.systemTablesDbSchemaReaderImp.systemStoredProceduresDbSchemaReaderImp.schemaCollectionsDbSchemaReaderImp.readerPreparedDbSchemaReaderImp.typename2typeDbSchemaReaderImp.columnPropertyToNameDbSchemaReaderImp.GetControlParams()DbSchemaReaderImp.GetContainer()DbSchemaReaderImp.ReadCurrentDatabase()DbSchemaReaderImp.IsSystemObject(string, DbSchemaReaderImp.SchemaCollection)DbSchemaReaderImp.GetProceduresCollection(string[])DbSchemaReaderImp.GetProcedureParameterCollection(string[])DbSchemaReaderImp.GetDatabasesCollection(string[])DbSchemaReaderImp.GetTablesCollection(string[])DbSchemaReaderImp.GetColumnsCollection(string[])DbSchemaReaderImp.GetIndexesCollection(string[])DbSchemaReaderImp.GetForeignKeysCollection(string[])DbSchemaReaderImp.GetSchemasCollection(string[])DbSchemaReaderImp.IsProcedure(string)DbSchemaReaderImp.IsFunction(string)DbSchemaReaderImp.IsDeterministicFunction(string)DbSchemaReaderImp.IsScalarFunction(MetaStoredProcedure)DbSchemaReaderImp.MapSqlType(string)DbSchemaReaderImp.FixAndAddConstraintsToTable(RelationalTable, ICollection<RelationalConstraint>, bool, bool)DbSchemaReaderImp.InitializeColumnPropertyMap()DbSchemaReaderImp.HandleProcedureExecutionFailure(Exception)DbSchemaReaderImp.ProcedureReturnsResultSet(MetaStoredProcedure)DbSchemaReaderImp.FixTypeMapping()DbSchemaReaderImp.ReadAdditionalDatabase(string)DbSchemaReaderImp.GetDefaultSchema()DbSchemaReaderImp.Execute()DbSchemaReaderImp.BeginExecute(Action<DbSchemaReader>)DbSchemaReaderImp.SetupGetResultShapeCommand(MetaStoredProcedure, DbCommand)DbSchemaReaderImp.GetProcedureResultShape(MetaStoredProcedure)DbSchemaReaderImp.MapDataType2OpenAccessType(string, string, int)DbSchemaReaderImp.GetParameterName(MetaStoredProcedureParameter)DbSchemaReaderImp.ToReferentialAction(string)DbSchemaReaderImp.ProgressMaxPhasesDbSchemaReaderImp.ActualPhaseDbSchemaReaderImp.ParameterPrefixDbSchemaReaderImp.ConstraintsAsIndexesDbSchemaReaderImp.BackendDbSchemaReaderImp.ADODriverDbSchemaReaderImp.RelationalTablesDbSchemaReaderImp.RelationalProceduresDbSchemaReaderImp.RelationalUDTsDbSchemaReaderImp.BackendTypeDbSchemaReaderImp.VersionDbSchemaReaderImp.MajorVersionDbSchemaReaderImp.MinorVersionDbSchemaReaderImp.BuildDbSchemaReaderImp.EditionDbSchemaReaderImp.RightDelimiterDbSchemaReaderImp.LeftDelimiterDbSchemaReader.Create(DbConnection)DbSchemaReader.Create(DbConnection, Backend)DbSchemaReader.OnProgress(DbSchemaReader.SchemaReadEventArgs.SchemaReadPhase, int, int)DbSchemaReader.ReadTablesDbSchemaReader.ReadViewsDbSchemaReader.ReadColumnsDbSchemaReader.ReadProceduresDbSchemaReader.ReadFunctionsDbSchemaReader.ReadConstraintsDbSchemaReader.ReadIndexesDbSchemaReader.ReadPrimaryKeysDbSchemaReader.SchemaFilterDbSchemaReader.LoggingProviderDbSchemaReader.MetadataContainerDbSchemaReader.Progress

Constructors

MssqlSchemaReader(DbConnection)

Declaration

cs-api-definition
public MssqlSchemaReader(DbConnection dbConnection)

Parameters

dbConnection

DbConnection

Fields

sqlIndex

Declaration

cs-api-definition
protected string sqlIndex

Field Value

string

Properties

SupportsSchemas

Declaration

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

Property Value

bool

Overrides DbSchemaReaderImp.SupportsSchemas

Methods

FinishDatabase()

Declaration

cs-api-definition
public override void FinishDatabase()

Overrides DbSchemaReaderImp.FinishDatabase()

FinishExecute()

Declaration

cs-api-definition
public override void FinishExecute()

Overrides DbSchemaReaderImp.FinishExecute()

GetAllSchemaNames()

Declaration

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

Returns

List<string>

Overrides DbSchemaReaderImp.GetAllSchemaNames()

GetColumns(QualifiedNameMap<RelationalTable>)

Declaration

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

Parameters

tables

QualifiedNameMap<RelationalTable>

Overrides DbSchemaReaderImp.GetColumns(QualifiedNameMap<RelationalTable>)

GetConstraints(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected override void GetConstraints(QualifiedNameMap<RelationalTable> jdbcTableMap)

Parameters

jdbcTableMap

QualifiedNameMap<RelationalTable>

Overrides DbSchemaReaderImp.GetConstraints(QualifiedNameMap<RelationalTable>)

GetCurrentDatabase()

Declaration

cs-api-definition
protected override string GetCurrentDatabase()

Returns

string

Overrides DbSchemaReaderImp.GetCurrentDatabase()

GetDatabases()

Declaration

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

Returns

List<string>

Overrides DbSchemaReaderImp.GetDatabases()

GetDefaultSchemaImp()

Declaration

cs-api-definition
protected override string GetDefaultSchemaImp()

Returns

string

Overrides DbSchemaReaderImp.GetDefaultSchemaImp()

GetIndexes(QualifiedNameMap<RelationalTable>)

Declaration

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

Parameters

tables

QualifiedNameMap<RelationalTable>

Overrides DbSchemaReaderImp.GetIndexes(QualifiedNameMap<RelationalTable>)

GetMetaResultSetColumnFromDataRow(DataRow)

Declaration

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

Parameters

row

DataRow

Returns

MetaResultSetColumn

Overrides DbSchemaReaderImp.GetMetaResultSetColumnFromDataRow(DataRow)

GetObjectNames(string)

Declaration

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

Parameters

filter

string

Returns

List<string>

Overrides DbSchemaReader.GetObjectNames(string)

GetPrimaryKeys(QualifiedNameMap<RelationalTable>)

Declaration

cs-api-definition
protected override void GetPrimaryKeys(QualifiedNameMap<RelationalTable> jdbcTableMap)

Parameters

jdbcTableMap

QualifiedNameMap<RelationalTable>

Overrides DbSchemaReaderImp.GetPrimaryKeys(QualifiedNameMap<RelationalTable>)

GetProcedureParameters(Dictionary<string, RelationalProcedure>)

Declaration

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

Parameters

procedures

Dictionary<string, RelationalProcedure>

Overrides DbSchemaReaderImp.GetProcedureParameters(Dictionary<string, RelationalProcedure>)

GetProcedures()

Declaration

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

Returns

Dictionary<string, RelationalProcedure>

Overrides DbSchemaReaderImp.GetProcedures()

GetSqlDriver()

Declaration

cs-api-definition
protected override SqlDriver GetSqlDriver()

Returns

SqlDriver

Overrides DbSchemaReaderImp.GetSqlDriver()

GetTablesAndViews()

Declaration

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

Returns

QualifiedNameMap<RelationalTable>

Overrides DbSchemaReaderImp.GetTablesAndViews()

GetUDTs()

Declaration

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

Returns

Dictionary<string, RelationalUDT>

Overrides DbSchemaReaderImp.GetUDTs()

InitializeProviderTypeMap()

Declaration

cs-api-definition
protected override void InitializeProviderTypeMap()

Overrides DbSchemaReaderImp.InitializeProviderTypeMap()

IsDefaultSchema(string)

Declaration

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

Parameters

schemaName

string

Returns

bool

Overrides DbSchemaReaderImp.IsDefaultSchema(string)

ObtainServerVersion()

Declaration

cs-api-definition
protected override void ObtainServerVersion()

Overrides DbSchemaReaderImp.ObtainServerVersion()

PrepareDatabase()

Declaration

cs-api-definition
public override void PrepareDatabase()

Overrides DbSchemaReaderImp.PrepareDatabase()

PrepareExecute()

Declaration

cs-api-definition
public override void PrepareExecute()

Overrides DbSchemaReaderImp.PrepareExecute()

PrepareReader()

Declaration

cs-api-definition
protected override void PrepareReader()

Overrides DbSchemaReaderImp.PrepareReader()

Reset()

Declaration

cs-api-definition
protected override void Reset()

Overrides DbSchemaReaderImp.Reset()

In this article
DefinitionConstructorsMssqlSchemaReader(DbConnection)FieldssqlIndexPropertiesSupportsSchemasMethodsFinishDatabase()FinishExecute()GetAllSchemaNames()GetColumns(QualifiedNameMap<RelationalTable>)GetConstraints(QualifiedNameMap<RelationalTable>)GetCurrentDatabase()GetDatabases()GetDefaultSchemaImp()GetIndexes(QualifiedNameMap<RelationalTable>)GetMetaResultSetColumnFromDataRow(DataRow)GetObjectNames(string)GetPrimaryKeys(QualifiedNameMap<RelationalTable>)GetProcedureParameters(Dictionary<string, RelationalProcedure>)GetProcedures()GetSqlDriver()GetTablesAndViews()GetUDTs()InitializeProviderTypeMap()IsDefaultSchema(string)ObtainServerVersion()PrepareDatabase()PrepareExecute()PrepareReader()Reset()
Not finding the help you need?
Contact Support