public static void DeleteStudentRecordById(int id) { using (var db = new UniversityDBContext()) { var selected_rcd = db.Students.FirstOrDefault(d => d.StudentId == id); db.Students.Remove(selected_rcd); db.SaveChanges(); } }
public static void UpdateStudentRecordById(int id) { using (var db = new UniversityDBContext()) { var selected_rcd = db.Students.FirstOrDefault(d => d.StudentId == id); selected_rcd.LastName = "Dawadi"; db.SaveChanges(); } }
public static void ReadStudentRecordById(int id) { using (var db = new UniversityDBContext()) { var selected_rcd = db.Students.FirstOrDefault(d => d.StudentId == id); Console.WriteLine("Name " + selected_rcd.FirstName + " " + selected_rcd.LastName); //var last_name = db.Students.Where(c => c.LastName.StartsWith("D")); //foreach (var s in last_name) // Console.WriteLine(s.FirstName + " " + s.LastName); } }
public static void ReadRecords() { using (var db = new UniversityDBContext()) { var students = db.Students; foreach (var row in students) { Console.WriteLine(row.FirstName + " " + row.LastName + " DOB: " + row.BirthDay); } } }
public static void AddCourse() { using (var db = new UniversityDBContext()) { var course = new Course { Name = "Math" }; db.Courses.Add(course); db.SaveChanges(); } }
public static void AddStudentRecords() { using (var db = new UniversityDBContext()) { var student = new Student { FirstName = "Hank", LastName = "Clinton", BirthDay = DateTime.Now }; db.Students.Add(student); student = new Student { FirstName = "Dan", LastName = "Trump", BirthDay = DateTime.Now }; db.Students.Add(student); db.SaveChanges(); } }