Dapper Using SQL Stored Procedure

SQL stored procedures can be used with dapper ORM by writing the few lines of code. Let's consider we have following values needs to be inserted into the SQL database using stored procedure with the help of dapper ORM

  • Name
  • City
  • Address

Create the stored procedure to map the above parameters

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

Create the C# property class to map the above stored procedure parameters

    public class Employee

    {     
       [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; }

    }

Create the method to insert the values using the dapper

       public void AddEmployee(Employee objEmp)

        {
            //Passing stored procedure using Dapper.NET
                connection();
                con.Execute("AddNewEmpDetails", objEmp, commandType: CommandType.StoredProcedure);
               
       }

In the above method
  • Connection() is the method which contains the connection string .
  • Con is the SqlConnection class object.
  • AddNewEmpDetails is the stored procedure.
  • ObjEmp is the object of model class
Summary

I hope this article is useful for all readers. If you have any questions then type in comment box.

Post a comment

www.CodeNirvana.in

Protected by Copyscape Online Copyright Protection
Copyright © Compilemode