How to call a Stored Procedure with Parameters in MVC?

Jagan Mohan

13y20.7k.NET

Hi to all.For the past two weeks i'm trying to learn ASP.NET MVC.I've created a small data entry application.with Model Binding i'm saving data into database(by the way i'm using Database First Approach(creating Model Classes from an Existing Database)) successfully.Now my requirement is i've a stored procedure whose process is to take all the user input values as parameters and saving those values into database by executing the corresponding stored procedure.How to implement this process in ASP.NET MVC 3 with Database First Approach? Anyone can help me regarding this scenario.

Thanks in Advance.

2 Replies

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

Jignesh Trivedi13y ago
hi,
Are you going to use traditional ADO.net with MVC or use Entity Framework?
please refer below link , it might help you if you use EF as Data Access.
http://msdn.microsoft.com/en-us/data/gg699321.aspx
Agree with Javeed to if you use traditional ADO.net.
hope this will help you.
Javeed M Shaikh13y ago
I am not sure if MVC is responsible for the way you access your data, you can call the plain old method to call your stored procedure in the controller.

public ActionResult Convert(int parameter1)
{
var connection = new SqlConnection("connectionstring");

var command = new SqlCommand("storedprocedurename",connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@parameterID", parameter1);

connection.Open();

command.ExcuteNonQuery();

connection.Close();
}

- add exception handling
- code can be further optimized
- written this way for simplicity.