C# Class MySql.Data.MySqlClient.ISSchemaProvider

Inheritance: SchemaProvider
显示文件 Open project: elevate/mysqlconnector-.net Class Usage Examples

Public Methods

Method Description
GetColumns ( string restrictions ) : DataTable
GetDatabases ( string restrictions ) : DataTable
GetForeignKeyColumns ( string restrictions ) : DataTable
GetForeignKeys ( string restrictions ) : DataTable
GetProcedureParameters ( string restrictions, DataTable routines ) : DataTable

Return schema information about parameters for procedures and functions Restrictions supported are: schema, name, type, parameter name

GetProcedures ( string restrictions ) : DataTable

Return schema information about procedures and functions Restrictions supported are: schema, name, type

GetTables ( string restrictions ) : DataTable
ISSchemaProvider ( MySqlConnection connection ) : System

Protected Methods

Method Description
GetCollections ( ) : DataTable
GetRestrictions ( ) : DataTable
GetSchemaInternal ( string collection, string restrictions ) : DataTable

Private Methods

Method Description
CreateParametersTable ( ) : DataTable
GetDataTypeDefaults ( string type, DataRow row ) : string
GetParametersForRoutineFromIS ( DataTable dt, string restrictions ) : void
GetParametersFromIS ( string restrictions, DataTable routines ) : DataTable
GetParametersFromShowCreate ( DataTable parametersTable, string restrictions, DataTable routines ) : void
GetProcedureParameterLine ( DataRow isRow ) : string
GetProceduresWithParameters ( string restrictions ) : DataTable
GetTable ( string sql ) : DataTable
GetTriggers ( string restrictions ) : DataTable
GetViewColumns ( string restrictions ) : DataTable
GetViews ( string restrictions ) : DataTable
GetWhereClause ( string initial_where, string keys, string values ) : string
InitParameterRow ( DataRow procedure, DataRow parameter ) : void

Initializes a new row for the procedure parameters table.

ParseDataType ( DataRow row, MySqlTokenizer tokenizer ) : string

Parses out the elements of a procedure parameter data type.

ParseDataTypeSize ( DataRow row, string size ) : void
ParseProcedureBody ( DataTable parametersTable, string body, DataRow row, string nameToRestrict ) : void
Query ( string table_name, string initial_where, string keys, string values ) : DataTable

Method Details

GetCollections() protected method

protected GetCollections ( ) : DataTable
return System.Data.DataTable

GetColumns() public method

public GetColumns ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

GetDatabases() public method

public GetDatabases ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

GetForeignKeyColumns() public method

public GetForeignKeyColumns ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

GetForeignKeys() public method

public GetForeignKeys ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

GetProcedureParameters() public method

Return schema information about parameters for procedures and functions Restrictions supported are: schema, name, type, parameter name
public GetProcedureParameters ( string restrictions, DataTable routines ) : DataTable
restrictions string
routines System.Data.DataTable
return System.Data.DataTable

GetProcedures() public method

Return schema information about procedures and functions Restrictions supported are: schema, name, type
public GetProcedures ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

GetRestrictions() protected method

protected GetRestrictions ( ) : DataTable
return System.Data.DataTable

GetSchemaInternal() protected method

protected GetSchemaInternal ( string collection, string restrictions ) : DataTable
collection string
restrictions string
return System.Data.DataTable

GetTables() public method

public GetTables ( string restrictions ) : DataTable
restrictions string
return System.Data.DataTable

ISSchemaProvider() public method

public ISSchemaProvider ( MySqlConnection connection ) : System
connection MySqlConnection
return System