Program.cs

// Install-Package Microsoft.EntityFrameworkCore
// Install-Package Microsoft.EntityFrameworkCore.Sqlite
// Install-Package Microsoft.EntityFrameworkCore.Tools
// Install-Package Microsoft.SemanticKernel.Connectors.Google -Version 1.67.1-alpha
// Install-Package Microsoft.SemanticKernel.Process.Core -Version 1.67.1-alpha
// Install-Package Microsoft.SemanticKernel.Process.LocalRuntime -Version 1.67.1-alpha
// Install-Package Microsoft.SemanticKernel.Connectors.SqliteVec -prerelease

// https://aistudio.google.com/

using Microsoft.AspNetCore.Authentication.Cookies;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.AI;
using Microsoft.SemanticKernel;
using MyProject.Models;
using MyProject.Processes;

var builder = WebApplication.CreateBuilder(args);

//-- Razor Pages
builder.Services.AddRazorPages();

// HttpContext accessor
builder.Services.AddHttpContextAccessor();

//------ Database service
builder.Services.AddDbContext<ProjectContext>();

//---- Register Auth Services
builder.Services
    .AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme)
    .AddCookie(options =>
    {
        options.LoginPath = "/Login";
        options.AccessDeniedPath = "/Login";
        options.ExpireTimeSpan = TimeSpan.FromDays(20);
        options.SlidingExpiration = true;
    }
   );

builder.Services.AddAuthorization();

//--- Register AI Services
// get key here: https://hoven.in/cs-lang/gemini-keys-for-sk.html
builder.Services.AddGoogleAIGeminiChatCompletion(
modelId: "gemini-2.5-flash",
apiKey: ___your__key
);

builder.Services.AddTransient((sp) => new Kernel(sp));

builder.Services.AddTransient((sp) => ProcessBuilderFactory.CreateLoginProcess());

var app = builder.Build();

app.UseAuthentication();

app.UseAuthorization();

app.MapRazorPages();

using (var scope = app.Services.CreateScope())
{
    // create database directory, if doesn't exist
    Directory.CreateDirectory(ProjectContext.DBASE_DIRECTORY);

    ProjectContext? ctx = scope.ServiceProvider.GetService<ProjectContext>();

    if (true == ctx?.Database.GetPendingMigrations().Any())
    {
        ctx.Database.Migrate();
        app.Logger.LogInformation("Identity migrations applied!");
    }

    if (true != ctx?.Database.CanConnect())
    {
        app.Logger.LogError(
                  @"have you applied migration?
Open package manager console and run these commands first:
Add-Migration Initial_Create -context ProjectContext");

        return;
    }

}

app.Run();