GitHub

SQLite persistence: a failed WriteToStorageKey leaves its transaction open on a pooled connection, so later writes fail or are silently lost

The System.Data.SQLite invariant resolves to Microsoft.Data.Sqlite, which pools connections by default and does not roll back a transaction that was opened in command text. So the connection goes back ...
GitHub

Microsoft.Data.Sqlite can pool an active transaction after rollback failure #39082

If SQLite rejects ROLLBACK during transaction disposal, Microsoft.Data.Sqlite completes and detaches its managed transaction wrapper anyway. Closing the outer connection can then return a native ...
blog.csdn

System.Data.SQLite 1.0.106.0 部署与避坑指南：netFx35与x64兼容性

SQLite 作为嵌入式数据库，因其轻量、免安装的特性，被大量本地应用和遗留系统采用。在 .NET 平台下，System.Data.SQLite 是连接 SQLite 与 ADO.NET 的官方桥接组件，其老版本包（如 netFx35 对应 .NET 3.5、x64 对应 64 位进程）在老旧 Windows 环境部署时，常因混合模式程序集、位数不匹配或路径权限问题引发异常 ...
blog.csdn

System.Data.SQLite实战：桌面本地存储的选型、连接与事务处理全指南

1. System.Data.SQLite 到底解决什么问题：桌面端本地存储的选型困境 做客户端开发的人早晚会撞上同一个问题：程序要存数据，但用户机器上没有装数据库服务，也不可能为了一个单机工具要求他去配一个 SQL Server 实例。