Code First stored procedure call to return multiple results

Question

I am using Code First in a project. The project is half completed. I need to call a stored procedure to return multiple results (3 choices). My research tells me that it is not supported in Code First. What are my options? First change the project to use the model?

Answer 1

A novel from MSFT answered my question. He wrote about this: http://romiller.com/2012/08/15/code-first-stored-procedures-with-multiple-results/

I am sure many people have the same problem. Hope this helps.

Answer 2

Can you break sproc by 3? I think you will have a problem with returning multiple objects from the same query. Otherwise, will this work for you? stack overflow