How Stored Procedure call in Web API using Context DB

If u already added store procedure from model browser then you just need to call store procesdure name like we noramlly call table.

syntax: ContextDB.StoreProcedure

example : contextDb.sp_mySP().ToList();

Please find below link to use so in entity framework. http://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx

Hi Sandeep

No matter with number of joins, Because here we need to know how to use the Stored Procedure.

Follow the below link which will help you for utilizing the stored procedure in entity framework :

http://www.entityframeworktutorial.net/entityframework4.3/execute-stored-procedure-using-dbcontext.aspx

If it helps, Accept the answer.

Thank you.