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/`.

Quellinformationen

Repository
dotnet/efcore
Letzte Quellaktivität
8. Oktober 2026 um 18:29
Erkannte Sprache von SKILL.md
Englisch
Sterne
14.798
Forks
3.437

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

SKILL.md wird angezeigt

SKILL.md
Quellanweisungen · Schreibgeschützte Vorschau
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.
Auf GitHub ansehen