A EF extension to run SQL scripts as part of a migration

ReadMe.md

This extension makes it easier to apply script scripts during a migration. Save you scripts to a folder inside our data layer (in the same assembly as the extension) and mark them as embeded.

EntityTypeBuilderExtensions.cs

/// <summary>
/// Added auditable metadata to the entity mapping.
/// </summary>
/// <typeparam name="TProperty"></typeparam>
/// <param name="builder"></param>
public static void AddAuditableMetadata<TProperty>([NotNull] this EntityTypeBuilder<TProperty> builder) where TProperty : class, IAuditableEntity
{
	builder.HasOne(t => t.CreatedBy).WithMany().HasForeignKey(t => t.CreatedById);
	builder.Property(t => t.CreatedOn).HasColumnName(nameof(AuditableEntity.CreatedOn));
	builder.Property(t => t.UpdatedOn).HasColumnName(nameof(AuditableEntity.UpdatedOn));
	builder.HasOne(t => t.UpdatedBy).WithMany().HasForeignKey(t => t.UpdatedById);
}

ExampleMigration.cs

public partial class ExampleMigration : Migration
{
	protected override void Up(MigrationBuilder migrationBuilder)
	{
		migrationBuilder.RunSqlScript("your-embed-script");
	}

	protected override void Down(MigrationBuilder migrationBuilder)
	{

	}
}

MigrationExtensions.cs

public static void RunSqlScript(this MigrationBuilder migrationBuilder, string script)
{
	var assembly = Assembly.GetExecutingAssembly();
	var resourceName = assembly.GetManifestResourceNames().FirstOrDefault(x => x.EndsWith($"{script}.sql"));
	using var stream = assembly.GetManifestResourceStream(resourceName);
	using var reader = new StreamReader(stream);
	var sqlResult = reader.ReadToEnd();
	migrationBuilder.Sql(sqlResult);
}