EF增删改
增加
User_Info userinfo = new User_Info();
userinfo.userID = 40;
userinfo.UserName = "王云召";
userinfo.PWD = "456456";
userinfo.Level = "管理员";
userinfo.Head = "杨老师";
charge_sysEntities db = new charge_sysEntities();//实例化DbConText的子类
db.User_Info.Add(userinfo);//将数据添加到EF,并且添加了标记
db.SaveChanges();//
删除`
charge_sysEntities db = new charge_sysEntities();
var userinfoList = from u in db.User_Info
where u.userID == 39
ser_Info userinfo = userinfoList.FirstOrDefault();//返回第一个元素,若没有,返回null
if (userinfo != null)
{
db.User_Info.Remove(userinfo);
//db.Entry<User_Info>(userinfo).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Console.WriteLine("删除成功!");
Console.ReadKey(); }
else
{
Console.WriteLine("要删除的数据不存在!");
Console.ReadKey(); }
修改
```csharp
在这里插入代码片