How to set Azure Sql Service Tier when creating DB via EF Core EnsureCreated?

azure-sql-database entity-framework entity-framework-core

Question

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.

1
0
11/16/2019 1:52:29 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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 )

0
11/17/2019 1:33:55 PM

Related Questions

Error deploying to SQL Azure using EF 6 alpha3 Code First and Migrations creating __MigrationHistory table

This is a ...bug... in Alpha 3 - Sorry for the inconvenience....There is a pretty easy workaround:...1) Create a custom migration SQL generator:...public class AzureSqlGenerator : SqlServerMigrationSqlGenerator { protected override void Generate(CreateTableOperation createTableOperation) { if ((createTableOperation.PrimaryKey != nul...
azure-sql-database entity-framework entity-framework-6
asked by Andrew Peters

ASP - Core Migrate EF Core SQL DB on Startup

You can use...db.Database.EnsureCreated(); ...to get your db up to date with your current model. If you want to enable migrations (If subsequent migrations are suspected), then use...db.Database.Migrate(); ...and put your subsequent migrations over time.
asp.net-core c# entity-framework-core
asked by Janshair Khan

I am having trouble creating DB in SQL Server Express with Entity Framework Core 2.0

I needed to run:...Update-Database ...I went through this last year: ...Why is dotnet ef not able to create a database against SQL Server Express?...It seems I never learn.
entity-framework-core sql-server-express
asked by Sam

Connect to Azure SQL server via AAD Authentication using EF Core

Connect to Azure SQL server via AAD Authentication using EF Core...If your project platform is ....netcore..., it is ...not supported... currently. I also find the ...issue... on the github....Or you could refer to this ...blog... or another ...SO thread.... ...so I am looking forward to using Microsoft.Azure.Services.AppAuthentication for getting...
azure-active-directory azure-sql-database azure-sql-server azure-web-sites entity-framework-core
asked by Tom Sun - MSFT

Identity Server EF Core DB Configuration with Azure MSI

I had a similar issue,...Try the overload of UseSqlServer that accepts a DbConnection, and pass it a SqlConnection with the token set....It worked for me
asp.net azure-sql-database entity-framework-core identityserver4
asked by manu4rhyme

Default Azure SQL DB pricing when created automatically through EF Core

Issue a CREATE DATABASE statement with the correct option before running migrate, or even better use an ARM template and deploy that during release.
azure azure-sql-database entity-framework-core
asked by ErikEJ

Is there a way to set the default Azure SQL Database pricing tier for an Azure SQL Server

Credit: Torsten Grabs (MSFT) @ MSDN...https://social.msdn.microsoft.com/Forums/windows/en-US/7d7b5cd8-5878-4241-a674-33336010f081/set-service-tiers-when-create-azure-sql-database-from-vs-c-entity-framework?forum=ssdsgetstarted...Unfortunately, EF relies on the default parameters when it creates a new database, and the default in Azure SQL DB is cur...
azure entity-framework entity-framework-6 sql
asked by Architect Jamie

EF Core Cosmos DB with Azure Table Storage

Since Microsoft recently have merged Azure Table Storage namespaces and api with Cosmosdb, I thought it would be possible to use Entity Framework Core Cosmos with Azure Storage Tables.. only I'm not able to provide a database name in the configuration:...protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder...
azure azure-cosmosdb azure-table-storage entity-framework-core
asked by Morten_564834

SQL Connection string issue when deploying ASP.NET Core MVC to Azure App Service (Linux)

The publish wizard simply handles the database creation/migration for you, it doesn't modify your project, as that's 1) not its purpose and 2) it can't make the configuration decision for you (i.e. use appsettings, environment variables, etc.)...You need to provide the connection string in production via configuration, just as in development. Since...
asp.net-core asp.net-mvc azure-sql-database entity-framework-core
asked by Chris Pratt

Specify Azure SQL server edition in EF Core without breaking local development

Of course ...EDITION... and ...SERVICE_OBJECTIVE... are not supported for non Azure SQL Database....You need to run your commands only for Azure database. For other types of SQL server you need to miss execution of your code....I suggest to detect ...SQL Server Edition... before running your code....For this purpose you can add extension method:...
azure c# entity-framework entity-framework-core
asked by Alexander I.

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow