// @nuget: Zomp.EFCore.WindowFunctions.SqlServer -Version 8.0.18-beta

​

using Microsoft.EntityFrameworkCore;

using System;

using System.Collections.Immutable;

using System.Linq;

using Zomp.EFCore.WindowFunctions;

using Zomp.EFCore.WindowFunctions.SqlServer;

using var context = new TestDbContext();

​

await context.Database.EnsureCreatedAsync();

​

var query = context.TestRows

        .Select(r => EF.Functions.Count(EF.Functions.Over()));

​

Console.WriteLine("SQL\n===");

Console.WriteLine(query.ToQueryString());

​

Console.WriteLine("\n\nResults\n=======");

(await query.ToListAsync()).ForEach(z => Console.WriteLine(z));

​

public record TestRow(int Id, int? Col1, Guid SomeGuid, DateTime Date, byte[] IdBytes)

{

    public static ImmutableArray<TestRow> CreateTestRows() =>

    ImmutableArray.CreateRange(new TestRow[]

    {

            new(2, null, new("ab988b94-a7d3-413d-92a0-8a03c47dd0f4"), new(2022, 01, 01), new byte[] { 0, 2 }),

            new(3, 10, new("41b1d4c5-e629-4a23-9514-47857e6c5ad2"), new(2022, 01, 02), new byte[] { 0, 3 }),

            new(5, -1, new("5a425c36-3a87-4d55-80a0-0f449897daa4"), new(2022, 01, 03), new byte[] { 0, 5 }),

            new(7, null, new("a3517ee2-e14c-4c63-8a12-353eee1c01f9"), new(2022, 01, 04), new byte[] { 0, 7 }),

            new(11, null, new("2ce77fd7-937d-4041-9b62-47b7d7a7ef09"), new(2022, 01, 05), new byte[] { 0, 11 }),

            new(13, -12, new("2b71c0d2-11ac-4f6c-af5e-5c470202e222"), new(2022, 01, 06), new byte[] { 0, 13 }),

            new(17, null, new("5c3330cd-a93b-4d6f-b31c-efb735315993"), new(2022, 01, 07), new byte[] { 0, 17 }),

            new(19, null, new("e1c5f8f1-18ca-423d-a35e-b9c54f6897d4"), new(2022, 01, 08), new byte[] { 0, 19 }),

            new(23, 1759, new("d288c0f2-b2a2-4eef-98cc-1f4726f1277c"), new(2022, 01, 09), new byte[] { 0, 23 }),

    });

}

​

public class TestDbContext : DbContext

{

    public DbSet<TestRow> TestRows { get; set; } = null!;

​

    protected override void OnModelCreating(ModelBuilder modelBuilder)

    {

        modelBuilder.Entity<TestRow>().Property(x => x.Id).ValueGeneratedNever();

        modelBuilder.Entity<TestRow>().HasData(TestRow.CreateTestRows());

    }

​

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

    {

        optionsBuilder

            //.LogTo(Console.WriteLine).EnableSensitiveDataLogging()

            .UseSqlServer(FiddleHelper.GetConnectionStringSqlServer(), o => o.UseWindowFunctions());

    }

}

​