C# Class MySql.Data.MySqlClient.SchemaProvider

Afficher le fichier Open project: elevate/mysqlconnector-.net Class Usage Examples

Méthodes publiques

Свойство	Type	Description
MetaCollection	string

Protected Properties

Свойство	Type	Description
connection	MySqlConnection

Méthodes publiques

Méthode	Description
GetColumns ( string restrictions ) : DataTable
GetDatabases ( string restrictions ) : DataTable
GetForeignKeyColumns ( string restrictions ) : DataTable
GetForeignKeys ( string restrictions ) : DataTable
GetIndexColumns ( string restrictions ) : DataTable
GetIndexes ( string restrictions ) : DataTable
GetProcedures ( string restrictions ) : DataTable
GetSchema ( string collection, String restrictions ) : DataTable
GetTables ( string restrictions ) : DataTable
GetUDF ( string restrictions ) : DataTable
GetUsers ( string restrictions ) : DataTable
SchemaProvider ( MySqlConnection connectionToUse ) : System

Méthodes protégées

Méthode	Description
FillTable ( DataTable dt, object data ) : void
GetCollections ( ) : DataTable
GetRestrictions ( ) : DataTable
GetSchemaInternal ( string collection, string restrictions ) : DataTable

Private Methods

Méthode	Description
CleanRestrictions ( string restrictionValues ) : string[]
FindTables ( DataTable schemaTable, string restrictions ) : void
GetDataSourceInformation ( ) : DataTable
GetDataTypes ( ) : DataTable
GetForeignKeysOnTable ( DataTable fkTable, DataRow tableToParse, string filterName, bool includeColumns ) : void	GetForeignKeysOnTable retrieves the foreign keys on the given table. Since MySQL supports foreign keys on versions prior to 5.0, we can't use information schema. MySQL also does not include any type of SHOW command for foreign keys so we have to resort to use SHOW CREATE TABLE and parsing the output.
GetReservedWords ( ) : DataTable
GetSqlMode ( ) : string
GetString ( MySqlDataReader reader, int index ) : string
LoadTableColumns ( DataTable dt, string schema, string tableName, string columnRestriction ) : void
ParseColumnRow ( DataRow row ) : void
ParseColumns ( MySqlTokenizer tokenizer ) : ArrayList
ParseConstraint ( DataTable fkTable, DataRow table, MySqlTokenizer tokenizer, bool includeColumns ) : void
ProcessColumns ( DataTable fkTable, DataRow row, ArrayList srcColumns, ArrayList targetColumns ) : void

Method Details

FillTable() protected static méthode

protected static FillTable ( DataTable dt, object data ) : void
dt	System.Data.DataTable
data	object
Résultat	void

GetCollections() protected méthode

protected GetCollections ( ) : DataTable
Résultat	System.Data.DataTable

GetColumns() public méthode

public GetColumns ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetDatabases() public méthode

public GetDatabases ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetForeignKeyColumns() public méthode

public GetForeignKeyColumns ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetForeignKeys() public méthode

public GetForeignKeys ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetIndexColumns() public méthode

public GetIndexColumns ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetIndexes() public méthode

public GetIndexes ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetProcedures() public méthode

public GetProcedures ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetRestrictions() protected méthode

protected GetRestrictions ( ) : DataTable
Résultat	System.Data.DataTable

GetSchema() public méthode

public GetSchema ( string collection, String restrictions ) : DataTable
collection	string
restrictions	String
Résultat	System.Data.DataTable

GetSchemaInternal() protected méthode

protected GetSchemaInternal ( string collection, string restrictions ) : DataTable
collection	string
restrictions	string
Résultat	System.Data.DataTable

GetTables() public méthode

public GetTables ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetUDF() public méthode

public GetUDF ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

GetUsers() public méthode

public GetUsers ( string restrictions ) : DataTable
restrictions	string
Résultat	System.Data.DataTable

SchemaProvider() public méthode

public SchemaProvider ( MySqlConnection connectionToUse ) : System
connectionToUse	MySqlConnection
Résultat	System

Property Details

MetaCollection public_oe static_oe property

public static string MetaCollection
Résultat	string

connection protected_oe property

protected MySqlConnection,MySql.Data.MySqlClient connection
Résultat	MySqlConnection