title: multiple resultsets in c# MVC
body: <p>I am using Asp.NET MVC as a basic  webservice for several searchengine type asp/ jquery sites. Database searching is straightforward:</p>
  
  <p>Model - Sql Server FullText Sproc returning XML</p>
  
  <p>View - N/a</p>
  
  <p>Controller - Authorise user/ Parse input return Content (Model.XML)</p>
  
  <p>The returned XML contains four resultsets - item list, category breakdown, related/ads items &amp; paging numbers. The item, category &amp; related lists all comprise several elements and attribs.</p>
  
  <p>I am now looking for the best method to display the same info in an MVC view - both full and partials for jquery use -  but am struggling to find the best solution. The only two I have come up with so far are to parse the XML using Linq ( should this be done in View or Controller?) or have a SProc returning resultsets and use NextResult method to fill multiple lists ( not that I 've worked out how to do that yet....) </p>
  
  <p>All suggestions appreciated, thanks!</p>