Read & Write .mdb and .accdb Databases Anywhere.

using JetDatabaseWriter;
using JetDatabaseWriter.Linq;

await using var reader = await AccessReader.OpenAsync("Northwind.accdb");

var recentOrders = await reader.Query<Order>("Orders")
    .Include(o => o.Customer)
    .ThenInclude(c => c!.Region)
    .Where(o => o.Freight >= 50m)
    .OrderByDescending(o => o.OrderID)
    .Take(25)
    .ToListAsync();

using JetDatabaseWriter;
using JetDatabaseWriter.Enums;
using JetDatabaseWriter.Models;

await using var writer = await AccessWriter.CreateDatabaseAsync(
    "contacts.accdb", DatabaseFormat.AceAccdb);

await writer.CreateTableAsync("Contacts", new[]
{
    new ColumnDefinition("Id", typeof(int)) { IsPrimaryKey = true, IsAutoNumber = true },
    new ColumnDefinition("Email", typeof(string), maxLength: 120) { IsRequired = true },
    new ColumnDefinition("CreatedUtc", typeof(DateTime)) { DefaultValue = "=Now()" },
}, new[]
{
    new IndexDefinition("IX_Contacts_Email", "Email") { IsUnique = true },
});

await writer.InsertRowAsync("Contacts", new RowValues
{
    ["Email"] = "alice@example.com",
});

using JetDatabaseWriter;
using JetDatabaseWriter.Models;

await using var writer = await AccessWriter.OpenAsync("ledger.accdb");
await using var tx = await writer.BeginTransactionAsync();

await writer.UpdateRowsAsync(
    "Accounts",
    RowCriteria.Where("AccountId", 101),
    new RowValues { ["Balance"] = 950.00m });

await writer.InsertRowAsync("AuditLog", new RowValues
{
    ["AccountId"] = 101,
    ["Delta"] = -50.00m,
});

await tx.CommitAsync();

using JetDatabaseWriter;

// Open an encrypted database
await using var reader = await AccessReader.OpenAsync(
    "protected.accdb",
    new AccessReaderOptions("correct-horse-battery-staple"));

// Encrypt, decrypt, or rotate passwords in-place via atomic staging
await AccessDatabaseEncryption.ChangePasswordAsync(
    "protected.accdb",
    oldPassword: "correct-horse-battery-staple",
    newPassword: "new-strong-passphrase");

# Generate C# entity classes and relationship navigations from an existing file
dotnet run --project src/JetDatabaseWriter.Scaffold -- \
  --database Northwind.accdb \
  --output ./Models \
  --namespace MyApp.Data \
  --records \
  --nullable