Home  • Programming • C#.NET

Create, Read, Update, Delete (CRUD) operations with Entity Framework in C#

Assuming that you have a User table with the following fields and type:
Idint(10)
Namevarchar(50)
Phonevarchar(50)
Note: Id is Auto Number field. Figure: Entity Data Model on User Table Create
public void createUser(string _name, string _phone){

   User u = new User();
   u.Name = _name;
   u.Phone =_phone;
        
   DatabaseEntities de = new DatabaseEntities();
   de.AddObject("Users",u);
   de.SaveChanges();

 }
Read
public string searchUser(int _id){
 
   DatabaseEntities de = new DatabaseEntities();

   var query = from o in de.Users where o.Id==_id select o;        
   string str = "";

   foreach (User u in query){
           
        str = "ID: " + u.Id + " " + u.Name + " " + u.Phone;         
           
   }
 
return str;
}

Update
public void updateUser(int _id,string _name,string _phone){

   DatabaseEntities de = new DatabaseEntities();
   User u =de.Users.Where("it.Id=" + _id).First();
   u.Name = _name;
   u.Phone =_phone;        
   de.SaveChanges();

}
Delete
public void deleteUser(int _id){

   DatabaseEntities de = new DatabaseEntities();
   User u = de.Users.Where("it.Id=" + _id).First();
   de.DeleteObject(u);
   de.SaveChanges();

}
Example of Use
protected void btnCreate_Click(object sender, EventArgs e){
      
   string name = txtName.Text;
   string phone = txtPhone.Text;

   createUser(name,phone);

   txtName.Text = "";
   txtPhone.Text = "";
}

Comments 0


Share

Copyright © 2024. Powered by Intellect Software Ltd