ef增删改查



1. <pre name="code" class="csharp"> //EF查询  
2.         public userinfo GetUser(string username)  
3.         {  
4.             using (MyShopDBEntities1 entity = new MyShopDBEntities1())  
5.             {  
6.                userinfo  user = entity.userinfo.SingleOrDefault(model => model.username == username);  
7.                 return user;  
8.             }  
9.         }  
10.           
11.         //修改  
12.         public userinfo Update(string username,string userpwd)  
13.         {  
14.               
15.             using (MyShopDBEntities1 entity = new MyShopDBEntities1())  
16.             {  
17.                // userinfo user = entity.userinfo.SingleOrDefault(model => model.username == username);  
18.                 userinfo user = entity.userinfo.FirstOrDefault(model => model.username == username);  
19.                 if (user != null)   
20.                 {   user.userpassword=userpwd;  
21.                     entity.SaveChanges();   
22.                 }  
23.                   
24.                 return user;   
25.             }   
26.              
27.         }  
28.   
29.          
30.   
31.         //添加  
32.         public userinfo Add(userinfo user)  
33.         {  
34.             using (MyShopDBEntities1 entity = new MyShopDBEntities1())  
35.             {  
36.                 entity.userinfo.Add(  
37.   
38.                 new userinfo()  
39.                 {  
40.                     username = user.username,  
41.                     userpwd = user.userpwd  
42.                 });  
43.                 if (entity.SaveChanges() > 0)  
44.                 {  
45.                     return user;  
46.                 }  
47.                 else  
48.                     return null;  
49.             }  
50.         }  
51.   
52.         //删除  
53.         public void Deleted(string  username)  
54.         {  
55.             using (MyShopDBEntities1 entity = new MyShopDBEntities1())  
56.             {  
57.                 userinfo user = entity.userinfo.FirstOrDefault(m => m.username == username);  
58.                 if (user != null)  
59.                 {  
60.                    entity.userinfo.Remove(user);  
61.                 }  
62.   
63.                 if (entity.SaveChanges() > 0)  
64.                 {  
65.                     //return 0;  
66.                 }  
67.   
68.             }  
69.         }