将Linq to SQL与泛型列表中对象的属性混合在一起

只需将本地列表投影到需要筛选的特定项目列表中:

var listOfIds = listOfObjects.Select(o => o.Id);
var query = 
    from a in DatabaseTable
    where listOfIds.Contains(a.Id)
    select a;

var listOfIds = listOfObjects.Select(x => x.Id).ToList();

var query = from a in DatabaseTable
            where listOfIds.Contains(a.Id)
            select a;