Default Azure SQL DB pricing when created automatically through EF Core

azure azure-sql-database entity-framework-core

Question

We have a web app that uses Entity Framework Core. If it is given a connection string to a database on Azure that doesn't exist, calling dbContext.Database.Migrate() will create it automatically. This is great for our development branches as we call it with a connection string with a database name equal to the branch name and it creates the Azure SQL DB resource automatically.

When we started it seemed by default to be creating databases with the DTU pricing model and the 'Basic' tier, which is the cheapest option at 5 GBP/month, ideal for development branches.

However it seems to have changed and the default pricing model is now vCore General Purpose Generation 5 which comes out at 320+ GBP/month! This is quite a difference that we noticed on our invoice!

Is there a way to specify the default Azure SQL DB configuration created? This might not be anything to do with entity framework but could be a setting on Azure at the subscription level.

1
1
7/20/2019 11:51:41 AM

Popular Answer

Issue a CREATE DATABASE statement with the correct option before running migrate, or even better use an ARM template and deploy that during release.

1
7/20/2019 1:12:58 PM


Related Questions





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