title: Split linq join query in two selected lists and use Tuple to return the two lists
body: <p>Have the following code: a entity linq query results in a select of two tables.
  All data is available in the query, but can't get the result to split into two lists.</p>
  
  <pre><code> public Tuple&lt;List&lt;sale&gt;, List&lt;product&gt;&gt;  SearchProduct(int productId = -1, string searchProduct = "")
      {
          //ToDo: searchProduct not working...gives nothing
          var companyId = DalSession.DalGetCurrentUser().Company_ID;
          using (var entity = new secondsoftEntities())
          {
              var query = (from s in entity.sales
                           join p in entity.products on s.Product_ID equals p.ProductID
                           where productId &gt; 0 ? s.Product_ID == productId : s.Company_ID == companyId
                           select new { s, p }).ToList();
              if (!string.IsNullOrEmpty(searchProduct))
                {
                  query = query.FindAll(x =&gt; x.p.Description.ToLower().Contains(searchProduct.ToLower()));
               } 
  
  
  
              // split s as List&lt;sale&gt; and p as List&lt;product&gt; to tuple output
  
  
              return Tuple.Create(new List&lt;sale&gt;(), new List&lt;product&gt;() );
          }
      }
  </code></pre>
  
  <p>In the query result I see s and p, but how the exact them as a list with there properties in it so I can return them in Tuple.</p>
  
  <p>Thanx Dinand</p>