如何在代码优先实体框架中调用存储过程6 [英] How to call a Stored Procedure in Code First Entity Framework 6

问题描述

我是Entity Framework 6的新手，我想在我的项目中实现存储过程。我在谷歌深入搜索，但找不到任何我可以遵循实施的解决方案。我有一个如下的存储过程。

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)
AS
BEGIN
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
END

部门课程

Department Class

public class Department
{

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

}

modelBuilder 
.Entity<Department>() 
.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[^]

检查此链接可能对此有用你：



如何在dbcontext中的sqlquery中执行存储过程

check this link might be helpful for you:

how to execute stored procedures in sqlquery in the dbcontext

实际上Entity Framework不支持SP

但是如果你坚持使用它，我在下面的链接中回答了这个问题



浩w在实体框架6（代码优先）中调用存储过程？

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)?

这篇关于如何在代码优先实体框架中调用存储过程6的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！