Can Entity Framework deal with multiple result sets (each from joined tables) from a stored procedure?

Question

In Linq to SQL, I can't find an easy way to deal with multiple result sets returned by a stored procedure where each result set is from table joins. Each result set does not map directly to a table. (can't change this behavior). For now, it seems using a DataSet is a lot simpler.

Can the current Entity Framework or the upcoming one, 4.0, deal with these kind of scenarios straight from the designer? Or even from code done easily?

Answer 1

This isn't supported out of the box in the new EF.

But there is a project on CodeGallery called EF Extensions that shows how to do this easily enough.

Hope this helps

Alex