Run the migrations with specific model updates

asp.net asp.net-mvc ef-migrations entity-framework-6

Question

I' m working on a ASP.Net MVC project using Visual Studio 2017 .I want added a property to one of my models After i the migrations and starting the application i m getting and error message "There is already an object named in the database" . as i found on the internet this is occurred due to automatic migrations , how to change my migration command to avoid this .

dotnet ef migrations add GeoLocation -c ApplicationDb -o Data/Migrations/IdentityServer/ApplicationDb
1
0
9/20/2018 11:54:57 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I do use EF migrations but I'm still not a fan. I prefer to develop in both SQL Server and C# separately. You can work around issues in various ways

Open a Nu-Get Package manager console and enable migrations for your project

Enable-Migrations -ContextTypeName YourProject.Models.ApplicationDbContext -Force

You can migrate whatever you have in your migration folder as follows (I've just shown the initial one) with or without the ignore changes flag

add-migration Initial
Add-Migration Initial -IgnoreChanges

Finally, force through the changes

Update-Database -Force

I always copy the contents of the "Configuration" file because that can get overwritten when I don't want. It can also add duplicate data to the database if your are not careful when it runs on a migration - so you'll need to code around that.

If I'm really stuck, I simply delete all migrations, truncate the migrations table, then perform an initial migration again.

0
9/20/2018 5:34:44 PM

Related Questions

Instead of "Generate Database from Model," Entitiy Framework uses "Update Database from Model."

Noam Ben-Ami - MSFT1 (Microsoft Employee) answered my question at ...http://social.msdn.microsoft.com/Forums/en-us/adodotnetentityframework/thread/3adc080f-ee8c-4104-be29-95b2fb3fabe9... as follows:...We've build the entity designer database power pack to support this. You can download it here: ...http://visualstudiogallery.msdn.microsoft.com/en-us...
entity-framework visual-studio-2010
asked by David

Update-Database tries to do an automatic migration even with automatic migrations disabled

I work on a team of 4 developers using EF5, everyone working on their own local database. Up until now we've been using automatic migrations but we're nearing the point where we need to release to production so we've disabled automatic migrations and started adding explicit code-based migrations....Here is the problem: I ran the ...Update-Database....
ef-migrations entity-framework
asked by Dave Graves

Can't update database using EF Migrations after updating to EF 6.0.0-alpha

OK. I have found the solution. It appears that EF expects the Primary Key constraint of ...__MigrationHistory... table to have the name ...PK_dbo.__MigrationHistory.... but it is ...PK___MigrationHistory.......So the following sql statements will do the trick....ALTER TABLE __MigrationHistory drop CONSTRAINT PK___MigrationHistory ALTER TABLE __Migr...
code-first ef-migrations entity-framework entity-framework-6
asked by Mahmoodvcs

Update-Database fails due to Pending Changes, but Add-Migration Creates a Duplicate Migration

I'm working with Entity Framework 5.0 Code First Migrations, and am having a problem with running Update-Database. It says there are pending model changes; but it should be up-to-date, so I run...Add-Migration SomeMigrationName ...and it creates a file... however, it creates a file which is essentially the same a duplicate of a prior Migration (if ...
c# ef-migrations entity-framework
asked by Nij

EF Add-Migration indicates "No pending explicit migrations" but Update-Database complains "..there are pending changes"

For me the issue was that we had renamed the namespace of the migration 2014123456_Initial.cs.... But VS had not regenerated the namespace in its associated 2014123456_Initial.Designer.cs....Once the Designer.cs was changed to use the same namespace, it all started working again.
ef-migrations entity-framework
asked by demoncodemonkey

Updating Database model (.edmx) Model First

Open your model right click and you will find an option Update Model from database...Click update model from database than a window will open like this:...So choose the modified table to update them in model.
ef-model-first entity-framework
asked by Afnan Ahmad

Error running code first migration update-database

Im having trouble with my migration to my database and i can't seem to find a answer to the error i am getting ...System.MissingMethodException: Method not found: 'System.Data.Entity.Migrations.Builders.TableBuilder`1 System.Data.Entity.Migrations.Builders.TableBuilder`1.Index(System.Linq.Expressions.Expression`1>, Boolean, Boolean, System.Object)'...
asp.net-web-api c# entity-framework
asked by Robin Karlsson

EF migrations and timestamp column, cannot update/run

Replace... one line ...AlterColumn... with 2 lines ...DropColumn... and ...AddColumn... in Up() method.... public override void Up() { DropColumn("dbo.Cities", "RowVersion", null); AddColumn("dbo.Cities", "RowVersion", c => c.Binary(nullable: false, fixedLength: true, timestamp: true, storeType: "rowversion"))...
.net c# entity-framework entity-framework-6
asked by Mark Macneil Bikeio

Run Code First Migration Seed Method without a migration

If you just need to run ...Seed()... again, and nothing has changed that would cause a new migration to be added, just call ...Update-Database... again with no flags and it will say 'No pending migrations', and run ...Seed()... again for you. ...Seed()... is called every time the DB is updated, regardless if there are new migrations or not.
ef-code-first entity-framework
asked by DrewJordan

EF Code First Migrations running DbMigrator.Update fails

After lots of trying, I was able to find out myself, the missing ...ContextKey... Property caused the issues:...var config = new DbMigrationsConfiguration<MyContext> { AutomaticMigrationsEnabled = false, AutomaticMigrationDataLossAllowed = false, MigrationsAssembly = Assembly.GetAssembly(typeof(InitialCreate)), MigrationsNamespace =...
ef-migrations entity-framework entity-framework-6
asked by thmshd

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