Facebook
From Maciej, 6 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 294
  1. using ContosoUniversity.Models;
  2. using System;
  3. using System.Linq;
  4.  
  5. namespace ContosoUniversity.Data
  6. {
  7.     public static class DbInitializer
  8.     {
  9.         public static void Initialize(SchoolContext context)
  10.         {
  11.             context.Database.EnsureCreated();
  12.  
  13.             // Look for any students.
  14.             if (context.Students.Any())
  15.             {
  16.                 return;   // DB has been seeded
  17.             }
  18.  
  19.             var students = new Student[]
  20.             {
  21.             new Student{FirstMidName="Carson",LastName="Alexander",EnrollmentDate=DateTime.Parse("2005-09-01")},
  22.             new Student{FirstMidName="Meredith",LastName="Alonso",EnrollmentDate=DateTime.Parse("2002-09-01")},
  23.             new Student{FirstMidName="Arturo",LastName="Anand",EnrollmentDate=DateTime.Parse("2003-09-01")},
  24.             new Student{FirstMidName="Gytis",LastName="Barzdukas",EnrollmentDate=DateTime.Parse("2002-09-01")},
  25.             new Student{FirstMidName="Yan",LastName="Li",EnrollmentDate=DateTime.Parse("2002-09-01")},
  26.             new Student{FirstMidName="Peggy",LastName="Justice",EnrollmentDate=DateTime.Parse("2001-09-01")},
  27.             new Student{FirstMidName="Laura",LastName="Norman",EnrollmentDate=DateTime.Parse("2003-09-01")},
  28.             new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")}
  29.             };
  30.             foreach (Student s in students)
  31.             {
  32.                 context.Students.Add(s);
  33.             }
  34.             context.SaveChanges();
  35.  
  36.             var courses = new Course[]
  37.             {
  38.             new Course{CourseID=1050,Title="Chemistry",Credits=3},
  39.             new Course{CourseID=4022,Title="Microeconomics",Credits=3},
  40.             new Course{CourseID=4041,Title="Macroeconomics",Credits=3},
  41.             new Course{CourseID=1045,Title="Calculus",Credits=4},
  42.             new Course{CourseID=3141,Title="Trigonometry",Credits=4},
  43.             new Course{CourseID=2021,Title="Composition",Credits=3},
  44.             new Course{CourseID=2042,Title="Literature",Credits=4}
  45.             };
  46.             foreach (Course c in courses)
  47.             {
  48.                 context.Courses.Add(c);
  49.             }
  50.             context.SaveChanges();
  51.  
  52.             var enrollments = new Enrollment[]
  53.             {
  54.             new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A},
  55.             new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C},
  56.             new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B},
  57.             new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B},
  58.             new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F},
  59.             new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F},
  60.             new Enrollment{StudentID=3,CourseID=1050},
  61.             new Enrollment{StudentID=4,CourseID=1050},
  62.             new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F},
  63.             new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C},
  64.             new Enrollment{StudentID=6,CourseID=1045},
  65.             new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A},
  66.             };
  67.             foreach (Enrollment e in enrollments)
  68.             {
  69.                 context.Enrollments.Add(e);
  70.             }
  71.             context.SaveChanges();
  72.         }
  73.     }
  74. }