MigrateAsync after using EnsureCreatedAsync

asp.net-core-mvc c# entity-framework-core

Question

I have an asp.net core mvc site in production. The DbInitializer was using this code: await context.Database.EnsureCreatedAsync()

Now I found out that a migration was not being applied and I've seen this:

In addition, the database that is created cannot be later updated using migrations.

I've changed code to await context.Database.MigrateAsync() but no migrations are being applied and in my database dbo.__EFMigrationsHistory I don't see any records.

note: my solution has already 4 migration classes in the Migrations folder, but they are added in MigrationHistory. 3 of them are applied because I had once recreated the database (still using ensurecreated). The last migration is not applied, as I now didn't recreate the database as it contains data and migrations are not applied now because I used before "EnsureCreatedAsync".

How can I now apply and start using migrations in my existing database without losing any of my database data?

1
1
6/17/2019 3:07:29 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Found out it is not possible (hopefully I'm wrong).

  1. created a backup of the database using SSMS.
  2. generated a script of the database from the tables containing data. So that I have all the insert statements in an .sql file.
  3. deleted the database, created a new empty one, made sure the security (assign database user) was ok
  4. visual studio, deleted all migrations from solutions which were not applied.
  5. removed the seeding data from my solution (so that it would not later conflict with my insert statements in the .sql script to put data back).
  6. enabled migrations again by doing Add-Migration Initial
  7. Tried my migrations with Update-Database on my development/debug database
  8. Published the website and made it available on the webserver.
  9. started the website in IIS and verified in SSMS that all my tables were correctly created and that _migrationhistory contained my Initial migration
  10. opened SSMS and run my query from .sql having all the INSERT statements --> all data was added again.

now my (new) database is having Migrations enabled. hooray for Microsoft!

0
6/21/2019 7:47:25 AM

Related Questions

Using repository pattern to eager load entities using ThenIclude

This is a bit of an old question, but since it doesn't have an accepted answer I thought I'd post my solution to this....I'm using EF Core and wanted to do exactly this, access eager loading from outside my repository class so I can specify the navigation properties to load each time I call a repository method. Since I have a large number of tables...
c# eager-loading entity-framework entity-framework-core repository-pattern
asked by Steve

Include all navigation properties using Reflection in generic repository using EF Core

I'm working on creating a generic repository for an EF Core project to avoid having to write CRUD for all models. A major roadblock I've hit is navigation properties not being loaded since Core doesn't yet support lazy loading and the generic class obviously can't define .Include statements for class specific properties....I'm trying to do somethin...
c# entity-framework-core system.reflection
asked by Valuator

Disable conversion between VARCHAR and NVARCHAR when using Entity Framework over an existing SQL server database

I have an existing database SQL server and I'm using EF6 over it. Let's assume I have the following code:...private sealed class Foo { public int Id { get; set; } public string Bar { get; set; } } private sealed class FooConfiguration : EntityTypeConfiguration<Foo> { public FooConfiguration() { ToTable("Foos"); Has...
.net entity-framework entity-framework-6 sql sql-server
asked by RX_DID_RX

Entity Framework core 2.1 Using AsNoTracking with multiple Async gives InvalidOperationException: The connection was not closed

I have run two Async methods using Entity Framework 2.1 - one for selecting the total count and another for retrieving page data - and I marked my entity AsNoTracking as following:...var dbContext = new SamuraiAppDataCoreContext(); var query = dbContext.Samurais.AsNoTracking(); var pageQuery = query.Skip(0).Take(10); var totalCountTask = query.Co...
async-await asynchronous c# entity-framework-core
asked by Mina Matta

Referencing ApplicationUser in the Infrastructure library from an entity in the ApplicationCore library using Clean Architecture

User is an entity and it should be in Core layer. ...But you shouldn't use ...ApplicationUser : IdentityUser... in the Core layer because it's tied up to the ASP.NET Identity. The Core layer should not know what technologies are going to implement the domain....What if tomorrow you want to use another library for user management? That's not the Cor...
asp.net-core asp.net-core-mvc c# clean-architecture entity-framework-core
asked by Sasan

How do I restrict the number of columns used in an INSERT when using EntityFramework?

Let's say you have an Entity with 26 columns. It matches the corresponding table which also has 26 columns....From time to time I would like to be able to send fewer columns in an INSERT (Add) operation than are specified in the entity because of certain business rules (In our case we have a trigger on a table that will automatically populate cert...
dto entity-framework entity-framework-6 entity-framework-core
asked by ezG

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

Using AddRange over Add is already a great improvement. It fixes the part that's slow in the Application....However, the ...SaveChanges... still take a lot of time because one database round-trip is made for every entity you save. So if you have 10k entities to insert, 10,000 database round-trip will be made which is ...INSANELY... slow....Disclaim...
c# c#-4.0 entity-framework entity-framework-6
asked by Jonathan Magnan

Getting space used by tables using Entity Framework Core

We can definitely make this work, using a Raw SQL Query. ...First things first, when we run this query, it would be better to get the results back in a type of class that Entity Framework can work with. I have tried retrieving arbitrary query results back and found the results to tricky to parse. My advice is to make a class to describe the res...
entity-framework entity-framework-core tsql
asked by FoxDeploy

Relational-specific methods can only be used when the context is using a relational database provider?

I've encountered this exception when trying to call ...DbContext.Database.Migrate.... Looks like this is not very common on the net (or Google has some trouble searching it?). The only possible cause I could find is due to ...in-memory... database or some kind of provider that is not ...relational...?...But when debugging, I can see that the provi...
c# entity-framework-core oracle
asked by Hopeless

Using EF Core 2.2 to decrypt a string using SQL Server DECRYPTBYKEY

Basically I have a POCO model that has a encrypted string. Using EF core 2.2....We use DECRYPTBYKEY to decrypt strings using SYMMETRIC KEY....I am using DBSet.FromSQL to pass in SQL query which calls open symmetric key, get the data including the decrypted value, close symmetric key....FromSQL only allows you to bring back an entity rather than a s...
asp.net-core-2.2 c# entity-framework-core sql-server
asked by Andrew Roberts

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