How to retrieve data from a SP in EF4

Question

I'm using EF4 to call a stored procedure which returns the results of a SELECT statement at the end of the SP. However, some of the column names in the returned results contain underscore chars, or spaces, which prevents me from mapping them to a complex type. How can I retrieve the results of the SP from EF?

Answer 1

Well, I've resorted to using a DbCommand and an ExecuteReader call, as shown in this post: http://stackoverflow.com/questions/690299/how-to-easily-convert-a-dbdatareader-object-into-something-useful

It gets me what I need, though its a lot of work.