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

entity-framework, linq-to-entities, linq-to-sql

Solution

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

Problem

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?

Original source