linq 如何做类似in的查询？

Question

            foreach(int cid in categoryIds)
            {
                IList<ProductCategoryMapping> listPcategoryMap = ProductStorage.List<ProductCategoryMapping>().Where<ProductCategoryMapping>(
                p=>{return p.CategoryId==cid;}   
                );
            }
如题，我这样筛选Categoryid能否有类似in的查询一次查出不用循环？

Answer 1

Where(p => categoryIds.Contains(p.CategoryId)).select(p => p);