Stored Procedure in MVC

Question

I created two tables in sql-server 1. Employeedata contains employee details 2. Registration table. Now i created StoredProcedure to insert data in to Registration table it retreiving data from Employeedata table. stored procedure CREATE procedure [dbo].[RegistrationInsert]( @empEmail nvarchar( max ), @ password nvarchar ( max ) ) as begin insert into [Registration ] ([EmployeeName],[EmployeeEmail],[ Password ],[PhoneNumber],[Role],[EmployeeID]) select [EmployeeName],[EmployeeMailID],@ password ,[EmployeePhoneNumber],[EmployeeDesignation],[EmployeeID] from [Employeedata ] where [EmployeeMailID] = @empEmail end GO But i don't know how to call this procedure in MVC controller.

Eswar Datta · Answer

Answer : Step 1 : Create View Model public class Register { [Display(Name = "E-mail" )] [Remote( "IsUserNameAvailable" , "User" , ErrorMessage = "Email Already Exists" )] [Required(AllowEmptyStrings = false , ErrorMessage = "Email is Required" )] public string EmployeeEmail { get ; set ;} [Required(AllowEmptyStrings = false , ErrorMessage = "Password is Required" )] [Display(Name = "Password" )] [MinLength(6, ErrorMessage = "Minimum 6 Characters" )] public string Password { get ; set ; } } Step 2 : Add an empty Controller and create an ActionResult: [HttpPost] public ActionResult Register(Register view) { string message = "" ; db.RegistrationInsert(empEmail: view.EmployeeEmail, password: view.Password); ViewBag.Message = "Registered Successfully" ; return View(); } step 3 : Finally Create a view : @model MVCwithMultitables.Models.Register @{ ViewBag.Title = "Register" ; } Register @using (Html.BeginForm()) { @Html.AntiForgeryToken() class = "form-horizontal" > Register class = "alert-success" > @ViewBag.Message @Html.ValidationSummary( true , "" , new { @ class = "text-danger" }) class = "form-group" > @Html.LabelFor(model => model.EmployeeEmail, htmlAttributes: new { @ class = "control-label col-md-2" }) class = "col-md-10" > @Html.EditorFor(model => model.EmployeeEmail, new { htmlAttributes = new { @ class = "form-control" } }) @Html.ValidationMessageFor(model => model.EmployeeEmail, "" , new { @ class = "text-danger" }) class = "form-group" > @Html.LabelFor(model => model.Password, htmlAttributes: new { @ class = "control-label col-md-2" }) class = "col-md-10" > @Html.EditorFor(model => model.Password, new { htmlAttributes = new { @ class = "form-control" } }) @Html.ValidationMessageFor(model => model.Password, "" , new { @ class = "text-danger" }) class = "form-group" > class = "col-md-offset-2 col-md-10" > "submit" value= "Create" class = "btn btn-default" /> } @Html.ActionLink( "Back to List" , "Index" )

rajendra singh · Answer

Hi Eswar, When you connect your db with entiity framework all stored procedure word as function.You can access like below EntityFramework EF = new EntityFramework (); EF.RegistrationInsert('abc@gmail.com','test'); Thanks Rajendra Singh

Sanwar Ranwa · Answer

Hello Eswar, Use following links for your query https://www.aspsnippets.com/Articles/ASPNet-MVC-Call-Stored-Procedure-using-Entity-Framework.aspx https://www.c-sharpcorner.com/article/entity-framework-6-0-0-using-stored-procedure-in-asp-net-mvc/ https://www.c-sharpcorner.com/article/entity-framework-6-0-0-using-stored-procedure-in-asp-net-mvc/