title: Linq To Sql returns type different from stored proc after upgrade from VS2K8 to VS2K10
body: <p>In Visual Studio 2K8, my app calls a stored proc using LinqToSql. The inferred return type was ISingleResult. I upgrade the project to 2k10 and now the inferred return type of the stored procedure is int. When I look at the .dbml, the return type is int for both versions of the project. I'm not sure why visual studio 2k10 does it one way and 2008 does it the other because the stored procedure does a 'select distinct'. I would think LinqToSql would return a type where I can iterate through the result.</p>
  
  <p>Here is the LinqToSql</p>
  
  <pre><code>var recordSet = context.GetNearbyLocations(Convert.ToChar(networkId), latitude, longitude, searchDistance);
  </code></pre>
  
  <p>How do I change the result to accept the multiple results the stored proc will return?</p>