如何在实体框架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] = @DeptIdEND
Department
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}
我的问题是:
相关分类