Is it possible to return multiple result sets using ExecuteQuery in Linq to Sql?

Question

I know that you can return multiple results from a stored procedure and through the method generated by the designer.

However, I'm trying to do the same using ExecuteQuery but it doesn't seem like it's possible. Has anyone tried or know whether this is possible?

Basically I'm trying to run an ad-hoc stored procedure. By ad-hoc, I mean a stored procedure that wasn't available during design-time.

Answer 1

It appears that ExecuteQuery, since it always returns IENumerable, is always going to only process the first resultset. You will want to work with IMultipleResults instead. This may be a starting point: http://www.a2zmenu.com/Blogs/LINQ/multiple-result-sets-using-IMultipleResults-in-linq.aspx