Linq example

LinqExample.cs

public sealed class AppDbContext : DbContext
{
    public DbSet<Customer> Customers => Set<Customer>();
    public DbSet<Order> Orders => Set<Order>();

    protected override void OnConfiguring(DbContextOptionsBuilder options)
    {
        options.UseTurso("libsql://my-db.turso.io", new TursoOptions
        {
            AuthToken = "<token>"
        });
    }
}

public sealed class Customer
{
    public long Id { get; set; }
    public string Name { get; set; } = "";
    public string Email { get; set; } = "";
    public bool IsActive { get; set; }

    public List<Order> Orders { get; set; } = [];
}

public sealed class Order
{
    public long Id { get; set; }
    public long CustomerId { get; set; }
    public Customer Customer { get; set; } = null!;

    public decimal Total { get; set; }
    public DateTime CreatedAt { get; set; }
}

await using var db = new AppDbContext();

var activeCustomers = await db.Customers
    .Where(c => c.IsActive)
    .OrderBy(c => c.Name)
    .Take(50)
    .ToListAsync();