I've recently been introduced to LINQ to SQL and am trying to figure out how to use it with a stored procedure that generates multiple result sets. By default, only the first result set is returned. How do I get all seven of the result sets? I've Googled a bit, but I can't make any of the examples work. Can someone provide me with a relatively simple/straighforward example of how to do this in VS 2010?
On a related note... Most of the examples seem to indicate that you have to add all of the tables used by the SP to the DBML file. Is this actually necessary?
On a related note... Most of the examples seem to indicate that you have to add all of the tables used by the SP to the DBML file. Is this actually necessary?
