Class SqlServerProcessor

Inheritance

object

ProcessorBase

GenericProcessorBase

SqlServerProcessor

SqlServer2005Processor

SqlServer2005Processor

SqlServer2005Processor

SqlServer2008Processor

SqlServer2008Processor

SqlServer2008Processor

SqlServer2012Processor

SqlServer2012Processor

SqlServer2012Processor

SqlServer2014Processor

SqlServer2014Processor

SqlServer2014Processor

SqlServer2016Processor

SqlServer2016Processor

SqlServer2016Processor

Implements

IMigrationProcessor

IQuerySchema

IDisposable

Inherited Members

GenericProcessorBase.ConnectionString

GenericProcessorBase.Connection

GenericProcessorBase.Factory

GenericProcessorBase.Transaction

GenericProcessorBase.DbProviderFactory

GenericProcessorBase.EnsureConnectionIsOpen()

GenericProcessorBase.EnsureConnectionIsClosed()

GenericProcessorBase.Dispose(bool)

GenericProcessorBase.CreateCommand(string)

GenericProcessorBase.CreateCommand(string, IDbConnection, IDbTransaction)

ProcessorBase.Generator

ProcessorBase.Announcer

ProcessorBase.WasCommitted

ProcessorBase.Logger

ProcessorBase.Options

ProcessorBase.Process(CreateSchemaExpression)

ProcessorBase.Process(DeleteSchemaExpression)

ProcessorBase.Process(CreateTableExpression)

ProcessorBase.Process(AlterTableExpression)

ProcessorBase.Process(AlterColumnExpression)

ProcessorBase.Process(CreateColumnExpression)

ProcessorBase.Process(DeleteTableExpression)

ProcessorBase.Process(DeleteColumnExpression)

ProcessorBase.Process(CreateForeignKeyExpression)

ProcessorBase.Process(DeleteForeignKeyExpression)

ProcessorBase.Process(CreateIndexExpression)

ProcessorBase.Process(DeleteIndexExpression)

ProcessorBase.Process(RenameTableExpression)

ProcessorBase.Process(RenameColumnExpression)

ProcessorBase.Process(InsertDataExpression)

ProcessorBase.Process(DeleteDataExpression)

ProcessorBase.Process(AlterDefaultConstraintExpression)

ProcessorBase.Process(UpdateDataExpression)

ProcessorBase.Process(AlterSchemaExpression)

ProcessorBase.Process(CreateSequenceExpression)

ProcessorBase.Process(DeleteSequenceExpression)

ProcessorBase.Process(CreateConstraintExpression)

ProcessorBase.Process(DeleteConstraintExpression)

ProcessorBase.Process(DeleteDefaultConstraintExpression)

ProcessorBase.Execute(string)

ProcessorBase.Dispose()

ProcessorBase.ReThrowWithSql(Exception, string)

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: FluentMigrator.Runner.Processors.SqlServer

Assembly: FluentMigrator.Runner.SqlServer.dll

Syntax

public class SqlServerProcessor : GenericProcessorBase, IMigrationProcessor, IQuerySchema, IDisposable

Constructors

SqlServerProcessor(IEnumerable<string>, IMigrationGenerator, IQuoter, ILogger, IOptionsSnapshot<ProcessorOptions>, IConnectionStringAccessor, IServiceProvider)

Declaration

protected SqlServerProcessor(IEnumerable<string> databaseTypes, IMigrationGenerator generator, IQuoter quoter, ILogger logger, IOptionsSnapshot<ProcessorOptions> options, IConnectionStringAccessor connectionStringAccessor, IServiceProvider serviceProvider)

Parameters

Type	Name	Description
IEnumerable<string>	databaseTypes
IMigrationGenerator	generator
IQuoter	quoter
ILogger	logger
IOptionsSnapshot<ProcessorOptions>	options
IConnectionStringAccessor	connectionStringAccessor
IServiceProvider	serviceProvider

SqlServerProcessor(IEnumerable<string>, DbProviderFactory, IMigrationGenerator, IQuoter, ILogger, IOptionsSnapshot<ProcessorOptions>, IConnectionStringAccessor, IServiceProvider)

Declaration

protected SqlServerProcessor(IEnumerable<string> databaseTypes, DbProviderFactory factory, IMigrationGenerator generator, IQuoter quoter, ILogger logger, IOptionsSnapshot<ProcessorOptions> options, IConnectionStringAccessor connectionStringAccessor, IServiceProvider serviceProvider)

Parameters

Type	Name	Description
IEnumerable<string>	databaseTypes
DbProviderFactory	factory
IMigrationGenerator	generator
IQuoter	quoter
ILogger	logger
IOptionsSnapshot<ProcessorOptions>	options
IConnectionStringAccessor	connectionStringAccessor
IServiceProvider	serviceProvider

