i have create a Stored Procedure(Name: Insert_Data) to insert data 2 or more table. Now i want to use Store procedure using entity framework in Repository Pattern. How can i use it?

Hi Chandra,

There are a number of resources available for tackling this issue. Here’s a couple references for you to take a look at regarding using SP’s with Entity Framework

http://visualstudiomagazine.com/articles/2014/04/01/calling-stored-procedures-from-entity-framework.aspx 

http://stackoverflow.com/questions/20970416/using-stored-procedure-in-entity-framework 

http://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx 

http://www.binaryintellect.net/articles/30738a7c-5176-4333-aa83-98eab8548da5.aspx 

Thanks

Hello Sir

I want to use in Repository Pattern.

Regards
Chandra

This might be a step closer to what you’re looking for, then: http://www.codeproject.com/Articles/805369/Using-an-Entity-Framework-Designer-for-Stored-Proc 

And perhaps even better: http://forums.asp.net/t/1668454.aspx?EF4+Repository+Pattern+with+Stored+Procedure 

Hi Chandra,

For this issue, please refer to this related thread:

# How can I use a stored procedure + repository + unit of work patterns in Entity Framework?

http://stackoverflow.com/questions/17912388/how-can-i-use-a-stored-procedure-repository-unit-of-work-patterns-in-entity

Best Regards

Starain