How to turn off Entity Framework CF Migrations for an environment

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

Question

Is it possible to turn off Entity Framework using the web.config? In the application I'm developing we have the following environments

  • Development
  • Continuous Integration
  • Integration Testing
  • Production

The Integration Testing and Production databases are managed by a database administrator, so we have to send them a script to make changes to the database.

I've spent hours Googling and looking through old projects, and I can't find how to do this or remember if we ever turned off migrations on the old projects in the first place.

From the lack of information I'm doubting if what I'm asking is needed or possible, but there is something in the back of my head that's annoying me about this so I thought I'd ask the experts.

1
1
2/24/2015 3:49:55 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

The easiest method is to simply delete the dbo._MigrationHistory table from these environments. If that table doesn't exist, then only an "initial" migration can ever be generated against that database, which will fail if someone tries to actually apply it to a database with existing tables.

2
2/24/2015 3:46:27 PM

Popular Answer

You could set the database initializer in the config file as described at the bottom here, so you can have an updating initializer in the environments you want

Daniel

Related Questions

What are the drawbacks of initially turning off ProxyCreationEnabled for EF code CTP5?

If ...DbContext.Configuration.ProxyCreationEnabled... is set to ...false..., DbContext will not load child objects for some parent object unless ...Include... method is called on parent object. Setting ...DbContext.Configuration.LazyLoadingEnabled... to ...true... or ...false... will have no impact on its behaviours....If ...DbContext.Configuration...
c# entity-framework proxy-classes serialization wcf
asked by Aleksey Timkov

First, disable tracking in the entity framework model.

I'm tring to receive an entity and then update it, but I want to get it with no tracking, so I can attach it back to the context....I have the ...EntityFramework.dll... referenced (4.1). I generated the database from the model. (not code-first)....Get user:...db.Users.MergeOption = MergeOption.NoTracking; IQueryable<User> query = db.Users;//.AsNoTr...
.net c# entity-framework
asked by Shawn Mclean

Enable AutoMigrations as well as other migrations in Entity Framework.

After banging my head on this for several hours, I finally came up with a solution that creates the database if necessary ...or... upgrades it if out of date. We use this technique in Gallery Server Pro to make it easy to install the first time or upgrade previous versions....private static void InitializeDataStore() { System.Data.Entity.Database...
asp.net-mvc-3 c# ef-migrations entity-framework
asked by Roger

Migrations in Entity Framework in a collaborative environment

You need to add a blank "merge" migration that will reset the snapshot of the latest migration in the .resx file. Do this using the IgnoreChanges switch:...Add-Migration <migration name> -IgnoreChanges...See ...here... for an explanation
c# collaboration ef-migrations entity-framework migration
asked by Dewey

Entity Framework - Migrations - Code First - Seeding per Migration

As a possible solution to item 1, I made an implementation of the ...IDatabaseInitializer... strategy which will run the Seed method of each pending migration only, you will need to implement a custom ...IMigrationSeed... interface in each of your ...DbMigration... classes, the ...Seed... method will then be implemented right after ...Up... and ...
.net-4.5 c# ef-migrations entity-framework seeding
asked by Guillermo Ruffino

Entity Framework 6: Turn off Sequential GUIDs

Entity Framework 6 appears to default to ...sequential... GUIDs instead of completely random ones. How do I turn this off?...See CodePlex work item: ...http://entityframework.codeplex.com/workitem/71
entity-framework-6 guid sequential
asked by Alex

How can I turn off Entity Framework 6.1 logging?

The documentation states that I can turn on logging like this:...using (var context = new BlogContext()) { context.Database.Log = Console.Write; // like this context.Database.Log = logInfo => Debug.WriteLine(logInfo); // or like this // Your code here... // How can I turn off logging here ? } ...I don't see a...
asp.net asp.net-mvc entity-framework entity-framework-6
asked by user1464139

Entity Framework Data Migrations for Different Environments

There are some base data specific for Dev/Test/Prod environments. ...We are using now Entity Framework Migrations for all the environments but do not know how to specify migrations for particular environments in a way that we specify a migration to be executed only on Dev/Test/Prod....This could be accomplished in Fluent Migrator with Tag attribute...
ef-migrations entity-framework entity-framework-6
asked by Mori

How to turn off pluralize for specific table in Entity Framework 6.0?

You can write this code in OnModelCreating method:...modelBuilder.Conventions.Remove();...But this is applying to all tables. Is it possible to turn off to specific table by passing the table name to such method....Thnx.
c# entity-framework-6
asked by KB1788

Publish to azure - turn off scheme update is terminating because data loss could occur

I am using EF6 code first, with automatic migrations disabled. All is fine on my local PC, but when I publish from Visual Studio to Azure I get the error message telling me that the schema update is terminating because data loss might occur. ...I know that the changes I'm running will mean that a data loss will occur but that is fine. But I can'...
azure entity-framework entity-framework-6 visual-studio visual-studio-2017
asked by Dan Faber

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