map stored procedure to entity returning temproray table data

Question

I have a stored procedure that returns the temporary table data. because i have used dynamic queries. When i tried to map stored procedure using complex types it returns no columns

how to handle temporary table columns name in complex types?

score 3 · Accepted Answer · edited May 23 '17 at 10:34

3

It is not supported by default because EF always executes SET FMTONLY ON before executing your stored procedure. This option will turn off logic execution - it will only ask for metadata but if logic execution is turned off no temporary table is created and no column's metadata exists.

There are some workarounds.

edited May 23 '17 at 10:34

Community

1
1

answered Oct 18 '11 at 12:52

Ladislav Mrnka

360,892
59
660
670

map stored procedure to entity returning temproray table data

1 Answers1