title: Join Collection of Objects with LINQ to SQL
body: <p>Is this even possible? It seems like I should be able to.</p>
  
  <p>This is my issue. I need to run a web service method from a 3rd party to get a collection of available items where I need the ID and a Status property. Then I have method using LINQ to SQL that retrieves the items that are current.</p>
  
  <p>What I need to do is retrieve the items that are current and available. I can connect them through ID BUT I also need the Status returned from the web service method. </p>
  
  <p>Ideally, my final results will be the same results as from the LINQ to SQL method plus the Status property from the web service method.</p>
  
  <p>Any assistance would be appreciated. Thanks!</p>
  
  <p>Below is what I want to do. Have a method that takes in the list of objects from the web service and join with the existing query.</p>
  
  <pre><code>public List&lt;Items&gt; GetItems(List&lt;AvailableItems&gt; availList)
  {
              var result = (from c in dataContext.items
                            where c.status == "current"
                           select c;
  
               return result;
  }
  </code></pre>