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
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 }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)