linq any()方法实现sql in()方法的效果

  public IQueryable<Vsec009ComSecComp> QueryList(Sec009ComSecCompQueryCondition condition)
            {
                 var query = _currentUnitOfWork.Vsec009ComSecComps.AsQueryable();

                 //构建查询条件
                 if (condition.Ids != null && !string.IsNullOrEmpty(condition.Ids[0]))
                 {
                     query = query.Where(t => condition.Ids.Any(id => id.Equals(t.Id)));
                 }
            }
原文地址:https://www.cnblogs.com/huangmeimujin/p/5115560.html