shiny-efcore
Installation
SKILL.md
Shiny EF Core Extensions
Independent feature packages for EF Core 10 (net10.0). Each one plugs in through EF's own extension points:
options-builder extensions, modelBuilder/EntityTypeBuilder extensions, and EF.Functions. Never generate a
custom base DbContext for any of them.
Providers: Outbox, Temporal, AI and Seeding support SQLite, PostgreSQL (Npgsql), SQL Server and MySQL
(MySql.EntityFrameworkCore / UseMySQL, not Pomelo, which has no EF 10 build). Sqlite.Mobile is SQLite-only.
1. Shiny.EntityFrameworkCore.Sqlite.Mobile: spatial, vectors, FTS5 on SQLite
Use this instead of Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite / UseNetTopologySuite(),
which needs mod_spatialite and can't run on iOS or Android.
services.AddDbContext<AppDbContext>(o => o.UseSqlite(cs, s => s
.UseShinySpatial()
.UseShinyVectors() // throws at startup if sqlite-vec can't load; call SqliteVec.RegisterAutoExtension() before opening raw connections
.UseShinyFullText()));