Fetching Dynamic SQL result from Entity Framework

Question

I'm using EF 4, inside WCF. I've a SP (executes dynamic sql) on db side that can return n number of columns where n is not certain. So when I do function import and say return type none, it makes the return type as int. And I don't see any other option. I can return xml and do that way but I don't want to deal with xml. I just want its return type to be List<object>

Ladislav Mrnka · Accepted Answer · 2011-03-22 16:18:47Z

6

In such case you must fall back to ADO.NET and execute stored procedure by SqlCommand + SqlDataReader. EF is not able to handle result set which vary by number of returned columns. Executing SPs in EF is always strongly typed so you must be able to map your returned record to an entity, a complex type or a custom type (EF will materialize record to instance of the type). It is not possible when you don't have fixed number of returned columns and fixed names of columns.

answered Mar 22, 2011 at 16:18

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

Collectives™ on Stack Overflow

Fetching Dynamic SQL result from Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related