Stored Procedure in MVC

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.

Answer :

Step 1 : Create View Model

Step 2 : Add an empty Controller and create an ActionResult:

step 3 : Finally Create a view :

Hi Eswar,

When you connect your db with entiity framework all stored procedure word as function.You

can access like below

Thanks

Rajendra Singh

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/

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Eswar Datta8y ago
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" })