Document in-memory setup; correct normalization and concurrency for the lock removal
- Add an in-memory setup section: connection string (Mode=Memory, named, Cache=Shared)
plus the busy_timeout pragma, with a note that the pragma is inert for in-memory
(shared-cache conflicts bypass the busy handler; Microsoft.Data.Sqlite's command-timeout
retry serializes writers) and is the contention knob for file-backed stores.
- Correct connection-string normalization: ForeignKeys is defaulted when unset; Mode and
Pooling are preserved, so Mode=Memory is honored rather than rewritten to a file.
- Storage-Architecture: the in-memory store holds no application-level lock.
- Recipe: mirror the current normalization in the per-test ClearPool builder.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Wiki refresh: new pages, accuracy fixes, sentence-case headings
- Add Tutorial, FAQ, DI-and-Configuration, and four Recipe pages
- Refresh Home, Getting-Started, and reference pages
- Fix API-parity, options arity, WAL behavior, and builder-surface
accuracy across DI, Getting-Started, Storage-Architecture, FAQ,
Recipe-Xunit-Per-Test-Isolation, Recipe-Aspnet-Integration-Test-Fixture,
API-Parity, and Tutorial
- Normalize headings to sentence case across reference pages
- Add .gitignore to exclude .findings/ review scratch
Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>