How To Use Stored Procedure With Dapper In ASP.NET MVC

In this article we will learn how to map stored procedure parameter with Dapper ORM .To map stored procedure with Dapper ORM  DynamicParameters class of Dapper is used, lets see how to map it
Suppose you have following Model class of parameters which values comes from UI

public class EmpModel
    {
        [Display(Name = "Id")]
        public int Empid { get; set; }
        [Required(ErrorMessage = "First name is required.")]
        public string Name { get; set; }
        [Required(ErrorMessage = "City is required.")]
        public string City { get; set; }
        [Required(ErrorMessage = "Address is required.")]
        public string Address { get; set; }
    }

 Download Aspose : API To Create and Convert Files..
Now consider following stored procedure we have

Create procedure [dbo].[AddNewEmpDetails]  
(  
   @Name varchar (50),  
   @City varchar (50),  
   @Address varchar (50)  
)  
as  
begin  
   Insert into Employee values(@Name,@City,@Address)  
End  

 Download Aspose : API To Create and Convert Files..
Now following is the function which is used to map the stored procedure with Dapper

   public bool AddEmployee(EmpModel obj)
        {     
                DynamicParameters param = new DynamicParameters();
                param.Add("@@Name", obj.Name);
param.Add("@City", obj.City);
param.Add("@Address",obj.Address);
                connection();
                con.Open();
                con.Execute("AddNewEmpDetails", param, commandType: CommandType.StoredProcedure);
                con.Close();
                return true;         
        }
 



In the above function
  •  Connection() is the method which contains the connection string .
  •  Con is the SqlConnection class object.
  • AddNewEmpDetails is the stored procedure.
  •  DynamicParameters is the Dapper class name to map parameter like as SqlCommand
  • EmpModel is  model class.
 Download Aspose : API To Create and Convert Files

 Watch Video

Summary
I hope this article is useful for all readers. If you have any suggestion then please contact me.
Download Aspose : API To Create and Convert Files..
Read my other MVC articles
  




Post a Comment

www.CodeNirvana.in

Protected by Copyscape
Copyright © Compilemode