EFCore+Linq高效批量删除包含图片及大文本的数据两种性能对比

public bool DeletePackageByKeys(List<string> listKeys)
{
    var q = _Database.GetQueryable<sys_UpgraderPackageTable>().Where(w => listKeys.Contains(w.isid));
    _Database.RemoveRange(q);
    var count = _Database.SaveChanges();
    return count > 0;
}

/// <summary>
/// EFCore高效批量删除包含图片及大文本的数据
/// </summary>
/// <param name="listKeys">实体类主键：isid</param>
/// <returns></returns>
public bool DeletePackageByKeys(List<string> listKeys)
{
    //isid是主键，构建一个仅包含key属性的实体类列表
    var list = listKeys.Select(key => new sys_UpgraderPackageTable { isid = key }).ToList();
    _Database.RemoveRange(list);
    var count = _Database.SaveChanges();
    return count > 0;
}

    public virtual void RemoveRange(IEnumerable<object> entities)
    {
        Microsoft.EntityFrameworkCore.Utilities.Check.NotNull(entities, "entities");
        CheckDisposed();
        IStateManager stateManager = DbContextDependencies.StateManager;
        foreach (object entity in entities)
        {
            InternalEntityEntry orCreateEntry = stateManager.GetOrCreateEntry(entity);
            EntityState entityState = orCreateEntry.EntityState;
            if (entityState == EntityState.Detached)
            {
                SetEntityState(orCreateEntry, EntityState.Unchanged);
            }

            orCreateEntry.SetEntityState((entityState != EntityState.Added) ? EntityState.Deleted : EntityState.Detached);
        }
    }