If-(Not-)Exists checks in migrations (SQL Server)
This feature is using SQL Server capabilities.
Required Nuget Package:
Usage
Register ThinktectureSqlServerMigrationsSqlGenerator with EF.
var services = new ServiceCollection()
.AddDbContext<DemoDbContext>(builder => builder
...
.UseSqlServer("conn-string", sqlOptions =>
{
sqlOptions.UseThinktectureSqlServerMigrationsSqlGenerator();
})
Use IfExists or IfNotExists to add checks to operations.
migrationBuilder.CreateIndex("IX_OrderItems_ProductId", "OrderItems", "ProductId").IfNotExists();
Supported operations
CreateTable-IfNotExistsDropTable-IfExistsAddColumn-IfNotExistsDropColumn-IfExistsCreateIndex-IfNotExistsDropIndex-IfExistsAddUniqueConstraint-IfNotExistsDropUniqueConstraint-IfExists
Remarks
The implementation of IMigrationsSqlGenerator will be replaced by ThinktectureSqlServerMigrationsSqlGenerator (derives from SqlServerMigrationsSqlGenerator)