Without using ExecuteStoreQuery function,How to Call Stored Procedure.

Hi , Once you created the procedure in database, then 1) open the .edmx file 2)right click > Update Model from entity, your procedure will be added in the entity, If not added remove the .edmx file and add it again (if u r re adding /edmx make sure u r keeping same entity name what u kept already) 3) Once you updated the model from database then , entity will create the yourspname_result.cs file.(to verify open the .edmx file > expand the .tt file then check whether ur procedure has been added, if not make sure your procedure is working fine in db level then re add it) Once all the above steps are done kindly use the below code. using (var dbContext = new YourEntity()) { var detail = dbContext.YourProcedureName(ParameterName).ToList (); }

Answer

How to Entity Framework to call stored procedure in c#

Ajay Antala

587

Without using ExecuteStoreQuery<T> function,How to Call Stored Procedure.

Answers (1)

Next Recommended Forum

how to show images in horizontal in asp.net listview

How to design Database& define Relationship between tables

Forum Statistics

Please welcome our newest member M.Ammaz .
3,083,793 users have contributed to 147,418 threads and 483,473
In the past 24 hours, we have 6 new threads, 13 new posts, and 34 new users.
In last week, the most popular thread is 'How to publish the Artifact to Local IIS ?'.

Upcoming Events

View all

Excel Automation with Power Automate : Automate Your Business Processes - Ep.3
Global Azure Bootcamp - Rasipuram
Software Architecture Conference - 2025