EFCore8TrackingBenchmark.cs

using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Columns;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Reports;
using EFQueryOptimization.Context;
using EFQueryOptimization.Entities;
using Microsoft.EntityFrameworkCore;

namespace EFQueryOptimization;

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

    [Benchmark(Baseline = true)]
    public List<Role> Tracking()
    {
        var context = new ApplicationDbContext();

        return context.Roles
            .Include(x => x.UserRoles)
            .ThenInclude(x => x.User)
            .Take(10)
            .ToList();
    }

    [Benchmark]
    public List<Role> NoTracking()
    {
        var context = new ApplicationDbContext();

        return context.Roles
            .Include(x => x.UserRoles)
            .ThenInclude(x => x.User)
            .AsNoTracking()
            .Take(10)
            .ToList();
    }

    [Benchmark]
    public List<Role> NoTrackingWithIdentityResolution()
    {
        var context = new ApplicationDbContext();

        return context.Roles
            .Include(x => x.UserRoles)
            .ThenInclude(x => x.User)
            .AsNoTrackingWithIdentityResolution()
            .Take(10)
            .ToList();
    }

}