Configure Azure SQL DTU with Entity Framework Code First

Question

I would like to know if it is possible to define the DTU of a Azure SQL database when using Entity Framework Code First? What i mean is, you can use DropCreateDatabaseIfModelChanges-DropCreateDatabaseAlways, but each time it is dropped and re created, it gets the Standard DTU by default but it needs to be the Basic DTU.

This is what i mean:

Any way of achieving this either with entity framework configuration or another approach? Thank you in advance for any feedback! Kind regards

Check this link code.msdn.microsoft.com/How-to-create-an-Azure-SQL-dbd0bf6a/… — Llazar
– Llazar, Commented Nov 26, 2018 at 9:31
Will check and test this out, looks interesting, i will see if i can combine this along using Entity Framework. Will post an update this week. (Thank you so far!) — Dimitri
– Dimitri, Commented Nov 26, 2018 at 10:21
Hi @Llazar, this seems to be what i need but i can't make it work, issues with the "clientId" that is not found, i will try later on to register the App (i tried with a registered app but this didn't work neither ...). Thank you, you can post this as answer if you like so i can mark it as one ;) — Dimitri
– Dimitri, Commented Nov 27, 2018 at 10:51
With clientId they used to authenticate with AAD but you don't include it your solution if doesn't needed. — Llazar
– Llazar, Commented Nov 27, 2018 at 13:17

Llazar · Accepted Answer · 2018-11-27 13:13:07Z

1

You can create an Azure Sql database programmatically in C#. You can add almost everything from recourse grup, server, database. There is different way that you can do it but I have used the code from this sample from Microsoft OneCode team. Is not the code that can complete all your task but is a god starting point to achieve it.

answered Nov 27, 2018 at 13:13

Llazar

3,3293 gold badges20 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dimitri Over a year ago

Thank you again, very useful!

Llazar Over a year ago

Glad that solution helpt you.

Collectives™ on Stack Overflow

Configure Azure SQL DTU with Entity Framework Code First

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related