C# Class MigSharp.Providers.SqlServerProviderBase

Inheritance: IProvider

Show file Open project: dradovic/MigSharp

Public Methods

Method	Description
AddColumn ( TableName tableName, Column column ) : IEnumerable
AddForeignKey ( TableName tableName, TableName referencedTableName, IEnumerable columnNames, string constraintName, bool cascadeOnDelete ) : IEnumerable
AddIndex ( TableName tableName, IEnumerable columnNames, string indexName ) : IEnumerable
AddPrimaryKey ( TableName tableName, IEnumerable columnNames, string constraintName ) : IEnumerable
AddUniqueConstraint ( TableName tableName, IEnumerable columnNames, string constraintName ) : IEnumerable
AlterColumn ( TableName tableName, Column column ) : IEnumerable
ConvertToSql ( object value, DbType targetDbType ) : string
CreateSchema ( string schemaName ) : IEnumerable
CreateTable ( TableName tableName, IEnumerable columns, string primaryKeyConstraintName ) : IEnumerable
DropColumn ( TableName tableName, string columnName ) : IEnumerable
DropDefault ( TableName tableName, Column column ) : IEnumerable
DropForeignKey ( TableName tableName, string constraintName ) : IEnumerable
DropIndex ( TableName tableName, string indexName ) : IEnumerable
DropPrimaryKey ( TableName tableName, string constraintName ) : IEnumerable
DropSchema ( string schemaName ) : IEnumerable
DropTable ( TableName tableName, bool checkIfExists ) : IEnumerable
DropUniqueConstraint ( TableName tableName, string constraintName ) : IEnumerable
ExistsTable ( string databaseName, TableName tableName ) : string
GetSchemaPrefix ( TableName tableName ) : string
GetTableQualifier ( TableName tableName ) : string
RenameColumn ( TableName tableName, string oldName, string newName ) : IEnumerable
RenamePrimaryKey ( TableName tableName, string oldName, string newName ) : IEnumerable
RenameTable ( TableName oldName, string newName ) : IEnumerable

Protected Methods

Method	Description
DropConstraint ( TableName tableName, string constraintName ) : string
DropDefaultConstraint ( TableName tableName, string columnName, bool checkIfExists ) : IEnumerable
Escape ( string name ) : string
GetDefaultConstraintName ( string tableName, string columnName ) : string
GetTypeSpecifier ( DataType dataType, bool isRowVersion ) : string

Private Methods

Method	Description
AddConstraint ( TableName tableName, string constraintName, IEnumerable columnNames, string constraintType ) : IEnumerable
AlterTable ( TableName tableName ) : string
CreateTable ( TableName tableName ) : string
GetDefaultConstraintClause ( TableName tableName, string columnName, object value, DataType dataType ) : string
GetDefaultValueAsString ( object value, DataType dataType ) : string

Method Details

AddColumn() public method

public AddColumn ( TableName tableName, Column column ) : IEnumerable
tableName	TableName
column	Column
return	IEnumerable

AddForeignKey() public method

public AddForeignKey ( TableName tableName, TableName referencedTableName, IEnumerable columnNames, string constraintName, bool cascadeOnDelete ) : IEnumerable
tableName	TableName
referencedTableName	TableName
columnNames	IEnumerable
constraintName	string
cascadeOnDelete	bool
return	IEnumerable

AddIndex() public method

public AddIndex ( TableName tableName, IEnumerable columnNames, string indexName ) : IEnumerable
tableName	TableName
columnNames	IEnumerable
indexName	string
return	IEnumerable

AddPrimaryKey() public method

public AddPrimaryKey ( TableName tableName, IEnumerable columnNames, string constraintName ) : IEnumerable
tableName	TableName
columnNames	IEnumerable
constraintName	string
return	IEnumerable

AddUniqueConstraint() public method

