Code First: Create Tables but not database

Question

I have ready my model on code first EF and I try it on sql express and it works. But I have a problem translating it to a sql server: I don't have the permissions to recreate a database I can only add tables to an empty database.

I already see this answer but when I'm trying to replicate it I have some troubles with the context part:

public class DropCreateDatabaseTables : IDatabaseInitializer<Context> {

#region IDatabaseInitializer<Context> Members



public void InitializeDatabase(Context context)

I already put the reference to System.Data.Entity but that don't work and the Context class not is the referenced on System.Runtime.Remoting.Contexts

There is something wrong in the code? Or is a better solution with the last tools of EF?

EDIT:

Finally was:

DbContext:

public class PeopleContext: DbContext
{
    public DbSet<Person> People { get; set; }
    public DbSet<Adress> Adresses{ get; set; }


    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        // Add Entity type configuration classes
        modelBuilder.Configurations.Add(new PersonConfiguration());
        modelBuilder.Configurations.Add(new AdressConfiguration());

    }
}

Initializer:

  public class DropCreateDatabaseTables : IDatabaseInitializer<PeopleContext>
{

    public void InitializeDatabase(PeopleContextContext)
    {

      bool dbExists;

      using (new TransactionScope(TransactionScopeOption.Suppress))

      {

        dbExists = Context.Database.Exists();

      }

      if (dbExists)

      {       

        // remove all tables
          Context.Database.ExecuteSqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'");
          Context.Database.ExecuteSqlCommand("EXEC sp_MSforeachtable @command1 = \"DROP TABLE ?\"");



        // create all tables

        var dbCreationScript = ((IObjectContextAdapter)Context).ObjectContext.CreateDatabaseScript();

        Context.Database.ExecuteSqlCommand(dbCreationScript);


        Context.SaveChanges();

      }

      else

      {

          throw new ApplicationException("No database instance");

      }

    }
}

Call:

class Program
{
    static void Main(string[] args)
    {
        var person= new Person
        {
            Identifier= "John Doe"
        };
        Database.SetInitializer(new DropCreateDatabaseTables());
        using (var context = new PeopleContext())
        {
            context.People.Add(person);
            context.SaveChanges();


        }
    }
}

Thanks Lukas Kabrt!

Don't start by writing your own initializer, but use the standard ones, like Database.SetInitializer(new DropCreateDatabaseAlways<Context>()); See DropCreateDatabaseAlways. — Gert Arnold
– Gert Arnold, Commented Oct 14, 2013 at 21:32
Because my credentials I can't drop the database and recreate it I just can create tables over an existing empty database — rlartiga
– rlartiga, Commented Oct 14, 2013 at 23:56

Lukas Kabrt · Accepted Answer · 2013-10-15 15:30:39Z

3

The Context class in the example should be your DbContext class i.e. the class where you specify your DbSet<>s.

Example:

DbContext class

public class DataContext : DbContext {
    public DbSet<Customer> Customers { get; set; }
}

DatabaseInitializer

public class DropCreateDatabaseTables : IDatabaseInitializer<DataContext> {
    ...
}

answered Oct 15, 2013 at 15:30

Lukas Kabrt

5,5194 gold badges45 silver badges59 bronze badges

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

3 Comments

rlartiga Over a year ago

I try your solution, but I don't know how it does nothing: Can I edit my post with the code and you tell me if is correct?

Lukas Kabrt Over a year ago

Go ahead, I can try looking at your ... I though you have just problems with compiling your code, so I haven't written any implementation of the initializer

rlartiga Over a year ago

Don't worry it work I edited de question with the correct code. Thanks!

Collectives™ on Stack Overflow

Code First: Create Tables but not database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related