Shiny.SqliteDocumentDb v2.0.0 — Table-Per-Type, Custom Ids, Diffing, and Batch Insert

Version 2 of the SQLite document store focuses on flexibility. You can now map document types to dedicated tables, use any property as the document Id, diff objects against stored documents, and batch insert collections efficiently — all while keeping the simple “throw an object in, get it back out” API.

What you’ll learn

• How table-per-type mapping with MapTypeToTable<T>() gives document types their own SQLite tables
• How custom Id properties let you use CustomerId, DeviceKey, or any Guid/int/long/string property as the document key
• How GetDiff() returns an RFC 6902 JsonPatchDocument<T> for deep object comparison against stored documents
• How BatchInsert uses a single transaction with prepared command reuse for high-throughput inserts
• How to mix mapped and unmapped types in the same store
• The DI extensions package split and migration steps from v1