新增
TestDBEntities1 db = new TestDBEntities1();
var classinfo=new Classinfo()
{
name="qq",
remarek="ww"
};
db.Classinfo.add(classinfo);
var classinfo2=new Classinfo()
{
name="qq",
remarek="ww"
};
db.Entry(classinfo2).state=System.Data.Entity.EntityState.Added;
修改
TestDBEntities1 db = new TestDBEntities1();
var classinfo=new Classinfo()
{
id=1,
name="qq",
remarek="ww"
};
db.Entry(classinfo).State=System.Data.Entity.EntityState.Medified;
删除
TestDBEntities1 db = new TestDBEntities1();
var classinfo=new Classinfo()
{
id=1,
name="qq",
remarek="ww"
};
db.Classinfo.remove(classinfo);
var classinfo2=new Classinfo()
{
name="qq",
remarek="ww"
};
var classinfos= db.Classinfo.where(p=>p.name=="qq").ToList();
db.remove(classinfos);
var classinfos2=db.Classinfo.Find(id);
db.remove(classinfos2);
查询
TestDBEntities1 db = new TestDBEntities1();
var classinfos=db.Classinfo.ToList();
var classinfos2=db.Classinfo.find(id).ToList();
var classinfos3=db.Classinfo.where(p=>p.name=="QQ").ToList();