This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

How to retrieve Dynamic Resultset from Stored Procedure using EF

Question
0

Sign in to vote
Hi,

I am using EF4. I have to show dynamic columns in the query using Stored Procedure. The result-set is unknown. If I am trying to use EF function Import, we have to provide entity. But in the dynamic result-set , how can I provide predefined entity. kindly figure it out.

Thanks in advance.

Regards,

UV
- Edited by Udhayasankari Velumani Friday, June 8, 2012 8:59 AM
Friday, June 8, 2012 8:57 AM

Answers

0

Sign in to vote
<http://blogs.msdn.com/b/alexj/archive/2009/11/07/tip-41-how-to-execute-t-sql-directly-against-the-database.aspx>

You can use EF connection, execute sproc with SQL Command object, use

dataread, datareade.NextResult, make your own custom objects not on the

model and return them in a List<T>

You can do these too.

<http://blogs.msdn.com/b/adonet/archive/2011/06/30/walkthrough-multiple-result-sets-from-stored-procedure.aspx>

<http://blogs.infosupport.com/ado-net-entity-framework-advanced-scenarios-working-with-stored-procedures-that-return-multiple-resultsets/>

Myself, I would just use the backdoor. :)
- Marked as answer by Allen_MSDN Thursday, June 14, 2012 2:04 AM
Friday, June 8, 2012 3:19 PM