C# Class Migrator.Providers.SqlServer.SqlServerTransformationProvider

Migration transformations provider for Microsoft SQL Server.

Inheritance: TransformationProvider

Datei anzeigen Open project: asynchrony/Migrator.NET Class Usage Examples

Public Methods

Method	Description
AddColumn ( string table, string sqlColumn ) : void
ColumnExists ( string table, string column ) : bool
ConstraintExists ( string table, string name ) : bool
RemoveColumn ( string table, string column ) : void
RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void
RenameTable ( string oldName, string newName ) : void
SqlServerTransformationProvider ( Migrator.Framework.Dialect dialect, string connectionString ) : System
TableExists ( string table ) : bool

Protected Methods

Method	Description
CreateConnection ( ) : void
FindConstraints ( string table, string column ) : string
GetSchemaName ( string longTableName ) : string
GetTableName ( string longTableName ) : string
RemoveBrackets ( string stringWithBrackets ) : string
SplitTableName ( string longTableName ) : string[]

Private Methods

Method	Description
DeleteColumnConstraints ( string table, string column ) : void

Method Details

AddColumn() public method

public AddColumn ( string table, string sqlColumn ) : void
table	string
sqlColumn	string
return	void

ColumnExists() public method

public ColumnExists ( string table, string column ) : bool
table	string
column	string
return	bool

ConstraintExists() public method

public ConstraintExists ( string table, string name ) : bool
table	string
name	string
return	bool

CreateConnection() protected method

protected CreateConnection ( ) : void
return	void

FindConstraints() protected method

protected FindConstraints ( string table, string column ) : string
table	string
column	string
return	string

GetSchemaName() protected method

protected GetSchemaName ( string longTableName ) : string
longTableName	string
return	string

GetTableName() protected method

protected GetTableName ( string longTableName ) : string
longTableName	string
return	string

RemoveBrackets() protected method

protected RemoveBrackets ( string stringWithBrackets ) : string
stringWithBrackets	string
return	string

RemoveColumn() public method

public RemoveColumn ( string table, string column ) : void
table	string
column	string
return	void

RenameColumn() public method

public RenameColumn ( string tableName, string oldColumnName, string newColumnName ) : void
tableName	string
oldColumnName	string
newColumnName	string
return	void

RenameTable() public method

public RenameTable ( string oldName, string newName ) : void
oldName	string
newName	string
return	void

SplitTableName() protected method

protected SplitTableName ( string longTableName ) : string[]
longTableName	string
return	string[]

SqlServerTransformationProvider() public method

public SqlServerTransformationProvider ( Migrator.Framework.Dialect dialect, string connectionString ) : System
dialect	Migrator.Framework.Dialect
connectionString	string
return	System

TableExists() public method

public TableExists ( string table ) : bool
table	string
return	bool