Entity Framework Scriptable Migration

About

EFScriptableMigration allows to migrate sql schema via sql scripts that are embedded in assemblies and written manually.

Where can I get it ?

First, install Nuget then, install EFScriptableMigration from the package manager console.

PM> dotnet add package EFScriptableMigration --version 6.0.1

Usages :

In assembly contains DbContext create folder named /Scripts/{SchemaName}

Add sql script file as embedded resource with name "001-scriptname.sql" like this :

if exists(select * from sysobjects where name = 'MyModel' and xtype = 'U')
Begin
	drop table dbl.MyModel
End
go

Create Table dbo.MyModel (
	Id int identity(1,1) not null
	, Name varchar(100) not null
	, CreationDate datetime not null
	, Ready bit not null
)
go

alter table dbo.MyModel add constraint PK_MyModel_Id primary key (Id)
Go

Create your model

public class MyModel
{
	public int Id { get; set; }
	public string Name { get; set; }
	public DateTime CreationDate { get; set; }
	public bool Ready { get; set; }
}

Create your DbContext

public class MyDbContext : DbContext
{
	private readonly string _connectionString;

	public MyDbContext(string connectionString)
	{
		this._connectionString = connectionString;
	}

	protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
	{
		optionsBuilder.EnableSensitiveDataLogging();
		optionsBuilder.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
		optionsBuilder.UseSqlServer(_connectionString);
		base.OnConfiguring(optionsBuilder);
	}
	public DbSet<MyModel> MyModels { get; set; }
}

Create the migration an start it !

var migration = new DbMigration
{
	ConnectionString = _connectionString,
    SchemaName = "All",
    EmbededTypeReference = typeof(TypeInAsssemblyContainsEmbededScripts)
}

migration.Start();