public static void AddStudent(string Name) { Students student = new Students(); student.Name = Name; //add a student using (var newStudent = new KeithEntityModelContainer()) { newStudent.Students.Add(student); newStudent.SaveChanges(); } }
public static List <Students> GetStudentList() { List <Students> ListOfStudents = new List <Students>(); KeithEntityModelContainer K = new KeithEntityModelContainer(); foreach (EntityFramework.Students item in K.Students.Select(row => row)) { ListOfStudents.Add(item); } return(ListOfStudents); }
public static void DeleteStudent(string Name) { Students studentToDelete; //1. Get student from DB using (var ctx = new KeithEntityModelContainer()) { studentToDelete = ctx.Students.Where(s => s.Name == Name).FirstOrDefault <Students>(); } //Create new context for disconnected scenario using (var newContext = new KeithEntityModelContainer()) { newContext.Entry(studentToDelete).State = System.Data.Entity.EntityState.Deleted; newContext.SaveChanges(); } }
public static void UpdateStudent(string OldName, string NewName) { Students student; //1.Get student from DB using (var entityModel = new KeithEntityModelContainer()) { student = entityModel.Students.Where(s => s.Name == OldName).FirstOrDefault <Students>(); } //2.change student name if (student != null) { student.Name = NewName; } //3.save entity using (var entityModel = new KeithEntityModelContainer()) { //a. Mark as modified entityModel.Entry(student).State = System.Data.Entity.EntityState.Modified; //b. save changes entityModel.SaveChanges(); } }