using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Columns;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using Microsoft.EntityFrameworkCore;
using BenchmarkDotNet.Reports;
using System.Threading.Tasks;

[Config(typeof(Config))]
[MemoryDiagnoser]
[HideColumns(Column.AllocRatio, Column.RatioSD, Column.Median, Column.Gen0, Column.Gen1, Column.NuGetReferences)]
public class EF7Perf
{
    private class Config : ManualConfig
    {
        public Config()
        {
            SummaryStyle =
                SummaryStyle.Default
                .WithRatioStyle(RatioStyle.Percentage)
                .WithTimeUnit(Perfolizer.Horology.TimeUnit.Millisecond);

            var baseJob = Job.Default;

            AddJob(baseJob.WithNuGet("Microsoft.EntityFrameworkCore.SqlServer", "8.0.4")
                .WithId("EF 8.0.4"));
            AddJob(baseJob.WithNuGet("Microsoft.EntityFrameworkCore.SqlServer", "7.0.18")
                .WithId("EF 7.0.18"));
            AddJob(baseJob.WithNuGet("Microsoft.EntityFrameworkCore.SqlServer", "6.0.29")
                .WithId("EF 6.0.29")
                .WithBaseline(true));
        }
    }

    [Params(100)]
    public int NumBlogs { get; set; }

    [GlobalSetup]
    public void GlobalSetup()
    {
        using var context = new BloggingContext();
        context.Database.EnsureDeleted();
        context.Database.EnsureCreated();
    }

    [Benchmark]
    public async Task InsertRows()
    {
        var db = new BloggingContext();

        for (var i = 0; i < NumBlogs; i++)
        {
            var blog = new Blog { Name = "Foo" + i, Url = "Bar" + i };
            db.Blogs.Add(blog);
        }

        await db.SaveChangesAsync();
    }

    public class BloggingContext : DbContext
    {
        public DbSet<Blog> Blogs { get; set; }

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

    public class Blog
    {
        public int BlogId { get; set; }
        public string Name { get; set; }
        public string Url { get; set; }
        public int Rating { get; set; }
    }
}

// .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 '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 CS1674: 'EF7Perf.BloggingContext': type used in a using statement must be implicitly convertible to 'System.IDisposable'.
error CS1061: 'EF7Perf.BloggingContext' does not contain a definition for 'Database' and no accessible extension method 'Database' accepting a first argument of type 'EF7Perf.BloggingContext' could be found (are you missing a using directive or an assembly reference?)
error CS1061: 'EF7Perf.BloggingContext' does not contain a definition for 'SaveChangesAsync' and no accessible extension method 'SaveChangesAsync' accepting a first argument of type 'EF7Perf.BloggingContext' could be found (are you missing a using directive or an assembly reference?)

// .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 '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 CS1674: 'EF7Perf.BloggingContext': type used in a using statement must be implicitly convertible to 'System.IDisposable'.
error CS1061: 'EF7Perf.BloggingContext' does not contain a definition for 'Database' and no accessible extension method 'Database' accepting a first argument of type 'EF7Perf.BloggingContext' could be found (are you missing a using directive or an assembly reference?)
error CS1061: 'EF7Perf.BloggingContext' does not contain a definition for 'SaveChangesAsync' and no accessible extension method 'SaveChangesAsync' accepting a first argument of type 'EF7Perf.BloggingContext' could be found (are you missing a using directive or an assembly reference?)