title: How to retrieve multiple rows from a stored procedure with Linq to SQL?
body: <p>I've recently started to work with Linq to SQL and wondered how to get multiple rows as a result of executing a stored procedure,here's a simple sp i want to work with:</p>
  
  <pre><code>CREATE PROCEDURE gsp_ftsmultiple
    @SearchKey varchar(100)
  AS
  
  BEGIN
  
    SET NOCOUNT ON;
  
    SELECT Label, theContent 
      FROM FtsTest 
     WHERE FREETEXT( theContent, @SearchKey )
  
  END
  </code></pre>
  
  <p>Executing this sp from management studio is fine,but the corresponding method in the generated context class returns a int value, and I don't know how to get the actual rows, tried using the OUT parameters, but they can return only one result.</p>