C# Class SubSonic.SqlGeneration.Schema.ANSISchemaGenerator

A schema generator for your DB

Inheritance: ISchemaGenerator

Afficher le fichier Open project: rally25rs/SubSonic-3.0

Protected Properties

Свойство	Type	Description
ADD_COLUMN	string
ALTER_COLUMN	string
CREATE_TABLE	string
DROP_COLUMN	string
DROP_TABLE	string
UPDATE_DEFAULTS	string

Méthodes publiques

Méthode	Description
BuildAddColumnStatement ( string tableName, IColumn column ) : string	Adds the column.
BuildAlterColumnStatement ( IColumn column ) : string	Alters the column.
BuildCreateTableStatement ( ITable table ) : string	Builds a CREATE TABLE statement.
BuildDropColumnStatement ( string tableName, string columnName ) : string	Removes the column.
BuildDropTableStatement ( ITable table ) : string	Builds a DROP TABLE statement.
ConvertDataTypeToDbType ( DbType dataType ) : DbType
ConvertDataValueForThisProvider ( object input ) : object
GenerateColumnAttributes ( IColumn column ) : string	Sets the column attributes.
GenerateColumns ( ITable table ) : string	Generates the columns.
GetDbType ( string sqlType ) : DbType
GetNativeType ( DbType dbType ) : string	Gets the type of the native.
GetTableFromDB ( IDataProvider provider, string tableName ) : ITable	Gets an ITable from the DB based on name
GetTableList ( IDataProvider provider ) : string[]	Creates a list of table names
SetColumnDefaults ( IColumn column ) : void

Méthodes protégées

Méthode	Description
BuildDropTableStatement ( string tableName ) : string	Builds a DROP TABLE statement.

Method Details

BuildAddColumnStatement() public méthode

Adds the column.

public BuildAddColumnStatement ( string tableName, IColumn column ) : string
tableName	string	Name of the table.
column	IColumn	The column.
Résultat	string

BuildAlterColumnStatement() public méthode

Alters the column.

public BuildAlterColumnStatement ( IColumn column ) : string
column	IColumn	The column.
Résultat	string

BuildCreateTableStatement() public méthode

Builds a CREATE TABLE statement.

public BuildCreateTableStatement ( ITable table ) : string
table	ITable
Résultat	string

BuildDropColumnStatement() public méthode

Removes the column.

public BuildDropColumnStatement ( string tableName, string columnName ) : string
tableName	string	Name of the table.
columnName	string	Name of the column.
Résultat	string

BuildDropTableStatement() public méthode

Builds a DROP TABLE statement.

public BuildDropTableStatement ( ITable table ) : string
table	ITable
Résultat	string

BuildDropTableStatement() protected méthode

Builds a DROP TABLE statement.

protected BuildDropTableStatement ( string tableName ) : string
tableName	string	Name of the table.
Résultat	string

ConvertDataTypeToDbType() public méthode

public ConvertDataTypeToDbType ( DbType dataType ) : DbType
dataType	DbType
Résultat	DbType

ConvertDataValueForThisProvider() public méthode

public ConvertDataValueForThisProvider ( object input ) : object
input	object
Résultat	object

GenerateColumnAttributes() public abstract méthode

Sets the column attributes.

public abstract GenerateColumnAttributes ( IColumn column ) : string
column	IColumn	The column.
Résultat	string

GenerateColumns() public méthode

Generates the columns.

public GenerateColumns ( ITable table ) : string
table	ITable	Table containing the columns.
Résultat	string

GetDbType() public abstract méthode

public abstract GetDbType ( string sqlType ) : DbType
sqlType	string
Résultat	DbType

GetNativeType() public abstract méthode

Gets the type of the native.

public abstract GetNativeType ( DbType dbType ) : string
dbType	DbType	Type of the db.
Résultat	string

GetTableFromDB() public méthode

Gets an ITable from the DB based on name

public GetTableFromDB ( IDataProvider provider, string tableName ) : ITable
provider	IDataProvider
tableName	string
Résultat	ITable

GetTableList() public méthode

Creates a list of table names

public GetTableList ( IDataProvider provider ) : string[]
provider	IDataProvider
Résultat	string[]

SetColumnDefaults() public méthode

public SetColumnDefaults ( IColumn column ) : void
column	IColumn
Résultat	void

Property Details

ADD_COLUMN protected_oe property

protected string ADD_COLUMN
Résultat	string

ALTER_COLUMN protected_oe property

protected string ALTER_COLUMN
Résultat	string

CREATE_TABLE protected_oe property

protected string CREATE_TABLE
Résultat	string

DROP_COLUMN protected_oe property

protected string DROP_COLUMN
Résultat	string

DROP_TABLE protected_oe property

protected string DROP_TABLE
Résultat	string

UPDATE_DEFAULTS protected_oe property

protected string UPDATE_DEFAULTS
Résultat	string