如何在实体框架6(代码优先)中调用存储过程?我对实体框架6非常陌生,我想在我的项目中实现存储过程。我有一个存储过程如下:ALTER PROCEDURE [dbo].[insert_department]
@Name [varchar](100)ASBEGIN
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] = @DeptIdENDDepartment班级: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}我的问题是:如何调用存储过程并向其传递参数?
3 回答
- 3 回答
- 0 关注
- 490 浏览
添加回答
举报
0/150
提交
取消