摘要:LINQ實現SQL IN
var asd = ResultIdsAndSymbols.ToLookup(x => x.Symbol, y => y.ResultID);
foreach (var qwe in asd)
{
List<int> list = qwe.ToList();
var Numbers = (from t in Session.Query<TableName>()
where list.Contains(t.ResultID)
select t.Number).ToList();
}
or
List<int> list = new List<int> { Convert.ToInt32(contact_id) , -1 };
data = data.Where(p => list.Contains(Convert.ToInt32(p.VendorContactId)));
TonyHuang