创建上下文
/*实例化上下文*/
ExcellentMcoinEntities dbcontext = new ExcellentMcoinEntities();
增加
list mylist= new list();
mylist.id = 1;
mylist.name = "tt";
//附加到上下文
dbcontext.list.add(mylist);
//保存更新数据库
dbcontext.savechanges();
修改
//修改,通常是所有属性都赋值
mylist.id = 2;
mylist.name = 2;
dbcontext.Entry<list>(mylist).State = EntityState.Modified;
dbcontext.SaveChanges();
删除
var mylist= dbcontext.list.Find(2); //也可以兼做查询,然后获取符合条件的记录进行删除
dbcontext.Entry<list>(mylist).State = EntityState.Deleted;
dbcontext.SaveChanges();
查询
//最通常的手段就是使用Linq和Lambda
var testList1 = (from u in dbcontext.list
where u.id = 2
select u);