CODEWITHSUNDEEP
asp.netentity-frameworkazurednxentity-framework-migrations
Sean
Sean

Reputation: 15144

Apply EF7 Migrations on Azure

How do I apply EF7 migrations on an Azure database?

According to this link, you simply tick a box in the Publish Profile settings. Well, I don't have that checkbox - I'm not sure if the profile configuration has changed since then but I don't even have a databases section.

According to this link, EF7 doesn't support database initializers and you have to use nuget package manager or k (dnx) migrations. I'm not sure about the nuget option, so going with the dnx option: how do I connect to my Azure (hosted) project/website using a dnx console window or the Package Manager Console in VS?

Are there any other options (hopefully easier!) for doing this?

Upvotes: 1

Views: 313

Answers (2)

Sean
Sean

Reputation: 15144

Here's the 'new' way:

_context.Database.EnsureCreated();
_context.Database.Migrate();

Simple.

My Azure database somehow had some migrations applied, but nothing in the __EFMigrationsHistory table, so I dropped all other tables and then ran all the migrations to get it back to where I wanted it.

Upvotes: 1

Sean
Sean

Reputation: 15144

I've managed to apply the migrations by changing my connection string on my local project, opening the firewall on Azure to my IP address, and running a dnx . ef migration apply command.

However, that doesn't seem like a good solution to me: now I have to store my live connection string in my dev project and keep switching between the two. There must be a better way...?

Upvotes: 0

Related Questions