如何在代码优先实体框架中调用存储过程6 [英] How to call a Stored Procedure in Code First Entity Framework 6
本文介绍了如何在代码优先实体框架中调用存储过程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屋!
查看全文