Database isn't creating and initializing

Question

I have specified the proper connection string in the web.config, but the database isn't creating nor it hits break point at seed method.

Code:

public class MusicStoreEntities:DbContext
{
    public DbSet<Genre> genres;

    public MusicStoreEntities()
        : base("name=MusicStoreConnection")
    {
        Database.SetInitializer(new Myinitialzer());
    }
}


public class Myinitialzer :CreateDatabaseIfNotExists<MusicStoreEntities>
{
    protected override void Seed(MusicStoreEntities context)
    {
        var genres = new List<Genre>
        {
            new Genre { Name = "Rock" },
            new Genre { Name = "Jazz" },
            new Genre { Name = "Metal" },

         };
     }
 }

Connection string:

 <add name="MusicStoreConnection" providerName="System.Data.SqlClient" connectionString="Data Source=WAQAR_DEV;Initial Catalog=PlanetWrox;Integrated Security=true;" />

waqar ahmed · Accepted Answer · 2016-01-05 06:13:00Z

1

setters and getters are also listed with dbset entities that is the only reason database wasnt creating,here to this specific code no migrations are needed as the database is not even generated.just only need to add

public DbSet<genres>genres{get;set;}

answered Jan 5, 2016 at 6:13

waqar ahmed

317 bronze badges

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

1 Comment

Peter Smith Over a year ago

Good spot - it's the obvious things that are hardest to see

Community · Accepted Answer · 2017-05-23 11:44:51Z

0

You need to add the genres in to the context and save it.

context.genres.AddRange(genres);
context.SaveChanges();

ALSO:

See this question and also this
You may need to add System.Data.Entity.CreateDatabaseIfNotExists to your initializer
Have you set up migrations, and are they auto?
You may need to run a migration
Are you getting any error messages

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Dec 29, 2015 at 13:11

Peter Smith

5,5529 gold badges54 silver badges80 bronze badges

2 Comments

waqar ahmed Over a year ago

its still not working as i have two model classes but i mentioned one here for simplicity for which i used this syntax ForEach(a => context.Albums.Add(a)

waqar ahmed Over a year ago

thanx peter smith for your help for providing good resources to learn but i need ur favour to accept my answer..

Collectives™ on Stack Overflow

Database isn't creating and initializing

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related