EntityFramework 学习一 Delete Entity using DBContext in Disconnected Scenario

weixin_30856965

于 2017-03-25 21:30:00 发布

阅读量77

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lanpingwang/p/6618597.html

本文介绍了一种从数据库中删除特定学生记录的方法。通过使用Entity Framework，首先从SchoolDBEntities获取要删除的学生实例，然后在一个新的上下文中设置该实例的状态为已删除，并保存更改。

Student studentToDelete;
//1. Get student from DB
using (var ctx = new SchoolDBEntities())
{
    studentToDelete = ctx.Students.Where(s => s.StudentName == "Student1").FirstOrDefault<Student>();
}

//Create new context for disconnected scenario
using (var newContext = new SchoolDBEntities())
{
    newContext.Entry(studentToDelete).State = System.Data.Entity.EntityState.Deleted;    

    newContext.SaveChanges();
}