How on earch can I access the second, third, fourth result sets?
Controller:
var dataContext = new DealDataContext();
XElement xmlString = new XElement("asd");
var deals = dataContext.spSearchDeals(xmlString);
return View(deals);
View:
<% foreach (spSearchDealsResult d in (IEnumerable)ViewData.Model)
{ %>
<li> <%: d.TagLabel %> </li>
<% } %>
This as simple as it gets... but I can only access the very first resulset. HELP!
Yup, a known limitation/pet hate with Linq To Sql. When you drop stored procs on the canvas, L2SQL generates a method with return type ISingleResult<T>.
The workaround is to use Entity Framework...
Just kidding, here is the L2SQL workaround.
Basically you change the return type to IMultipleResult<T>. (who knew)
On a side note - why are you iterating through items in the ViewData? You are returning the model in the View, you should bind to that model directly.
E.g
Inherits="System.Web.Mvc.ViewPage<IEnumerable<SearchDeal>>"
and then:
<% foreach (var deal in Model.SearchDeals) %>
spSearchDeals on your L2SQL designer, L2SQL will generate a partial class for you called spSearchDealsResult (look for it in the .designer.cs file). All you need to do is c+p that method, and change the return type to IMultipleResult.