使用LINQ ef核心.net时，如果列表包含的元素超过1000个，则Where子句中的Contains()将在Oracle上失败

var batchSize = 1000;
var results = new List<YourEntityType>();

for (int i = 0; i < yourLargeList.Count; i += batchSize)
{
    var batch = yourLargeList.Skip(i).Take(batchSize).ToList();
    var batchResults = context.YourTable
                              .Where(item => batch.Contains(item.SomeProperty))
                              .ToList();
    results.AddRange(batchResults);
}

var results = context.YourTable
                      .Where(item => yourLargeList.Any(x => x == item.SomeProperty))
                      .ToList();

// 创建临时表
context.Database.ExecuteSqlRaw(@"
    CREATE GLOBAL TEMPORARY TABLE TempTable (
        SomeProperty NVARCHAR2(255)
    ) ON COMMIT DELETE ROWS
");

// 插入数据到临时表
foreach (var item in yourLargeList)
{
    context.Database.ExecuteSqlRaw(@"
        INSERT INTO TempTable (SomeProperty) VALUES (:value)
    ", new SqlParameter("value", item));
}

// 查询
var results = context.YourTable
                      .FromSqlRaw(@"
                          SELECT * FROM YourTable
                          JOIN TempTable ON YourTable.SomeProperty = TempTable.SomeProperty
                      ")
                      .ToList();

// 删除临时表
context.Database.ExecuteSqlRaw("DROP TABLE TempTable");