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

133

1 Compact Framework

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

Answers (1)

Forum Statistics

Please welcome our newest member Jenica .
2,381,650 users have contributed to 122,515 threads and 389,026
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'what is generative Engine optimization'.

Upcoming Events

View all

How Gen AI is Reshaping Content, Code, and Commerce

Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

Live

How Gen AI is Reshaping Content, Code, and Commerce