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

asp.net-mvc entity-framework

Question

I'm using EF 5.0 and MVC 4 to develop.

How can I "simply" alter the database schema using model-first development without having to dump the database or delete any data?

e.g. I have a table for customers. We record name, last name, and email address in this table. I edit the model and ask EF to update the database schema since I now want to gather the phone number.

Zzz-17-Zzz is what Visual Studio 2012 refers to, but to me, this sounds Chinese.

They discuss using the code first migrations NUGET package. Does VS2012 not automatically provide this functionality?

Thanks

1
6
10/1/2012 6:54:41 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You are searching for database migrations. Automatic and code-specified - http://msdn.microsoft.com/pl-PL/data/jj591621

3
10/1/2012 6:58:00 PM

Related Questions

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

With the aid of Visual Studio 2010, I produced a database from an Entity Framework 4 model. Now I was adding new attributes (with default values), altering column descriptions, changing column names, and changing column types repeatedly. The only jobs that cannot be completed automatically are those that do not need a lot of "additional labor" (in ...
entity-framework visual-studio-2010
asked by David

Without losing data, update the database schema as the model changes.

Background...: If I'm using the entity framework, for example, and one of the entities that is mapped is provided as follows:...class Foo { public int ID { get; set; } public string Bar { get; set; } // other useful properties } ...The mapping entails:...class FooMap : EntityTypeConfiguration<Foo> { // bear me with, I know this is r...
c# database-update ef-code-first entity-framework
asked by Mike Bailey

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

I can't update my database after updating Entity Framework to version 6.0.0-alpha1. I keep getting the following error:...PM> update-database -verbose Using StartUp project 'DataCenter'. Using NuGet project 'DataCenter.Domain'. Specify the '-Verbose' flag to view the SQL statements being applied to the target database. Target database is: 'datacent...
code-first ef-migrations entity-framework entity-framework-6
asked by Mahmoodvcs

EF code first - Model compatibility cannot be checked because the database does not contain model metadata

Migrations automatically have been enabled. Then I destroyed my entire database. Next, I carried out...Update-database... the command terminal, and my database was reconstituted. I then launched my program and encountered the following error:...Model compatibility cannot be checked because the database does not contain model metadata. Model compa...
entity-framework migration
asked by ojek

Updating Database model (.edmx) Model First

ZZZ_tmp
ef-model-first entity-framework
asked by user1752532

EF6 Code First drop tables (not entire database) when model changes

I'm using Entity Framework 6 with Code First development, Database Migrations, and a new database that has sample seed data in it. Every time I alter the model, I'd like to be able to use that seed data to start over in my database....The problem is that I don't have authority to build databases, thus I can't just use ...DropCreateDatabaseIfModelCh...
c# ef-migrations entity-framework
asked by Gunner Barnes

EF Database first how to update model for database changes?

a classroom library...Ado.net Entity Data Model... POCO classes have been generated by it. These were successfully generated the first time. But modifications to the database are not being seen. In...edmx... right-clicking and selecting a diagram...Update Model from Database... even after selecting it to add, it does not add the newly formed table....
.net c# entity-framework entity-framework-5 entity-framework-6
asked by user576510

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

In a project, the "Code First From Database" approach described in this article was applied with an existing database and EF 6.1....Model classes were initially created by EF; later, other classes were added to the database, and I now need to create model classes for these additional tables....Please advise on how I may avoid having to regenerate e...
.net c# ef-code-first entity-framework entity-framework-6
asked by user576510

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

ZZZ_tmp
c# entity-framework entity-framework-6
asked by DermFrench

Entity Framework code first - make it do "CREATE SCHEMA" without a drop database?

ZZZ_tmp
c# entity-framework-6
asked by Ian C Tubman

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