using BenchmarkDotNet.Attributes;
using Microsoft.EntityFrameworkCore;
using Dapper;
using System;
using System.Collections.Generic;
using Microsoft.Data.SqlClient;
using System.Linq;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Reports;
using BenchmarkDotNet.Columns;

public class Event
{
    public int Id { get; set; }
    public string Name { get; set; }
    public DateTime Date { get; set; }
    public string Venue { get; set; }
}

public class SportsContext : DbContext
{
    public DbSet<Event> Events { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder
            .UseSqlServer(@"Server=localhost;Database=TestDB;Trusted_Connection=True;TrustServerCertificate=true");
    }
}

[MemoryDiagnoser]
[Config(typeof(Config))]
[HideColumns(Column.AllocRatio, Column.RatioSD, Column.Median, Column.Gen0, Column.Gen1)]
public class EFDapperBenchmark
{
    private const string ConnectionString = 
        @"Server=localhost;Database=TestDB;Trusted_Connection=True;TrustServerCertificate=true";

    private SportsContext _context;
    private SqlConnection _connection;

    [GlobalSetup]
    public void Setup()
    {
        _context = new SportsContext();
        _connection = new SqlConnection(ConnectionString);

        _context.Database.EnsureDeleted();
        _context.Database.EnsureCreated();

        // Seed data
        var events = Enumerable.Range(1, 1000).Select(i => new Event
        {
            Name = $"Event {i}",
            Date = DateTime.Now.AddDays(i),
            Venue = $"Venue {i}"
        }).ToList();

        _context.Events.AddRange(events);
        _context.SaveChanges();
    }

    [Benchmark]
    public List<Event> EFWithContextCost()
    {
        using var context = new SportsContext();
        return context.Events.AsNoTracking().ToList();
    }

    [Benchmark]
    public List<Event> EFNoContextCost()
    {
        return _context.Events.AsNoTracking().ToList();
    }


    [Benchmark]
    public List<Event> DapperWithConnectionCost()
    {
        using var connection = new SqlConnection(ConnectionString);
        return connection.Query<Event>("SELECT * FROM Events").ToList();
    }

    [Benchmark(Baseline = true)]
    public List<Event> DapperNoConnectionCost()
    {
        return _connection.Query<Event>("SELECT * FROM Events").ToList();
    }

    private class Config : ManualConfig
    {
        public Config()
        {
            SummaryStyle =
                SummaryStyle.Default
                .WithRatioStyle(RatioStyle.Percentage)
                .WithTimeUnit(Perfolizer.Horology.TimeUnit.Millisecond);
        }
    }
}

// .NET 8 Lowered C# Code unavailable due to errors:
error CS0234: The type or namespace name 'EntityFrameworkCore' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)
error CS0246: The type or namespace name 'Dapper' could not be found (are you missing a using directive or an assembly reference?)
error CS0234: The type or namespace name 'Data' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)
error CS0246: The type or namespace name 'DbContext' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'DbSet<>' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'DbContextOptionsBuilder' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)
error CS1061: 'SportsContext' does not contain a definition for 'Database' and no accessible extension method 'Database' accepting a first argument of type 'SportsContext' could be found (are you missing a using directive or an assembly reference?)
error CS1061: 'SportsContext' does not contain a definition for 'SaveChanges' and no accessible extension method 'SaveChanges' accepting a first argument of type 'SportsContext' could be found (are you missing a using directive or an assembly reference?)
error CS1674: 'SportsContext': type used in a using statement must be implicitly convertible to 'System.IDisposable'.

// .NET 8 IL Code unavailable due to errors:
error CS0234: The type or namespace name 'EntityFrameworkCore' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)
error CS0246: The type or namespace name 'Dapper' could not be found (are you missing a using directive or an assembly reference?)
error CS0234: The type or namespace name 'Data' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?)
error CS0246: The type or namespace name 'DbContext' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'DbSet<>' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'DbContextOptionsBuilder' could not be found (are you missing a using directive or an assembly reference?)
error CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)
error CS1061: 'SportsContext' does not contain a definition for 'Database' and no accessible extension method 'Database' accepting a first argument of type 'SportsContext' could be found (are you missing a using directive or an assembly reference?)
error CS1061: 'SportsContext' does not contain a definition for 'SaveChanges' and no accessible extension method 'SaveChanges' accepting a first argument of type 'SportsContext' could be found (are you missing a using directive or an assembly reference?)
error CS1674: 'SportsContext': type used in a using statement must be implicitly convertible to 'System.IDisposable'.