Click here to Skip to main content
15,851,387 members
Please Sign up or sign in to vote.
3.67/5 (2 votes)
I am very new to Entity Framework 6 and i want to implement Stored Procedure in my project. I searched in google deeply but couldn't find any solution in which i can follow the implementation. I have a stored procedure like below.

ALTER PROCEDURE [dbo].[insert_department]
@Name [varchar](100)
INSERT [dbo].[Departments]([Name])
VALUES (@Name)

DECLARE @DeptId int
SELECT @DeptId = [DeptId]
FROM [dbo].[Departments]
WHERE @@ROWCOUNT > 0 AND [DeptId] = scope_identity()

SELECT t0.[DeptId]
FROM [dbo].[Departments] AS t0
WHERE @@ROWCOUNT > 0 AND t0.[DeptId] = @DeptId

Department Class

public class Department

    public int DepartmentId { get; set; }       
    public string Name { get; set; }


.MapToStoredProcedures(s => 
s.Update(u => u.HasName("modify_department") 
               .Parameter(b => b.Department, "department_id") 
               .Parameter(b => b.Name, "department_name")) 
 .Delete(d => d.HasName("delete_department") 
               .Parameter(b => b.DepartmentId, "department_id")) 
 .Insert(i => i.HasName("insert_department") 
               .Parameter(b => b.Name, "department_name")));

protected void btnSave_Click(object sender, EventArgs e)
          string department = txtDepartment.text.trim();

         // Here i want to call the stored procedure to insert values


My problem is how do i call the stored procedure and pass parameters into it. Please help me out. Thanks in advance.

Check this sample application:

Entity Framework for Beginners[^]
Share this answer
check this link might be helpful for you:

how to execute stored procedures in sqlquery in the dbcontext
Share this answer
actually Entity Framework does not support SP
but if you insist to use it , i answered this question in link below

How to call Stored Procedure in Entity Framework 6 (Code-First)?
Share this answer
Share this answer
apurba001 3-Jan-14 10:05am    
Thanks Jameel for your reply. I followed the link you have posted but it does not given the way how to execute the stored procedure from code behind.
Refer - Code First Insert/Update/Delete Stored Procedures[^].

It describes how to configure your Code First model to use stored procedures and pass parameters to them.
Share this answer
Member 4750507 7-Mar-14 18:46pm    
That article is only for insert/update/delete stored procedures. What about just general stored procedures that do a bunch of things and return a recordset? That aren't related to insert/update/delete?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900