using System;

using Pomelo.EntityFrameworkCore.MySql;

using Microsoft.EntityFrameworkCore;

using System.Linq;

public class Program

{

    public static void Main()

    {

        var dbContext = new MyDb();

        var filterQuery = dbContext.Users.Where(u => u.Name.Contains("John"));

        var data = filterQuery

            .GroupBy(x => 1)

            .Select(g => new {

                Count = g.Count(),

                Data = g.Select(x => x)

            });                     

        Console.WriteLine(data.ToQueryString());

    }

}

​

public class MyDb : DbContext

{

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

    {

        var serverVersion = new MySqlServerVersion(new Version(8, 0, 36));

        optionsBuilder.UseMySql("server=localhost;database=library;user=user;password=password", serverVersion);

    }

    public DbSet<User> Users {get;set;} = null!;

}

​

public class User

{

    public int Id {get;set;}

    public string Name {get;set;}

}