SqlServerProcessor(IEnumerable<string>, IDbConnection, GenericGenerator, IAnnouncer, IMigrationProcessorOptions, IDbFactory)

Declaration

[Obsolete]
public SqlServerProcessor(IEnumerable<string> databaseTypes, IDbConnection connection, GenericGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)

Parameters

Type	Name	Description
IEnumerable<string>	databaseTypes
IDbConnection	connection
GenericGenerator	generator
IAnnouncer	announcer
IMigrationProcessorOptions	options
IDbFactory	factory

Properties

DatabaseType

Gets the database type

Declaration

public override string DatabaseType { get; }

Property Value

Type	Description
string

Overrides

ProcessorBase.DatabaseType

DatabaseTypeAliases

Gets the database type aliases

Declaration

public override IList<string> DatabaseTypeAliases { get; }

Property Value

Type	Description
IList<string>

Overrides

ProcessorBase.DatabaseTypeAliases

Quoter

Declaration

public IQuoter Quoter { get; }

Property Value

Type	Description
IQuoter

Methods

BeginTransaction()

Begins a transaction

Declaration

public override void BeginTransaction()

Overrides

GenericProcessorBase.BeginTransaction()

ColumnExists(string, string, string)

Tests if a column exists

Declaration

public override bool ColumnExists(string schemaName, string tableName, string columnName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.ColumnExists(string, string, string)

CommitTransaction()

Commits a transaction

Declaration

public override void CommitTransaction()

Overrides

GenericProcessorBase.CommitTransaction()

ConstraintExists(string, string, string)

Tests if a constraint exists

Declaration

public override bool ConstraintExists(string schemaName, string tableName, string constraintName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	constraintName	The constraint name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.ConstraintExists(string, string, string)

DefaultValueExists(string, string, string, object)

Tests if a default value for a column exists

Declaration

public override bool DefaultValueExists(string schemaName, string tableName, string columnName, object defaultValue)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	columnName	The column name
object	defaultValue	The default value

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.DefaultValueExists(string, string, string, object)

Execute(string, params object[])

Execute an SQL statement

Declaration

public override void Execute(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL statement
object[]	args	The arguments to replace in the SQL statement

Overrides

ProcessorBase.Execute(string, params object[])

Exists(string, params object[])

Returns true if data could be found for the given SQL query

Declaration

public override bool Exists(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL query
object[]	args	The arguments of the SQL query

Returns

Type	Description
bool	true when the SQL query returned data

Overrides

ProcessorBase.Exists(string, params object[])

IndexExists(string, string, string)

Tests if an index exists

Declaration

public override bool IndexExists(string schemaName, string tableName, string indexName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name
string	indexName	The index name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.IndexExists(string, string, string)

Process(PerformDBOperationExpression)

Executes a DB operation

Declaration

public override void Process(PerformDBOperationExpression expression)

Parameters

Type	Name	Description
PerformDBOperationExpression	expression	The expression to execute

Overrides

ProcessorBase.Process(PerformDBOperationExpression)

Process(string)

Declaration

protected override void Process(string sql)

Parameters

Type	Name	Description
string	sql

Overrides

ProcessorBase.Process(string)

Read(string, params object[])

Executes and returns the result of an SQL query

Declaration

public override DataSet Read(string template, params object[] args)

Parameters

Type	Name	Description
string	template	The SQL query
object[]	args	The arguments of the SQL query

Returns

Type	Description
DataSet	The data from the specified SQL query

Overrides

ProcessorBase.Read(string, params object[])

ReadTableData(string, string)

Reads all data from all rows from a table

Declaration

public override DataSet ReadTableData(string schemaName, string tableName)

Parameters

Type	Name	Description
string	schemaName	The schema name of the table
string	tableName	The table name

Returns

Type	Description
DataSet	The data from the specified table

Overrides

ProcessorBase.ReadTableData(string, string)

RollbackTransaction()

Rollback of a transaction

Declaration

public override void RollbackTransaction()

Overrides

GenericProcessorBase.RollbackTransaction()

SchemaExists(string)

Tests if the schema exists

Declaration

public override bool SchemaExists(string schemaName)

Parameters

Type	Name	Description
string	schemaName	The schema name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.SchemaExists(string)

SequenceExists(string, string)

Tests if a sequence exists

Declaration

public override bool SequenceExists(string schemaName, string sequenceName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	sequenceName	The sequence name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.SequenceExists(string, string)

TableExists(string, string)

Tests if the table exists

Declaration

public override bool TableExists(string schemaName, string tableName)

Parameters

Type	Name	Description
string	schemaName	The schema name
string	tableName	The table name

Returns

Type	Description
bool	true when it exists

Overrides

ProcessorBase.TableExists(string, string)

Implements

IMigrationProcessor

IQuerySchema

IDisposable