EF AddRange方法不适用于大数据

public void AddLargeData(IEnumerable<MyEntity> entities)
{
    const int batchSize = 1000;
    for (int i = 0; i < entities.Count(); i += batchSize)
    {
        var batch = entities.Skip(i).Take(batchSize);
        context.MyEntities.AddRange(batch);
        context.SaveChanges();
    }
}

public void BulkInsert(IEnumerable<MyEntity> entities)
{
    using (var connection = new SqlConnection(connectionString))
    {
        connection.Open();
        using (var bulkCopy = new SqlBulkCopy(connection))
        {
            bulkCopy.DestinationTableName = "MyEntities";
            var table = new DataTable();
            table.Columns.Add("Id", typeof(int));
            table.Columns.Add("Name", typeof(string));
            // 添加其他列...

            foreach (var entity in entities)
            {
                table.Rows.Add(entity.Id, entity.Name);
                // 添加其他属性...
            }

            bulkCopy.WriteToServer(table);
        }
    }
}

public async Task AddLargeDataAsync(IEnumerable<MyEntity> entities)
{
    const int batchSize = 1000;
    for (int i = 0; i < entities.Count(); i += batchSize)
    {
        var batch = entities.Skip(i).Take(batchSize);
        context.MyEntities.AddRange(batch);
        await context.SaveChangesAsync();
    }
}