Class SQLMigrationRunner

Namespace

The.SQLServer.Schema

Assembly

Instagile.SQLServer.dll

public sealed class SQLMigrationRunner : MigrationRunner<IDatabase>

Inheritance

object

MigrationRunner

MigrationRunner<IDatabase>

SQLMigrationRunner

Inherited Members

MigrationRunner<IDatabase>.TryRunMigrations(MigrationRunnerOptions, SchemaFile, CancellationToken, out Exception)

MigrationRunner.TryRunMigrations(MigrationRunnerOptions, SchemaFile, out Exception)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

SQLMigrationRunner(IDatabase, ILogger<SQLMigrationRunner>?, bool)

public SQLMigrationRunner(IDatabase database, ILogger<SQLMigrationRunner>? logger = null, bool useSQLAgent = true)

Parameters

database IDatabase

logger ILogger<SQLMigrationRunner>

useSQLAgent bool

Methods

CreateDbParameter(int, object)

protected override DbParameter CreateDbParameter(int number, object value)

Parameters

number int

value object

Returns

DbParameter

CreateDbParametersFor(MigrationRunnerOptions)

protected override DbParameter[] CreateDbParametersFor(MigrationRunnerOptions migrationParameters)

Parameters

migrationParameters MigrationRunnerOptions

Returns

DbParameter[]

EnsureControlTableColumns(IDatabase)

Adds columns to the _Migration control table which postdate its original schema; the setup scripts create them for new databases, this upgrades existing ones.

protected override void EnsureControlTableColumns(IDatabase db)

Parameters

db IDatabase

GetControlTableExists(IDatabase)

protected override bool GetControlTableExists(IDatabase db)

Parameters

db IDatabase

Returns

bool

GetServerProperties(IDatabase)

protected override HashSet<string> GetServerProperties(IDatabase db)

Parameters

db IDatabase

Returns

HashSet<string>

ShouldSkipBatch(MigrationState, StatementBatch)

protected override bool ShouldSkipBatch(MigrationState state, StatementBatch batch)

Parameters

state MigrationState

batch StatementBatch

Returns

bool