SeedDataComplete.cs

using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using MvcUniversity.Models;

namespace MvcUniversity.Data
{
    public static class SeedData
    {
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new MvcUniversityContext(
                serviceProvider.GetRequiredService<
                    DbContextOptions<MvcUniversityContext>>()))
            {
                // Look for any students.
                if (context.Students.Any())
                {
                    return;   // DB has been seeded
                }

                var alexander = new Student
                {
                    FirstName = "Carson",
                    LastName = "Alexander",
                    EnrollmentDate = DateTime.Parse("2016-09-01")
                };

                var alonso = new Student
                {
                    FirstName = "Meredith",
                    LastName = "Alonso",
                    EnrollmentDate = DateTime.Parse("2018-09-01")
                };

                var anand = new Student
                {
                    FirstName = "Arturo",
                    LastName = "Anand",
                    EnrollmentDate = DateTime.Parse("2019-09-01")
                };

                var barzdukas = new Student
                {
                    FirstName = "Gytis",
                    LastName = "Barzdukas",
                    EnrollmentDate = DateTime.Parse("2018-09-01")
                };

                var li = new Student
                {
                    FirstName = "Yan",
                    LastName = "Li",
                    EnrollmentDate = DateTime.Parse("2018-09-01")
                };

                var justice = new Student
                {
                    FirstName = "Peggy",
                    LastName = "Justice",
                    EnrollmentDate = DateTime.Parse("2017-09-01")
                };

                var norman = new Student
                {
                    FirstName = "Laura",
                    LastName = "Norman",
                    EnrollmentDate = DateTime.Parse("2019-09-01")
                };

                var olivetto = new Student
                {
                    FirstName = "Nino",
                    LastName = "Olivetto",
                    EnrollmentDate = DateTime.Parse("2011-09-01")
                };

                var abercrombie = new Instructor
                {
                    FirstName = "Kim",
                    LastName = "Abercrombie",
                    HireDate = DateTime.Parse("1995-03-11")
                };

                var fakhouri = new Instructor
                {
                    FirstName = "Fadi",
                    LastName = "Fakhouri",
                    HireDate = DateTime.Parse("2002-07-06")
                };

                var harui = new Instructor
                {
                    FirstName = "Roger",
                    LastName = "Harui",
                    HireDate = DateTime.Parse("1998-07-01")
                };

                var kapoor = new Instructor
                {
                    FirstName = "Candace",
                    LastName = "Kapoor",
                    HireDate = DateTime.Parse("2001-01-15")
                };

                var zheng = new Instructor
                {
                    FirstName = "Roger",
                    LastName = "Zheng",
                    HireDate = DateTime.Parse("2004-02-12")
                };

                var english = new Department
                {
                    Name = "English",
                    Administrator = abercrombie
                };

                var mathematics = new Department
                {
                    Name = "Mathematics",
                    Administrator = fakhouri
                };

                var engineering = new Department
                {
                    Name = "Engineering",
                    Administrator = harui
                };

                var economics = new Department
                {
                    Name = "Economics",
                    Administrator = kapoor
                };

                var chemistry = new Course
                {
                    Id = 1050,
                    Title = "Chemistry",
                    Credits = 3,
                    Department = engineering,
                    Instructors = new List<Instructor> { kapoor, harui }
                };

                var microeconomics = new Course
                {
                    Id = 4022,
                    Title = "Microeconomics",
                    Credits = 3,
                    Department = economics,
                    Instructors = new List<Instructor> { zheng }
                };

                var macroeconmics = new Course
                {
                    Id = 4041,
                    Title = "Macroeconomics",
                    Credits = 3,
                    Department = economics,
                    Instructors = new List<Instructor> { zheng }
                };

                var calculus = new Course
                {
                    Id = 1045,
                    Title = "Calculus",
                    Credits = 4,
                    Department = mathematics,
                    Instructors = new List<Instructor> { fakhouri }
                };

                var trigonometry = new Course
                {
                    Id = 3141,
                    Title = "Trigonometry",
                    Credits = 4,
                    Department = mathematics,
                    Instructors = new List<Instructor> { harui }
                };

                var composition = new Course
                {
                    Id = 2021,
                    Title = "Composition",
                    Credits = 3,
                    Department = english,
                    Instructors = new List<Instructor> { abercrombie }
                };

                var literature = new Course
                {
                    Id = 2042,
                    Title = "Literature",
                    Credits = 4,
                    Department = english,
                    Instructors = new List<Instructor> { abercrombie }
                };

                var enrollments = new Enrollment[]
                {
                    new Enrollment {
                        Student = alexander,
                        Course = chemistry,
                        Grade = Grade.A
                    },
                    new Enrollment {
                        Student = alexander,
                        Course = microeconomics,
                        Grade = Grade.C
                    },
                    new Enrollment {
                        Student = alexander,
                        Course = macroeconmics,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = alonso,
                        Course = calculus,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = alonso,
                        Course = trigonometry,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = alonso,
                        Course = composition,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = anand,
                        Course = chemistry,
                    },
                    new Enrollment {
                        Student = anand,
                        Course = microeconomics,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = barzdukas,
                        Course = chemistry,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = li,
                        Course = composition,
                        Grade = Grade.B
                    },
                    new Enrollment {
                        Student = justice,
                        Course = literature,
                        Grade = Grade.B
                    }
                };

                context.AddRange(enrollments);
                context.SaveChanges();
            }
        }
    }
}