DormManagesEntities ef = new DormManagesEntities();
一.获得单个对象
a) var adminInfo=ef.AdminInfoes.Find("admin");只能查找主键值
b) var adminInfo = (from item in ef.AdminInfoes where item.DormId == "05" select item).FirstOrDefault();
备注:.FirstOrDefault()要记得加才可以获得单个对象
二.添加
a) AdminInfo adminInfo = new AdminInfo();
adminInfo.AdminId = "this_xyh";
adminInfo.AdminName = "徐一航";
adminInfo.DormId = "02";
adminInfo.Images = "无";
adminInfo.pwd = "1234";
ef.AdminInfoes.Add(adminInfo);
ef.SaveChanges();
b) ef.AdminInfoes.Attach(adminInfo);
ef.Entry(adminInfo).State = EntityState.Added;
ef.SaveChanges();
三.删除
a) AdminInfo adminInfo = new AdminInfo { AdminId = "this_xyh" };
ef.AdminInfoes.Attach(adminInfo);
ef.AdminInfoes.Remove(adminInfo);
ef.SaveChanges()
b) AdminInfo adminInfo = new AdminInfo { AdminId = "this_xyh" };
ef.AdminInfoes.Attach(adminInfo);
ef.Entry(adminInfo).State = EntityState.Deleted;
ef.SaveChanges()
三.修改
a) 想要修改哪个列就修改哪个列,没有修改的就不变
AdminInfo adminInfo = ef.AdminInfoes.Find("this_xyh");
adminInfo.AdminId = "this_xyh";
adminInfo.AdminName = "王炸";
adminInfo.DormId = "222";
adminInfo.Images = "无";
adminInfo.pwd = "1222";
ef.SaveChanges();
b) 这个方法要把所有的字段给赋值,不然会出错
AdminInfo adminInfo = new AdminInfo();
adminInfo.AdminId = "this_xyh";
adminInfo.AdminName = "王11炸";
adminInfo.DormId = "22112";
adminInfo.Images = "无";
adminInfo.pwd = "1221111";
ef.AdminInfoes.Attach(adminInfo);//添加到上下文(对象管理器)
ef.Entry(adminInfo).State = EntityState.Modified;//修改他的状态
ef.SaveChanges();
四.查询(效率很关键)
i. 使用LINQ 查询方法或者 查询语句
.....
还有很多东西有没有博友有好的学习资源求发