When I use the Entity Framework Core EnsureCreated to automatically generate my Azure Sql Database it sets the service tier of the database to be an expensive tier by default.
How do I force the database to be created using the Basic service tier?
I found an example for but it doesn't apply to EF for .NET Core.
You can use code like this with EF Core 3.1 to configure your Azure SQL database:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasDatabaseMaxSize("2 GB");
modelBuilder.HasServiceTier("BusinessCritical");
modelBuilder.HasPerformanceLevel("BC_Gen4_1");
}
(Some changes were made from 3.0: https://github.com/aspnet/EntityFrameworkCore/pull/18544/files#diff-3eb328f3c708536a3be15d81c1d023e2L128 )