nextorm.mariadb 1.0.9

Nextorm — MariaDB provider

nextorm.mariadb adds MariaDB support to Nextorm — a zero-SQL object-relational mapper for .NET that turns typed C# queries into SQL and materializes rows without change tracking. It shares the MySQL data context and dialect, keeps MariaDB's own grammar differences, and ships the UseMariaDb builder extension over MySqlConnector.

Installation

All current nextorm releases are prereleases, so --prerelease is required:

dotnet add package nextorm --prerelease
dotnet add package nextorm.mariadb --prerelease

Package Manager Console: Install-Package nextorm -Prerelease and Install-Package nextorm.mariadb -Prerelease.

Usage

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using NextORM.Core;
using NextORM.MariaDb;

var builder = new DataContextBuilder()
    .UseMariaDb("Server=localhost;Database=app;User ID=app;Password=secret");
using var dataContext = builder.CreateDataContext();

await foreach (var row in dataContext.From<IOrder>()
                                     .Where(order => order.Total > 100)
                                     .Select(order => new { order.Id, order.Total })
                                     .ToAsyncEnumerable())
{
    Console.WriteLine($"{row.Id}: {row.Total}");
}

[SqlTable("orders")]
public interface IOrder
{
    [Key]
    [Column("id")]
    int Id { get; set; }

    [Column("total")]
    decimal Total { get; set; }
}

Values are bound as @name parameters and identifiers are backtick-quoted. UseMariaDb also accepts an open DbConnection.

Good to know

• MariaDB has no source-level row lock: FOR UPDATE OF / FOR SHARE OF are rejected with NotSupportedException, while whole-query FOR UPDATE works as usual.
• UPDATE … RETURNING is available only when the server version is explicitly configured as 13.0+; unset or older versions reject it instead of guessing.
• Paging uses limit/offset, and key upserts render ON DUPLICATE KEY UPDATE.

Documentation

• Connecting a provider: MariaDB
• Quickstart
• Query reuse: plan cache vs Prepare()
• Comparisons and benchmarks

Status

Beta: every release so far is a prerelease, the public API still changes between them, and backward compatibility is not preserved yet. Release notes are on GitHub Releases.

License

MIT