新增
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 ( ) ;