EF - Execute a sql query/stored procedure that has dynamically generated fields

Question

I'm using EF code first approach in my application. I need to execute a query which runs a report and returns the result set with dynamically generated fields. The fields in the result set can be different based on the condition. Is it possible to return a result set using code first approach like maybe in a DataSet, or is there any other way to achieve this?

Thanks.

CTP5 is dead. Use EF 4.1 instead.

Ladislav Mrnka
– Ladislav Mrnka

2011-06-14 19:48:08 +00:00
Commented Jun 14, 2011 at 19:48 — Ladislav Mrnka
– Ladislav Mrnka, Commented Jun 14, 2011 at 19:48

Ladislav Mrnka · Accepted Answer · 2011-06-14 19:47:39Z

2

(Untested) You can try to define data type which will have properties for all possible columns your query can return. It must be flat type with no nested objects and properties must have same names as columns in result set. Then you can use

var data = context.Database.SqlQuery<YourType>("Your SQL Query or SP call");

If you want DataSet with only returned columns you must use standard ADO.NET SqlDataAdapter or SqlConnection / SqlCommand (or version related to your database). EF doesn't like native queries which don't return fixed set of columns.

answered Jun 14, 2011 at 19:47

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MNIK Over a year ago

Thanks for the reply. There are just way too many columns to have them in a type. For now, I will probably go with the standard ADO.Net method.

Collectives™ on Stack Overflow

EF - Execute a sql query/stored procedure that has dynamically generated fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related