public AddUniqueConstraint ( TableName tableName, IEnumerable columnNames, string constraintName ) : IEnumerable
tableName	TableName
columnNames	IEnumerable
constraintName	string
return	IEnumerable

AlterColumn() public method

public AlterColumn ( TableName tableName, Column column ) : IEnumerable
tableName	TableName
column	Column
return	IEnumerable

ConvertToSql() public method

public ConvertToSql ( object value, DbType targetDbType ) : string
value	object
targetDbType	DbType
return	string

CreateSchema() public abstract method

public abstract CreateSchema ( string schemaName ) : IEnumerable
schemaName	string
return	IEnumerable

CreateTable() public method

public CreateTable ( TableName tableName, IEnumerable columns, string primaryKeyConstraintName ) : IEnumerable
tableName	TableName
columns	IEnumerable
primaryKeyConstraintName	string
return	IEnumerable

DropColumn() public method

public DropColumn ( TableName tableName, string columnName ) : IEnumerable
tableName	TableName
columnName	string
return	IEnumerable

DropConstraint() protected method

protected DropConstraint ( TableName tableName, string constraintName ) : string
tableName	TableName
constraintName	string
return	string

DropDefault() public method

public DropDefault ( TableName tableName, Column column ) : IEnumerable
tableName	TableName
column	Column
return	IEnumerable

DropDefaultConstraint() protected abstract method

protected abstract DropDefaultConstraint ( TableName tableName, string columnName, bool checkIfExists ) : IEnumerable
tableName	TableName
columnName	string
checkIfExists	bool
return	IEnumerable

DropForeignKey() public method

public DropForeignKey ( TableName tableName, string constraintName ) : IEnumerable
tableName	TableName
constraintName	string
return	IEnumerable

DropIndex() public abstract method

public abstract DropIndex ( TableName tableName, string indexName ) : IEnumerable
tableName	TableName
indexName	string
return	IEnumerable

DropPrimaryKey() public method

public DropPrimaryKey ( TableName tableName, string constraintName ) : IEnumerable
tableName	TableName
constraintName	string
return	IEnumerable

DropSchema() public abstract method

public abstract DropSchema ( string schemaName ) : IEnumerable
schemaName	string
return	IEnumerable

DropTable() public method

public DropTable ( TableName tableName, bool checkIfExists ) : IEnumerable
tableName	TableName
checkIfExists	bool
return	IEnumerable

DropUniqueConstraint() public method

public DropUniqueConstraint ( TableName tableName, string constraintName ) : IEnumerable
tableName	TableName
constraintName	string
return	IEnumerable

Escape() protected static method

protected static Escape ( string name ) : string
name	string
return	string

ExistsTable() public abstract method

public abstract ExistsTable ( string databaseName, TableName tableName ) : string
databaseName	string
tableName	TableName
return	string

GetDefaultConstraintName() protected static method

protected static GetDefaultConstraintName ( string tableName, string columnName ) : string
tableName	string
columnName	string
return	string

GetSchemaPrefix() public abstract method

public abstract GetSchemaPrefix ( TableName tableName ) : string
tableName	TableName
return	string

GetTableQualifier() public method

public GetTableQualifier ( TableName tableName ) : string
tableName	TableName
return	string

GetTypeSpecifier() protected abstract method

protected abstract GetTypeSpecifier ( DataType dataType, bool isRowVersion ) : string
dataType	DataType
isRowVersion	bool
return	string

RenameColumn() public abstract method

public abstract RenameColumn ( TableName tableName, string oldName, string newName ) : IEnumerable
tableName	TableName
oldName	string
newName	string
return	IEnumerable

RenamePrimaryKey() public abstract method

public abstract RenamePrimaryKey ( TableName tableName, string oldName, string newName ) : IEnumerable
tableName	TableName
oldName	string
newName	string
return	IEnumerable

RenameTable() public abstract method

public abstract RenameTable ( TableName oldName, string newName ) : IEnumerable
oldName	TableName
newName	string
return	IEnumerable