Hitting the 2100 parameter limit (SQL Server) when using Contains()

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;
上一篇:dump文件定位程序崩溃代码行


下一篇:otter源码分析-(1)debug node源码