static void Main(string[] args) { using (var db = new StudentsContext()) { // Students Student = new Students { Fname = "Kobe", Lname = "Bryant", ID = 8, Address = "1111 S Figueroa St", City = "Los Angeles" }; // db.Students.Add(Student); // Students Student2 = new Students { Fname = "Zeke", Lname = "Elliot", ID = 21, Address = "1 AT&T Way", City = "Arlington" }; // db.Students.Add(Student2); // Students Student3 = new Students { Fname = "Lavar", Lname = "Ball", ID = 1, Address = "3 B Baller Way", City = "Big Baller Village" }; // //db.Students.Add(Student3); // db.SaveChanges(); //}; //db.Books.Add(book1); //using (var db = new CoursesContext()) //{ // Courses Course = new Courses { Title = "Geometry", Dept = "Math", CRN =102 }; // Courses Course2 = new Courses { Title = "Chemisty", Dept = "Science", CRN = 1212 }; // Courses Course3 = new Courses { Title = "Gym", Dept = "Physical Education", CRN = 501 }; //} //using (var db = new CoursesContext()) //{ // Scores Score = new Scores { Homework = "98% A+", Description = "Estimate your neighbors internet bill", Points = 98 }; // Scores Score2 = new Scores { Homework = "76% C", Description = "Fuse 2 Atoms together", Points = 76 }; // Scores Score3 = new Scores { Homework = "58% F+", Description = "", Points = 58 }; //} Student Student1 = new Student { Fname = "Kobe", Lname = "Bryant", Address = "1111 S Figueroa St", City = "Los Angeles", State = "Ca", Courses_ID = new List <Course>() }; db.Students.Add(Student1); Student Student2 = new Student { Fname = "Zeke", Lname = "Elliot", Address = "1 AT&T Way", City = "Arlington", State = "TX", Courses_ID = new List <Course>() }; db.Students.Add(Student2); Student Student3 = new Student { Fname = "Lavar", Lname = "Ball", Address = "3 B Baller Way", City = "Big Ballerville", State = "CA", Courses_ID = new List <Course>() }; db.Students.Add(Student3); Course Class1 = new Course { Title = "Geometry", CRN = 102, Dept = "Math", Points = "98", Instructor = "Skip Bayless", Scores_ID = new List <Score>() }; Student2.Courses_ID.Add(Class1); Course Class2 = new Course { Title = "Chemistry", CRN = 1212, Dept = "Science", Points = "76", Instructor = "Stephen A Smith", Scores_ID = new List <Score>() }; Student1.Courses_ID.Add(Class2); Course Class3 = new Course { Title = "Gym", CRN = 501, Dept = "Physical Education", Points = "58", Instructor = "Shannon Sharpe", Scores_ID = new List <Score>() }; Student2.Courses_ID.Add(Class3); Score Score = new Score { Type = "HW", Description = "Estimate your neighbor's WiFi password", Points = 98, }; Class2.Scores_ID.Add(Score); Score Score2 = new Score { Type = "Quiz", Description = "Fuse 2 Atoms together", Points = 76, }; Class3.Scores_ID.Add(Score2); Score Score3 = new Score { Type = "Exam", Description = "Run a sub 5.0 Second 40 yard dash", Points = 58, }; Class2.Scores_ID.Add(Score3); db.SaveChanges(); var query = from student in db.Students orderby student.Address select student; WriteLine("Students first name is"); WriteLine(); foreach (var student in query) { Console.WriteLine($"{student.Fname} {student.Lname}"); foreach (var Student in query) { WriteLine($"- Title: {Score.Type}"); WriteLine($"-- Student in Class: {Student2.ID}"); } WriteLine(); } WriteLine("Press a key to exit..."); ReadKey(); } }
static void Main(string[] args) { using (var db = new StudentsContext()) { // Students Student = new Students { Fname = "Kobe", Lname = "Bryant", ID = 8, Address = "1111 S Figueroa St", City = "Los Angeles" }; // db.Students.Add(Student); // Students Student2 = new Students { Fname = "Zeke", Lname = "Elliot", ID = 21, Address = "1 AT&T Way", City = "Arlington" }; // db.Students.Add(Student2); // Students Student3 = new Students { Fname = "Lavar", Lname = "Ball", ID = 1, Address = "3 B Baller Way", City = "Big Baller Village" }; // //db.Students.Add(Student3); // db.SaveChanges(); //}; //db.Books.Add(book1); //using (var db = new CoursesContext()) //{ // Courses Course = new Courses { Title = "Geometry", Dept = "Math", CRN =102 }; // Courses Course2 = new Courses { Title = "Chemisty", Dept = "Science", CRN = 1212 }; // Courses Course3 = new Courses { Title = "Gym", Dept = "Physical Education", CRN = 501 }; //} //using (var db = new CoursesContext()) //{ // Scores Score = new Scores { Homework = "98% A+", Description = "Estimate your neighbors internet bill", Points = 98 }; // Scores Score2 = new Scores { Homework = "76% C", Description = "Fuse 2 Atoms together", Points = 76 }; // Scores Score3 = new Scores { Homework = "58% F+", Description = "", Points = 58 }; //} Students Student1 = new Students { Fname = "Kobe", Lname = "Bryant", Address = "1111 S Figueroa St", City = "Los Angeles", State = "Ca", }; db.Students.add(Student1); Students Student2 = new Students { Fname = "Zeke", Lname = "Elliot", Address = "1 AT&T Way", City = "Arlington", State = "TX", }; db.Students.add(Student2); Students Student3 = new Students { Fname = "Lavar", Lname = "Ball", Address = "3 B Baller Way", City = "Big Ballerville", State = "CA", }; db.Students.add(Student3); Courses Class1 = new Courses { Title = "Geometry", CRN = 102, Dept = "Math", }; db.Courses.add(Class1); Courses Class2 = new Courses { Title = "Chemistry", CRN = 1212, Dept = "Science", }; db.Courses.add(Class2); Courses Class3 = new Courses { Title = "Gym", CRN = 501, Dept = "Physical Education", }; db.Courses.add(Class3); Scores Score = new Scores { Type = "HW", Description = "Estimate your neighbor's WiFi password", Points = 98, //PointsPossible = 100 }; db.Scores.add(Score1); Scores Score2 = new Scores { Type = "Quiz", Description = "Fuse 2 Atoms together", Points = 76, //PointsPossible = 100 }; db.Scores.add(Score2); Scores Score3 = new Scores { Type = "Exam", Description = "Run a sub 5.0 Second 40 yard dash", Points = 58, //PointsPossible = 100 }; db.Scores.add(Score3); } }