Why won't my DataBase Initializer work? (Visual Studio 2017)

Question

Why won't my DataBase Initializer work? (Visual Studio 2017) Before I move it to the initializer class, it works. But starting with this lesson, my program won't load the comics in the Console Window, I don't get an error, and I never get to my breakpoint.

DatabaseInitializer.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity;
using ComicBookGalleryModel.Models;

namespace ComicBookGalleryModel
{
    internal class DatabaseInitializer
        : DropCreateDatabaseIfModelChanges<Context>
    {
        protected void Seed(Context context)
        {
            var series1 = new Series() { Title = "The Amazing Spider-Man" };
            var series2 = new Series() { Title = "The Invincible Iron Man" };
            var artist1 = new Artist() { Name = "Stan Lee" };
            var artist2 = new Artist() { Name = "Steve Ditko" };
            var artist3 = new Artist() { Name = "Jack Kirby" };
            var role1 = new Role() { Name = "Script" };
            var role2 = new Role() { Name = "Pencils" };


            var comicBook1 = new ComicBook() { Series = series1, IssueNumber = 1, PublishedOn = DateTime.Today };
            comicBook1.AddArtist(artist1, role1);
            comicBook1.AddArtist(artist2, role2);

            var comicBook2 = new ComicBook() { Series = series1, IssueNumber = 2, PublishedOn = DateTime.Today };
            comicBook2.AddArtist(artist1, role1);
            comicBook2.AddArtist(artist2, role2);

            var comicBook3 = new ComicBook() { Series = series2, IssueNumber = 1, PublishedOn = DateTime.Today };
            comicBook3.AddArtist(artist1, role1);
            comicBook3.AddArtist(artist3, role2);

            context.ComicBooks.Add(comicBook1);
            context.ComicBooks.Add(comicBook2);
            context.ComicBooks.Add(comicBook3);
            context.SaveChanges();
        }
    }
}

Context.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity;
using ComicBookGalleryModel.Models;
using System.Data.Entity.ModelConfiguration.Conventions;

namespace ComicBookGalleryModel
{


    public class Context : DbContext
    {
        public Context()
        {
            // Database.SetInitializer(new DropCreateDatabaseIfModelChanges<Context>());
            Database.SetInitializer(new DatabaseInitializer());

        }
        public DbSet<ComicBook> ComicBooks { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

            //modelBuilder.Conventions.Remove<DecimalPropertyConvention>();
            //modelBuilder.Conventions.Add(new DecimalPropertyConvention(5, 2));

            modelBuilder.Entity<ComicBook>().Property(cb => cb.AverageRating).HasPrecision(5, 2);
        }
    }
}

Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ComicBookGalleryModel.Models;
using System.Data.Entity;

namespace ComicBookGalleryModel
{


    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new Context())
            {


                var comicBooks = context.ComicBooks
                    .Include(cb => cb.Series)
                    .Include(cb => cb.Artists.Select(a => a.Artist))
                    .Include(cb => cb.Artists.Select(a => a.Role))
                    .ToList();

                foreach (var comicBook in comicBooks)
                {
                    var artistRoleNames = comicBook.Artists
                        .Select(a => $"{a.Artist.Name} - {a.Role.Name}").ToList();
                    var artistsRoleDisplayText = string.Join(", ", artistRoleNames);

                    Console.WriteLine(comicBook.DisplayText);
                    Console.WriteLine(artistsRoleDisplayText);
                }

                Console.ReadLine();
            }
        }
    }
}

Answer 1 · 2019-01-22T22:27:06Z

January 22, 2019 10:27pm

Kevin,

You're missing the override keyword on your Seed() method. Your method signature should look like this:

protected override void Seed(Context context)
{
}

Without the override keyword, your Seed() method is actually hiding the base class's Seed() method. You should be able to verify this by compiling your project and looking at the build output in Visual Studio. You should see a warning that your Seed() method is hiding the base class's method of the same name. The build warning will mention that you can add the new keyword to suppress the warning, but that's not what you want to do.

When the Seed() method is called at runtime, Entity Framework is likely calling it from the base type, so the base class's default implementation is what's getting executed. Once you add the override keyword, your method implementation will be executed instead (i.e. you're "overriding" the base class's method).

I hope this helps!

Thanks ~James

Answer 2 · 2019-01-10T23:48:32Z

January 10, 2019 11:48pm

The initializer code doesn't run until a change is made to the model. In the video, a test property is added to the "Artist" model (in Artist.cs, not shown here) to cause the code to run.

Did you do that (or make some other model change)?

Answer 3 · 2019-01-11T13:21:27Z

January 11, 2019 1:21pm

Steven Parker Yes, I added it, removed it, etc. I even deleted the database so it would create a new one -- no joy.

Welcome to the Treehouse Community

Looking to learn something new?

Kevin Gates

Kevin Gates

Why won't my DataBase Initializer work? (Visual Studio 2017)

Kevin Gates

Kevin Gates

3 Answers

James Churchill

James Churchill

Kevin Gates

Kevin Gates

Steven Parker

Steven Parker

Kevin Gates

Kevin Gates