Blog
Tutorials, guides, and best practices for building with CSharpDB.
Inside CSharpDB v3.8.0: Native Table Archives and External Tables
Export full tables to native .csdbtable archives, register those files as read-only external tables, query them with normal SELECTs and joins, and manage the workflow through Admin Import / Export.
Build Access-Style C# Form Modules
Build a real order-escalation workflow with database-owned C# form modules: generate handlers, export to files, edit in normal C# tools, import, build, trust, and run from Admin Forms.
ASP.NET Core Authentication and Authorization with CSharpDB
Use CSharpDB as the identity store for ASP.NET Core: EF Core provider with Identity, cookie and JWT bearer schemes, role and policy authorization, and Data Protection key persistence — all in a single .db file.
Inside CSharpDB v3.6.0: Admin Collections, Custom Form Controls & Trusted C#
A walkthrough of the v3.6.0 Admin update: a first-class Collections UI, extensible Admin Forms controls, Access-style macro actions, a runnable trusted C# host sample, and what's next for database-owned C# code modules.
Fulfillment Hub: A Guided CSharpDB Sample
Seed a full warehouse and order-fulfillment database, then explore its tables, forms, reports, procedures, pipelines, collections, and full-text search through CSharpDB Admin.
Creating a C# Launcher for CSharpDB Admin
Build a small C# executable that starts the local CSharpDB Admin web app, waits for the ASP.NET Core site to listen on localhost, and opens the user's default browser to the home page.
Inside CSharpDB v3.3.0: Faster Durable Writes & Easier Tuning
A release-core benchmark walkthrough: 798K rows/sec durable ingest, 1.33M point lookups/sec, and a new storage-tuning surface that brings presets to ADO.NET and EF Core with a one-line connection string change.
CSharpDB vs SQLite: A Benchmark-Driven Guide
Head-to-head v3.3.0 benchmarks on .NET 10 across bulk inserts, point lookups, concurrent writers, and EF Core. Matched WAL+FULL durability, compilable sample code for every pattern, and a decision guide for picking the right API.
Using CSharpDB from Multiple Threads
Learn the supported concurrency model for CSharpDB, including shared Database ownership, snapshot readers, auto-commit writes, explicit transaction rules, and ADO.NET connection-per-worker patterns.
Getting Started with CSharpDB
Learn how to install CSharpDB, create your first database, run SQL queries, use the Collection API, and configure the storage engine — all in a single tutorial.
Working with the Collection API
Store, query, and index typed C# objects without writing SQL. Learn about path indexes, scanning, and building document-oriented applications.
SQL Deep Dive: JOINs, CTEs, and Subqueries
Explore advanced SQL features in CSharpDB including multi-table JOINs, Common Table Expressions, subqueries, set operations, and aggregate functions.