EFCore.AutomaticMigrations 8.0.0

About the package

Enable Automatic Migrations for Entity Framework Core for SQL Databases.

Usage

DbMigrationsOptions object allows to configure migration options:

/// <summary>
/// Allow auto migration with data lost. 
/// </summary>
public bool AutomaticMigrationDataLossAllowed { get; set; } = false;
/// <summary>
/// Enable to execute auto migration
/// </summary>
public bool AutomaticMigrationsEnabled { get; set; } = true;
/// <summary>
///  Drop all tables from database and recreate based on model snapshot. Useful in scenarios when the data is transient and can be dropped when the schema changes. For example during prototyping, in tests, or for local caches
/// When ResetDatabaseSchema is true AutomaticMigrationsEnabled and AutomaticMigrationDataLossAllowed are set to true
/// </summary>
public bool ResetDatabaseSchema { get; set; } = false;

/// <summary>
/// Allow to update snapshot.The key will pe replaced with value for each KeyValuePair object
/// </summary>
public Dictionary<string, string> UpdateSnapshot { get; set; } = new Dictionary<string, string>();

The package support following ways to apply/view-applied migrations:

1. Using MigrateDatabaseToLatestVersion

• Execute<TContext>(TContext context);
• ExecuteAsync<TContext>(TContext context);
• Execute<TContext, TMigrationsOptions>(TContext context, TMigrationsOptions options);
• ExecuteAsync<TContext, TMigrationsOptions>(TContext context, TMigrationsOptions options);

  // Get context
  var context = services.GetRequiredService<YourContext>();  

  // Apply migrations
  MigrateDatabaseToLatestVersion.Execute(context);
  // Reset database schema
  MigrateDatabaseToLatestVersion.Execute(context, new DbMigrationsOptions { ResetDatabaseSchema = true });

  // Apply migrations async
  await MigrateDatabaseToLatestVersion.ExecuteAsync(context);
  // Reset database schema async
  await MigrateDatabaseToLatestVersion.ExecuteAsync(context, new DbMigrationsOptions { ResetDatabaseSchema = true });

2. Using Context extensions methods

• MigrateToLatestVersion<TContext>(this TContext context);
• MigrateToLatestVersionAsync<TContext>(this TContext context);
• MigrateToLatestVersion<TContext, TMigrationsOptions>(this TContext context, TMigrationsOptions options);
• MigrateToLatestVersionAsync<TContext, TMigrationsOptions>(this TContext context, TMigrationsOptions options);

 // Get context
 var context = services.GetRequiredService<YourContext>();
 
 // Apply migrations
 context.MigrateToLatestVersion();
// Reset database schema async
 context.MigrateToLatestVersion(new DbMigrationsOptions { ResetDatabaseSchema = true });

 // Apply migrations async
 context.MigrateToLatestVersionAsync();
 // Reset database schema async
 await context.MigrateToLatestVersionAsync(new DbMigrationsOptions { ResetDatabaseSchema = true });

3. View applied migrations - return list of MigrationOperation object

  //Get context
  var context = services.GetRequiredService<YourContext>();
  // Get applied migrations
   List<MigrationRaw> appliedMigrations = context.ListMigrationOperationsAsRawSql();
  // Get applied migrations async
   List<MigrationRaw> appliedMigrations = await context.ListMigrationOperationsAsRawSqlAsync();
  
   /// <summary>
   /// Migration Raw object
   /// </summary>
   public class MigrationRaw
   {
       public string MigrationId { get; set; } = string.Empty;
       public DateTime? CreatedDate { get; set; } = null;
   }