EF Code first deployment script

Question

I am new to EF Code first with MVC

I am looking deployment script for my project in various environments, QA, UAT and Production.

Is there any way i can develped script to deply in by one click. I've Models in seperate project.

Please share you thoughts.

Muhammad Tariq Siddiqui · Accepted Answer · 2015-06-29 19:58:42Z

1

Please clear the question. Following are my assumption as you facing problem in deploying EF MVC Code First application

To deployed website on QA, UAT or production server, Build Publish of the project and configure it in IIS. As you are using EF Code first approach once website will run it will create database at given location that is provided by you in web.config file.

To work website properly you have to create default data in Seed method of Configuration.cs

answered Jun 29, 2015 at 19:58

Muhammad Tariq Siddiqui

1093 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Miroslav Holec · Accepted Answer · 2015-06-29 21:58:46Z

0

You can use Seed method in your DbInitializer

public class YourInitializer: DropCreateDatabaseAlways<YourDbContext>
{
   protected override void Seed(YourDbContext context)
   {
      YourEntity entity = new YourEntity();
      context.YourDbSet.AddOrUpdate(entity);
      context.SaveChanges();
      base.Seed(context);
   }
}

You can use more Initializer types... explained here: http://www.codeguru.com/csharp/article.php/c19999/Understanding-Database-Initializers-in-Entity-Framework-Code-First.htm

Another solution is write your own powershell script, that connects to your database and make changes. This powershell script you can fire on build server etc.

If you want to change behavior on various servers, you can create some configuration attribute using Web.Config / App.Config (section appSettings).

answered Jun 29, 2015 at 21:58

Miroslav Holec

3,25727 silver badges24 bronze badges

1 Comment

HPP Over a year ago

Thanks Muhammad and Miroslav, I've seed method in Initializer, but it never got called, which is under Models project. namespace Models { public class MyInitializer : System.Data.Entity.CreateDatabaseIfNotExists<MyContext> { protected override void Seed(MyContext context){ } } } I don't know, why it's not calling. It does create database and tables without any data in it.

Collectives™ on Stack Overflow

EF Code first deployment script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related