Deleting a record efficiently using Entity Framework (EF) involves a few key considerations to minimize unnecessary database operations and improve performance.
public async void DeleteStudent(int Id) { UniverSityDBContext db = new UniverSityDBContext(); var studentData = db.Students.FindAsync(Id).Result; if (studentData == null) throw new Exception("Student not found"); db.Students.Remove(studentData); await db.SaveChangesAsync(); } // public void DeleteStudentOptimized(int Id) { UniverSityDBContext db = new UniverSityDBContext(); var student = new Student { ID = Id }; var studentEntity = db.Students.Attach(student); studentEntity.State = EntityState.Deleted; db.SaveChanges(); } 
Top comments (0)