您的位置: 首页 > IT文章 > Hitting the 2100 parameter limit (SQL Server) when using Contains() Hitting the 2100 parameter limit (SQL Server) when using Contains() 分类: IT文章 • 2024-09-04 08:04:55 1down vote My solution (Guides -> List of Guid): List<tstTest> tsts = new List<tstTest>(); for(int i = 0; i < Math.Ceiling((double)Guides.Count / 2000); i++) { tsts.AddRange(dc.tstTests.Where(x => Guides.Skip(i * 2000).Take(2000).Contains(x.tstGuid))); } this.DataContext = tsts;