How to get multiple result sets from stored procdures using EntityFramework

Question

1.00/5 (1 vote)

See more:

, +

Actually I have several stored procedures that returns multiple result sets using more than one select statements and I need to use Entity Framework to access those stored Procedures. Please guide me how would it possible.

Posted 9-Jan-14 0:05am

dushyant.developer

Add a Solution

Comments

Maciej Los 12-Mar-14 15:33pm

This is not well-formulated question! Please, be more specific and provide more details about your issue. Where are you stuck? What have you done till now?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-03-12T09:35:00

Solution 2

Please, read my comment to the question first.

Have a look here:
Stored Procedures with Multiple Result Sets[^]
How to: Execute a Parameterized Stored Procedure Using EntityCommand[^]

Posted 12-Mar-14 9:35am

Maciej Los

Suraj Sahoo | Coding Passion · Answer 2 · 2014-03-12T08:24:00

Solution 1

If you want to access the stored procedures then you have to use ADO.NET connections(trivial). You can better use LINQ else ADO.NET EntityModel
Happy Coding
Enjoy SD's

Posted 12-Mar-14 8:24am

Suraj Sahoo | Coding Passion

Comments

Maciej Los 12-Mar-14 15:38pm

Please, read the question carefully. OP don't know how to write code first (definition of class, model) to get multiple result sets from SP. This answer isn't helpful at all.