Skip to main content

sqlite-adonet

Implementation details for the Microsoft.Data.Sqlite ADO.NET provider. Use when changing files under `src/Microsoft.Data.Sqlite.Core/`.

来源信息

仓库
dotnet/efcore
最近来源活动
2026年10月8日 18:29
检测到的 SKILL.md 语言
英语
星标
14,798
分支
3,437

安装方式

默认使用会先检查来源的 Prompt;你也可以切换为直接命令,或下载本地副本。

检查来源文件

决定是否安装前,请先阅读 SKILL.md,以及 SkillsMP 当前展示的配套文件。

正在显示 SKILL.md

SKILL.md
来源说明 · 只读预览
name
sqlite-adonet
description
Implementation details for the Microsoft.Data.Sqlite ADO.NET provider. Use when changing files under `src/Microsoft.Data.Sqlite.Core/`.
user-invocable
false
# Microsoft.Data.Sqlite Standalone ADO.NET provider in `src/Microsoft.Data.Sqlite.Core/`, independent of EF Core. Implements `System.Data.Common` abstractions. ## Notable Implementation Details - Static constructor calls `SQLitePCL.Batteries_V2.Init()` reflectively - `CreateFunction()`/`CreateAggregate()` overloads generated from T4 templates (`.tt` files) ## Command Lifecycle `SqliteConnection` tracks associated commands as weak references. Closing an open connection disposes every live tracked command before closing the native connection; command disposal releases prepared statements and unregisters the command. Diagnose close/reopen reports from this ownership path and the `System.Data.Common` contract, not from EF Core provider abstractions. Closing does not erase the command's managed configuration or connection reference. If the same command object is used after reopening its connection, execution prepares fresh native statements against the new handle. Add a regression test only when the reported behavior remains reachable after following this lifecycle. ## Transaction Completion A failed `COMMIT` can leave the SQLite transaction active and retryable. Do not call `Complete()` or add transaction-level retries; `SqliteCommand` already retries busy/locked results through the connection's `ExecuteNonQuery` path. Rollback during disposal must detach the managed transaction even when rollback throws, so keep `Complete()` in its `finally`. Test failed commit separately from failed `Dispose()`/`DisposeAsync()`: preserve the original exception and verify disposal permits a subsequent transaction.
在 GitHub 查看