How to use stored procudures with EF.

Question

For performance shake we have created SP and now we have to use them instead of linq queries , how to do that.

Sachin Singh · Accepted Answer

when you import tables into your Entity data model (EDMX) at that time check the sp aswell , all your SPs will be available as a simple c# method of DbContext , which can be called by an dbContext object in the application. https://www.sharpencode.com/article/EntityFramework/database-first-approach/what-about-store-procedure-and-functions

Rijwan Ansari · Answer

You can use dbcontext to execute stored procedure. Example: Function in unitOfWork (common function) public  DbRawSqlQuery   SQLQuery ( string  sql,  params   object [] parameters)          {               return  context.Database.SqlQuery (sql, parameters);          }   context is initiated into constructor.    Use of function:  public  List  GetUserRoleDetailsByModule( int  moduleId,long userId)           {                try                {                   var parameters =  new  List ();                   parameters.Add( new  SqlParameter( "@ModuleId" , moduleId));                   parameters.Add( new  SqlParameter( "@UserId" , userId));                      var userRolePermission = _unitOfWork.SQLQuery ( "Exec [SpName] @ModuleId, @UserId" , parameters.ToArray());                    return  userRolePermission.ToList();               }                catch  (Exception ex)               {                    throw ;               }           }