Update MVC database first to reflect db changes

asp.net-mvc-4 c# ef-database-first entity-framework sql-server-2008

Question

i'm new to MVC and have to update my model.

I have an SQL Server database already connected to my project, today I add a new column. Now I need to update my MVC code to reflect the change.

Everything online tells me to update the .edmx and .tt files with the Update Model Wizard since they are auto generated, but I cannot find the wizard in VS 2012 so I am at a stand still.

Is this the right way I should be doing this? Any tips would be great...thanks

1
0
9/24/2013 5:30:11 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I ended up downloading this update of VS 2012 and repaired. Now I am able to update my model.

1
9/24/2013 7:39:41 PM

Popular Answer

Double click the edmx file. This opens the diagram of the database model. Right click and select "Update Model from Database..." That will start the wizard you're looking for.

Be aware that not all changes come through automatically.
Most obvious is that columns will not be removed from model just because they're gone from the db. If you're dealing with lots of modifications or deletes rather than additions, it may be best to just drop the model and recreate it (as suggested above by Andrew).
No matter which approach you take, I'd suggest making sure you have all other local source changes committed or shelved before starting because you may need to do an undo check out if EF gets freaked out.

Adam47

Related Questions

Updating your edmx to reflect changes made in your db (.net linq-to-entities)

Choosing the Update Model from Database is the best method for updating your EDMX. There are certain properties that don't get updated on the Conceptual layer. ...Ensure that your Store layer has been updated by viewing it in the Model Viewer toolbox. If the Store has properly been updated then you're okay, and your database is in sync. If so, ...
.net-3.5 entity-framework linq linq-to-entities
asked by bendewey

EF 5 - Model First, How to update DB Schema without dropping database

Database migrations is what you are looking for. Both automatic and specified in code - ...http://msdn.microsoft.com/pl-PL/data/jj591621
asp.net-mvc entity-framework
asked by Piotr Perak

Entity framework code first - how to run Update-Database for production database

See ...Using Entity Framework (code first) migrations in production... so that your application automatically updates the database when the Entity Framework initializes....Now if you're more comfortable having manual control over the migration, you could use the -Script argument to the Update-Database command on your developer machine to generate S...
asp.net-mvc c# entity-framework
asked by David Moore

Entity Framework 6 Model-First - Update Production Database Based On Local Changes

EF migration is used for code first development, not database first. But you can still use it if you do reverse engineering from database. To be able to do so you need to install ...The Entity Framework 6 Tools..., but this will need some efforts, like...Reverse engineering ...source database...Generate to ...new database... by using EF migration (...
azure-sql-database ef-database-first ef-model-first entity-framework entity-framework-6
asked by Yuliam Chandra

EF Database first how to update model for database changes?

Not a fix but a workaround: Is it not an option to simply remove and regenerate the EDMX and the generated classes? That's what I do, it is much easier than working with the update feature, and the result seems to be the same. Your POCO extensions still remain the same and functional....I use database first and I have my SQL upgrade scripts, the ge...
.net c# entity-framework entity-framework-5 entity-framework-6
asked by Nenotlep

How to update model working with EF code first with 'Code First from Database'

Go through the generation process, and during the generation process, it allows you to select tables. Select the newer ones only....Instead of selecting all tables, expand the little triangle and select what you need. You also will have to select any dependent tables, or else the process will fail. If those dependent tables are already there, just ...
.net c# ef-code-first entity-framework entity-framework-6
asked by Mrchief

Solutions with one EF6 model (db first) and one code first

Ok, got to the bottom of this. Basically if you share a connection across both contexts this does not work. However if you use a different connection for both it works....Thanks to Ben Robinson for pointing me in right direction.
c# entity-framework entity-framework-6
asked by DermFrench

Update existing database with Entity Framework Code First in MVC

Why did you do steps 1-4? That's where you went wrong. If you had a previously generated database and you're just making changes to the schema, then just generate a migration and apply it. By doing steps 1-4, you're effectively undoing Entity Framework's knowledge of this database and essentially ending up with code-first with an existing database....
asp.net-mvc ef-code-first entity-framework sql-server updatemodel
asked by Chris Pratt

update-database -force command is not updating the base in entity framework code -first

Using an Existing Database...Depending on the state of your context you need to the one of the following......IF YOUR DATABASE CONTEXT CONTAINS ONLY YOUR EXISTING TABLES AND NO CUSTOM CHANGES DO THE FOLLOWING...Add-Migration Initial -IgnoreChanges ...This will create a blank migration script...update-database ...This will update the database to thi...
asp.net-mvc ef-code-first entity-framework sql-server
asked by heymega

Entity Framework DB updating but DB context not showing updates

Thanks to both Eric J and DevilSuichiro for helping me resolve my issue. The problem was that I should not have been trying to use the same DB context. By retrieving a new DB context instead of trying to reuse the same DB context I was able to verify my test results....Many thanks again.
c# entity-framework entity-framework-6 identityserver4 unit-testing
asked by CLSavill

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