How To Call Stored Procedure In MVC4 ASP.NET C#

If you are using Entity framework then below article might help you.

http://stackoverflow.com/questions/20970416/using-stored-procedure-in-entity-framework

If you are not using Entity Framework then calling of stored procedure is as usual as in ADO.Net

You are not specify you are using entity framework or simple ado.net database connectity in your application,
and in entity framework we have database first and code first methods,

If you are using simple ado.net then simplly you can call stored procedure from the command
If you are using database fist method then add stored procedure in edmx as following link:

http://www.entityframeworktutorial.net/EntityFramework4.3/execute-stored-procedure-using-dbcontext.aspx[^]

http://www.binaryintellect.net/articles/30738a7c-5176-4333-aa83-98eab8548da5.aspx[^]

http://msdn.microsoft.com/en-IN/library/ms189915.aspx[^]

http://stackoverflow.com/questions/4873607/how-to-use-dbcontext-database-sqlquerytelementsql-params-with-stored-proced[^]
http://visualstudiomagazine.com/articles/2014/04/01/calling-stored-procedures-from-entity-framework.aspx[^]


and if you are using code first then please follow below links :

Code First Stored Procedures[^]


http://www.dotnetcurry.com/showarticle.aspx?ID=938[^]



http://weblogs.asp.net/dwahlin/using-entity-framework-code-first-with-stored-procedures-that-have-output-parameters[^]

http://msdn.microsoft.com/en-in/data/jj691402.aspx[^]

(Fluent api)
http://stackoverflow.com/questions/20901419/how-to-call-stored-procedure-in-entity-framework-6-code-first[^]

http://www.c-sharpcorner.com/UploadFile/ff2f08/code-first-stored-procedure-entity-framework-6-0/[^]