如何在实体框架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}我的问题是:
沧海一幻觉
随时随地看视频慕课网APP
相关分类