SharpCoreDB v2.0 — performance-first. An embedded, encrypted, SIMD-accelerated database engine and production gRPC server for .NET 10 / C# 14.
Version 2.0.0.0 · MIT License · GitHub
- 1. Quick Start — install, open a database, first CRUD
- 2. Feature Overview — everything SharpCoreDB ships, at a glance
- 3. Database Core — storage modes, transactions & WAL, AES-256-GCM, metadata
- 4. Data Modeling — data types, ULID, auto-rowid, collation, constraints
- 5. Indexing — hash indexes, B-tree indexes, adaptive/expression/partial indexes
- 6. Querying — SQL dialect, aggregates, window functions, joins, subqueries
- 7. Performance Guide — when SharpCoreDB is fastest and how to get there ⭐
- 8. SIMD & Vector Engine — analytics, vector search, GraphRAG, time-series
- 9. Server Mode — gRPC, REST, security, multitenancy, observability
- 10. Providers & Adapters — ADO.NET, EF Core, Dapper, linq2db, YesSql, Sync
- 11. Architecture Packages — EventSourcing, CQRS, Projections, Distributed, Functional
- 12. Migration — from SQLite / LiteDB / RavenDB to SharpCoreDB
- 13. Advanced Features, Integration & Troubleshooting — stored procedures, views, triggers, ASP.NET Core patterns, unit testing, troubleshooting
- 14. Documentation Index — the full docs hub
- 15. Performance Roadmap — v2.x plan + measured results
- 16. Changelog
Each chapter is self-contained and includes runnable C# examples. Deep-dive documents live in
the docs/ tree and are linked from the relevant chapters.
Conventions
| Mark | Meaning |
|---|---|
| ✅ | Fully supported in v2.0 |
| ⚡ | Performance-relevant API — see the Performance Guide |
| 🧩 | Optional package (separate NuGet) |
Package quick reference
| Package | Purpose |
|---|---|
SharpCoreDB |
The core engine (this manual covers it) |
SharpCoreDB.Data.Provider |
ADO.NET provider (DbConnection/DbCommand) |
SharpCoreDB.EntityFrameworkCore |
EF Core provider |
SharpCoreDB.Functional.Dapper · Functional.EntityFrameworkCore · Functional.Linq2DB |
functional adapters |
SharpCoreDB.Provider.YesSql · SharpCoreDB.Provider.Sync |
OrchardCore/YesSql + Dotmim.Sync |
SharpCoreDB.EventSourcing · Projections · CQRS · Distributed |
architecture packages |
SharpCoreDB.Server · Server.Core · Server.Protocol |
network server |
SharpCoreDB.VectorSearch |
vector index + similarity search |
| Version | Highlights |
|---|---|
| 2.0.0 | Performance-first release. Zero-allocation StructRow reads, zero-reparse point-lookup fast path, SIMD numeric scan filtering, Native AOT readiness, allocation reduction, compiled regexes, cached DI. See the Performance Guide for measured results (point reads beat SQLite; all operations beat LiteDB). |
| 1.9.x | WHERE IN regression fix, EF Core provider hardening, functional adapters, SonarCloud onboarding |
| ≤ 1.8 | Security, server, GraphRAG, vector, time-series feature growth |
See CHANGELOG.md for the full history.