Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
Node is saved as draft in My Content >> Draft

  • LINQ Delete in MVC

    @HIMANSHU
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 35
    Comment on it

    While working in MVC we use LINQ to make our task easier and to make the manipulations easier

     

    First we will create the action for doing this task.

     

    2.         [HttpPost]
    3.         public JsonResult Remove(int id)
    4.         {
    5.             new GridModel().Remove(id);
    6.             return Json(true);
    7.         }
    8.  

     

    After this we will create a class that will perform the implementation of the LINQ query.

     

    Before doing this we need to create the DataContext for this model.

     

    1.  public enum getstatus
    2.     {
    3.         success, failure
    4.     }
    5.     public class EmployeeModel
    6.     {
    7.  
    8.         public int EmpId { get; set; }
    9.         [Required(ErrorMessage = "First Name is required")]
    10.         public string FirstName { get; set; }
    11.         public string MiddleName { get; set; }
    12.         [Required(ErrorMessage = "Last Name is required")]
    13.         public string LastName { get; set; }
    14.         [Required(ErrorMessage = "PhoneNo is required")]
    15.         public string PhoneNo { get; set; }
    16.         public string Address { get; set; }
    17.         public getstatus Status { get; set; }
    18.         public string msg { get; set; }
    19.     }

     

     

     

    After doing this we can use this context model object to delete the records from the database.

     

    1.    public void Remove(int id)
    2.         {
    3.             var deletedproducts = from p in DataContextObj.EmployeeDetails
    4.                                   where p.EmpId == id
    5.                                   select p;
    6.             DataContextObj.EmployeeDetails.DeleteAllOnSubmit(deletedproducts);
    7.  
    8.             DataContextObj.SubmitChanges();
    9.         }

     

     

     

    .net
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: