EFCoreAnyvsCountBenchmark.cs

using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Columns;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Reports;
using DatabaseNight.Context;
using System.Linq;

namespace DatabaseNight;

[Config(typeof(Config))]
[HideColumns(Column.RatioSD, Column.AllocRatio)]
[MemoryDiagnoser(false)]
public class EFTuningService
{
    private class Config : ManualConfig
    {
        public Config()
        {
            SummaryStyle = SummaryStyle.Default.WithRatioStyle(RatioStyle.Trend);
        }
    }

    [Benchmark(Baseline = true)]
    public bool Count()
    {
        var context = new ApplicationContext();

        return context.Employees
             .Count(x => x.DepartmentId == 7) > 0;
    }

    [Benchmark]
    public bool Any()
    {
        var context = new ApplicationContext();

        return context.Employees
             .Any(x => x.DepartmentId == 7);
    }
}