C# Класс SimpleMigrations.DatabaseProvider.MssqlDatabaseProvider

Class which can read from / write to a version table in an MSSQL database

MSSQL supports advisory locks, so these are used to guard against concurrent migrators.

Наследование: DatabaseProviderBaseWithAdvisoryLock

Открытые методы

Метод	Описание
AcquireAdvisoryLock ( ) : void	Acquires an advisory lock using Connection
GetCreateVersionTableSql ( ) : string	Returns SQL to create the version table
GetCurrentVersionSql ( ) : string	Returns SQL to fetch the current version from the version table
GetSetVersionSql ( ) : string	Returns SQL to update the current version in the version table
MssqlDatabaseProvider ( DbConnection connection ) : System	Initialises a new instance of the MssqlDatabaseProvider class
ReleaseAdvisoryLock ( ) : void	Releases the advisory lock held on Connection

Acquires an advisory lock using Connection

public AcquireAdvisoryLock ( ) : void
Результат	void

Returns SQL to create the version table

public GetCreateVersionTableSql ( ) : string
Результат	string

Returns SQL to fetch the current version from the version table

public GetCurrentVersionSql ( ) : string
Результат	string

Returns SQL to update the current version in the version table

public GetSetVersionSql ( ) : string
Результат	string

Initialises a new instance of the MssqlDatabaseProvider class

public MssqlDatabaseProvider ( DbConnection connection ) : System
connection	System.Data.Common.DbConnection	Connection to use to run migrations. The caller is responsible for closing this.
Результат	System

Releases the advisory lock held on Connection

public ReleaseAdvisoryLock ( ) : void
Результат	void