EF Code First Not Generating Tables

Question

I'm working on an EF Code first site, and I've written my classes and a context class, the source of which is:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;
using MySite.SalesTool.Data.Entities;
using System.Data.Entity.ModelConfiguration.Conventions;


namespace MySite.SalesTool.Data
{
    public class SalesToolEntities : DbContext
    {
        public DbSet<User> Users { get; set; }
        public DbSet<UserRole> UserRoles { get; set; }
        public DbSet<Job> Jobs { get; set; }
        public DbSet<JobAssigner> JobAssigners { get; set; }
        public DbSet<JobFile> JobFiles { get; set; }
        public DbSet<JobStatus> JobStatuses { get; set; }
        public DbSet<AssignedUser> AssignedUsers { get; set; }
    }
}

The project builds fine, but when I go to run the site, no tables are created in the database and I get an error stating that the database can't find whichever context object I try and access, presumably because the code first has not generated any of the necessary tables.

Any ideas why it wouldn't generate any of the tables at all, and not give me any kind of error information?

Answer 1

Do you have an initialization strategy?

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

From what you subscribe it sounds like you've created the database yourself. Then you need to specify an initialization strategy otherwise no tables/data will be added to the database and querying the database will result in an exception: {"The specified table does not exist. [ sometable ]"}