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 · 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 ; } }

How to use stored procudures with EF.

Answers (2)