Entity Framework Core Key Store

This sample showcases data protection with keys stored in relational database using Entity Framework Core.

• Package Microsoft.AspNetCore.DataProtection.EntityFrameworkCore is added to the project.

• Database connection string is set up in appsettings.

  Copy

  "DataProtection": 
  {
      ...
      "DefaultConnection": "<database connection string>",
      ...
  }
  

• Data protection EF core database context is set up as below:

  Copy

  class DataProtectionKeyContext : DbContext, IDataProtectionKeyContext
  {
      public DataProtectionKeyContext(DbContextOptions<DataProtectionKeyContext> options)
          : base(options){ }
  
      public DbSet<DataProtectionKey> DataProtectionKeys { get; set; }
  }
  

• EF Core data migration is setup using below commands:

  Copy

  dotnet ef migrations add AddDataProtectionKeys --context DataProtectionKeyContext
  dotnet ef database update --context DataProtectionKeyContext
  

• Key persistence is set up in StartUp ConfigureServices().

  Copy

  public void ConfigureServices(IServiceCollection services)
      {
          ...
          var storageConnectionString = Configuration["DataProtection:DefaultConnection"];
  
          // Add a DbContext to store your data protection Keys
          services.AddDbContext<DataProtectionKeyContext>(options =>
              options.UseSqlServer(storageConnectionString));
  
          // Key persistence
          services.AddDataProtection()
              .PersistKeysToDbContext<DataProtectionKeyContext>();
          ...
      }
  

Reference

Data Protection Key Persistence using EF Core

Screenshot

Credits

Lohith GN