public class ApplicationDbContext : QueryzDbContext<ApplicationUser, ApplicationRole>
{
    public ApplicationDbContext(DbContextOptions<QueryzDbContext<ApplicationUser, ApplicationRole>> options)
        : base(options)
    {
    }
}

public class ApplicationDbContextFactory : IDbContextFactory
{
    // see Query.Demo project for example implementation
}

builder.Services.AddIdentity<ApplicationUser, ApplicationRole>(options =>
{
    options.SignIn.RequireConfirmedAccount = true;
})
.AddEntityFrameworkStores<ApplicationDbContext>()
.AddDefaultTokenProviders()
.AddDefaultUI();
builder.Services.AddDistributedMemoryCache(); // Required for session state
builder.Services.AddSession();
builder.Services
    .AddControllersWithViews()
    .AddNewtonsoftJson() // Currently only working with this. The model binding wouldn't work otherwise. It's on the TODO list to fix.
    .AddOData((options, serviceProvider) =>
    {
        options.Select().Expand().Filter().OrderBy().SetMaxTop(null).Count();
        var registrars = serviceProvider.GetRequiredService<IEnumerable<IODataRegistrar>>();
        foreach (var registrar in registrars)
        {
            registrar.Register(options);
        }
    })
    .AddQueryz<ApplicationUser, ApplicationRole>(builder.Configuration, connectionString)
    .AddRazorRuntimeCompilation();
// Override the default IDbContextFactory registered when calling AddQueryz()
builder.Services.AddSingleton<IDbContextFactory, ApplicationDbContextFactory>();
app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}")
    .WithStaticAssets(); // Important
app.UseStaticFiles(new StaticFileOptions
{
    FileProvider = new CompositeFileProvider(
        new PhysicalFileProvider(Path.Combine(builder.Environment.ContentRootPath, "wwwroot")),
        new EmbeddedFileProvider(
            typeof(IQueryzAssemblyMarker).Assembly,
            baseNamespace: "Queryz.wwwroot"))
});
app.UseQueryz();
// If you are commercial, then set your own commercial license here.. or else change the name passed into SetNonCommercialPersonal().
ExcelPackage.License.SetNonCommercialPersonal("Queryz");
app.Run();

public static class QueryzConstants
{
    public static class Roles
    {
        public const string Administrators = "Administrators";
        public const string ReportBuilderEditors = "Report Builder Editors";
        public const string ReportBuilderUsers = "Report Builder Users";
    }
}

public class ConvertTimeZoneFunction : ITransformFunction
{
    public string Name => "Convert Time Zone";
    public dynamic Transform(dynamic value, Report report)
    {
        if (value is not DateTime) return value;
        if (value == null) return value;
        if (report == null || string.IsNullOrEmpty(report.Group.TimeZoneId)) return value;
        var timeZone = TZConvert.GetTimeZoneInfo(report.Group.TimeZoneId);
        return TimeZoneInfo.ConvertTimeFromUtc(value, timeZone);
    }
}
services.AddSingleton<ITransformFunction, ConvertTimeZoneFunction>();