using Projects;
var builder = DistributedApplication.CreateBuilder(args);
var sqlite = builder.AddSqlite("sqlite", "c:\\databases", "mydata.db")
    .WithSqliteWeb();
var webapi = builder.AddProject<WebApi>("webapi")
    .WithReference(sqlite)
    .WaitFor(sqlite);
builder.Build().Run();



using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);
builder.AddServiceDefaults();
builder.AddSqliteDbContext<AppDbContext>("sqlite", configureDbContextOptions: options =>
{
    if (!builder.Environment.IsDevelopment())
        return;

    options.UseSeeding((context, _) =>
    {
        context.Add(new Todo { Description = "Clean main room" });
        context.Add(new Todo { Description = "Wash dishes" });
        context.Add(new Todo { Description = "Turn all lamps" });

        context.SaveChanges();
    });

    options.UseAsyncSeeding(async (context, _, cantok) =>
    {
        context.Add(new Todo { Description = "Clean main room" });
        context.Add(new Todo { Description = "Wash dishes" });
        context.Add(new Todo { Description = "Turn all lamps" });

        await context.SaveChangesAsync(cantok);
    });
});

var app = builder.Build();

app.MapDefaultEndpoints();
if(app.Environment.IsDevelopment())
{
    using var scope = app.Services.CreateScope();
    var context = scope.ServiceProvider.GetRequiredService<AppDbContext>();
    context.Database.EnsureDeleted();
    context.Database.Migrate();
}
app.MapGet("", async (AppDbContext context, CancellationToken cantok) =>
{
    var todos = await context.Todos.ToListAsync(cantok);

    return Results.Ok(todos);
});

app.Run();



public sealed class AppDbContext(DbContextOptions<AppDbContext> options)
    : DbContext(options)
{
    public DbSet<Todo> Todos => Set<Todo>();
}
public sealed class Todo
{
    public int Id { get; set; }
    public required string Description { get; set; }
    public bool IsDone { get; set; }
}