Join Collection of Objects with LINQ to SQL

Question

Is this even possible? It seems like I should be able to.

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.

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.

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.

Any assistance would be appreciated. Thanks!

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.

public List<Items> GetItems(List<AvailableItems> availList)
{
            var result = (from c in dataContext.items
                          where c.status == "current"
                         select c;

             return result;
}

Answer 1

Edit:

If you actually need to split the two, this should work:

public var GetItems(List<AvailableItems> availList)
{
  var items = (from c in dataContext.items
               where c.status == "current").AsEnumerable();

  return from c in items
         from i in availList
         where c.Id = i.Id
         select new { c, i };
}

Answer 2

public var GetItems(List<AvailableItems> availList)
{
    var result = (from c in dataContext.items.ToList()
                  join a in availList on a.id equals c.id
                  where c.status == "current"
                  select new {c.prop1, a.status};             

    return result;
}