Cannot Generate Database from Entity Framework 4.1 Codefirst With SQL Server 2005

Question

I try to create database from entity framework code first follow with this tutorial

http://www.asp.net/mvc/tutorials/getting-started-with-mvc3-part4-cs

but I use SQL Server 2005 instead when SQLExpress but When I execute solution don't have anything create. What wrong with my code

This is my code.

Movie.cs

public class Movie
{
    public int ID { get; set; }
    public string Title { get; set; }
    public DateTime ReleaseDate { get; set; }
    public string Genre { get; set; }
    public decimal Price { get; set; }
}

public class MovieDBContext : DbContext
{
    public DbSet<Movie> Movies { get; set; }
}

And this is my connection string in web.config

<add name="MovieDBContext" 
     connectionString="data source=...;Integrated Security=SSPI;initial catalog=MovieDB;User Id=...;Password=..."
     providerName="System.Data.SqlClient" />

What Wrong with my code? Why database wasn't created.

thank you every one to help me.

Ladislav Mrnka · Accepted Answer · 2011-07-12 10:32:30Z

3

The database is not created until it is used for the first time. You must do any of following to trigger database creation:

Create instance of your context and retrieve or persist any data
Create instance of your context and call context.Database.CreateIfNotExists()
Create instance of your context and call context.Database.Initialize(false)
Create instance of your context and call context.Database.Create()

edited Jul 12, 2011 at 10:32

answered Jul 12, 2011 at 10:26

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

1 Comment

Zabahey Over a year ago

Thank you very much for your answer. I so confuse with this for along time.

Jayantha Lal Sirisena · Accepted Answer · 2011-07-12 10:20:36Z

0

Have you added initialize methid in application start in your Global.asax file

 Database.SetInitializer(new DropCreateDatabaseIfModelChanges<MovieDBContext>());

edited Jul 12, 2011 at 10:20

answered Jul 12, 2011 at 10:15

Jayantha Lal Sirisena

21.4k11 gold badges74 silver badges94 bronze badges

1 Comment

Zabahey Over a year ago

Yes, I try to add them in my code but don't have anything happen

b0rg · Accepted Answer · 2011-07-12 14:41:01Z

0

Here's mine. I'm forcing database init, then ditching the context, then I'm force seeding it. I couldn't get the default behaviour to work with both Oracle and SQL CE.

var initer = new PPContextInitializer();
Database.SetInitializer<MovieDBContext >(new DropCreateDatabaseIfModelChanges<MovieDBContext >());

using (var db = new MovieDBContext())
{
    db.Database.Initialize(true);
}

using (var db1 = new MovieDBContext())
{
    initer.Seed(db1);
}

answered Jul 12, 2011 at 14:41

b0rg

1,89712 silver badges17 bronze badges

Collectives™ on Stack Overflow

Cannot Generate Database from Entity Framework 4.1 Codefirst With SQL Server 2005

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related