LINQ實現SQL IN

  • 4413
  • 0
  • 2017-07-27

摘要: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