redb.MSSql.Pro 4.7.0

RedBase Pro

Data Platform for .NET — the Pro engine of RedBase: SQL built in C#, a query planner, parallel materialization.

RedBase Pro replaces the query engine of the open-source RedBase core. The API is the same: a project moves from Free to Pro by changing the packages and AddRedb to AddRedbPro.

Contents: Free and Pro · Packages · Quick Start · New in 4.4 · Supported Databases · Documentation · License

Free and Pro

Both editions take the same LINQ API: filters, nested fields, arrays and dictionaries, arithmetic, Sql.Function<T>(), aggregation, GroupBy, window functions, trees, lists, users and permissions. They differ in how a query runs.

Free:  LINQ → SQL module in the database → rows as JSON → Props
Pro:   LINQ → SQL built in C# → rows → Props, materialized in parallel

Packages

Package	NuGet	Description
redb.Core.Pro		Pro engine, change tracking, data migrations
redb.Postgres.Pro		PostgreSQL Pro provider
redb.MSSql.Pro		SQL Server Pro provider
redb.SQLite.Pro		SQLite Pro provider — pure C#, no native extension: Blazor WebAssembly & mobile

dotnet add package redb.Postgres.Pro   # or redb.MSSql.Pro, redb.SQLite.Pro

Each provider package brings redb.Core.Pro as a transitive dependency.

Quick Start

using redb.Core;
using redb.Core.Models.Configuration;
using redb.Core.Pro.Extensions;      // AddRedbPro
using redb.Postgres.Pro.Extensions;  // UsePostgres; or redb.MSSql.Pro.Extensions, redb.SQLite.Pro.Extensions

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddRedbPro(options => options
    .UsePostgres("Host=localhost;Database=mydb;Username=postgres;Password=pass")
    // .UseMsSql("Server=localhost;Database=mydb;User Id=sa;Password=pass;TrustServerCertificate=true")
    // .UseSqlite("Data Source=app.db")
    .Configure(c =>
    {
        c.PropsSaveStrategy = PropsSaveStrategy.ChangeTracking;
        c.EnablePropsCache = true;
    }));

var app = builder.Build();
var redb = app.Services.GetRequiredService<IRedbService>();
await redb.InitializeAsync();

var results = await redb.Query<EmployeeProps>()
    .Where(e => e.Salary > 75000m)
    .Take(100)
    .ToListAsync();

// Window functions — from E132_WindowRowNumber.cs
var ranked = await redb.Query<EmployeeProps>()
    .WithWindow(w => w
        .PartitionBy(x => x.Department)
        .OrderByDesc(x => x.Salary))
    .SelectAsync(x => new
    {
        Name = x.Props.FirstName,
        Department = x.Props.Department,
        Salary = x.Props.Salary,
        Rank = Win.RowNumber()
    });

New in 4.4

Pro query engine:

• A window with Take, Skip and OrderBy returns the page; the window is computed over the whole filtered set on the fields it needs, and the other selected fields are read only for the rows returned. The same holds over a tree (TreeQuery(...).Take(...).WithWindow(...)), and Win.Ntile(n) over a tree uses n.
• AnyAsync over a tree stops at the first matching node.
• DistinctBy over a tree is faster on SQL Server and SQLite; DistinctBy keeps the ordering of the query, and CountAsync after DistinctBy counts the keys.

Both editions (core):

• Schema work at start-up and scheme synchronization run under a schema lock, so nodes sharing one database start together (SchemaLockTimeout).
• IRedbService.SchemaProblems and CheckSchemaAsync() report problems of the schema that need a person, for a health check.
• The tree services read a subtree or a chain of ancestors in one statement; several tree filters in one query all apply.

The full list is in CHANGELOG.md; what to check when upgrading is in UPGRADING.md.

Free — no license key

All Pro features work out of the box — no license key required (starting from version 3.3.0). Install the Pro packages and use them, in development and in production alike. Pro is proprietary (closed-source) software, distributed free of charge.

Supported Databases

Target frameworks: .NET 8.0 (LTS), .NET 9.0, .NET 10.0.

Documentation

License

RedBase Pro is proprietary software (closed-source), distributed free of charge — no license key required starting from version 3.3.0. The license terms (LICENSE-PRO.txt) ship in every Pro package.