CodeQuery 1.0.0-preview.3

CodeQuery

Write type-safe, robust SQL in C#. The bridge between SQL and C#.

CodeQuery is a .NET Standard 2.1 library for expressing queries, schema, migrations and routines through the C# type system. It stays as close to SQL as possible while letting the compiler check every column and table reference — so a rename refactors your queries instead of breaking them at runtime.

Install

Add the core package and the driver for your database:

dotnet add package CodeQuery
dotnet add package CodeQuery.Sqlite   # or CodeQuery.Postgres / CodeQuery.MySql / CodeQuery.Mssql

Define a schema

Declare your database as a class — one member per database object, each member constructing itself — and let CodeQuery inspect the entity types:

public class AppDb : IDbSchema
{
    // tables — the shape comes from the entity type, the rest travels with the member
    public DbTable<Author> Authors => new();
    public DbTable<Book>   Books   => new(b => b.Column(x => x.Price).Check(p => p >= 0));

    // views, stored procedures and functions are the objects you hand back, nothing inferred
    public DbView<ExpensiveBook> Expensive => new ExpensiveBooksView();
}

var db = DatabaseInitializer.Build<AppDb>(configuration);

Query

var books = db.From<Book>()
    .InnerJoin(Author.On(), b => b.AuthorId)
    .Select((b, a) => new { b.Title, a.Name })
    .Fetch();

The property references are compiler-checked and refactor-safe — there are no SQL strings in the query.

Strong typing

Strong typing is the core principle. Schema constraints, defaults and partition bounds are expressed as typed CLR values and expression trees, never as SQL fragments:

// The check is an expression; the compiler validates the column and the comparison.
productTable.HasCheck("CK_Products_Price", r => r.Price >= 0);

// The partition key is an expression; the range bounds follow the key's type.
config.PartitionBy(s => s.LogDate)
      .AsRange()
      .Add("y2024", new DateTime(2024, 1, 1), new DateTime(2025, 1, 1));

Documentation

Full guides — queries, joins, aggregates, CTEs, window functions, migrations, views, stored procedures, full-text search and dialect support — live in the Web/ documentation site.

License

MIT