Skip to content

SQLite

Version 5.0.0

Tracks the NSchema.Core 5.0.0 rearchitecture (lockstep major versioning). See the core changelog for the engine-wide changes; the provider-facing ones are below.

Added

  • new asks which file to use. The plugin declares the database file as a scaffolding question and composes the answer into the connection_string it writes.

Changed

  • UseSqlite(...) replaces UseSqliteSchema(...), and UseSqliteDialect() replaces UseSqliteGenerator().
  • Introspection implements IDatabaseIntrospector (the core seam replacing ISchemaProvider) and returns the new NSchema.Model schema model.
  • SQL generation is a SqlDialect (the core seam replacing ISqlGenerator), registered via UseSqliteDialect().
  • Unsupported operations are error diagnostics now. Actions SQLite cannot express (in-place column changes, constraint changes on an existing table, sequences, enums, routines, grants, materialized views, …) surface as errors on the plan result instead of throwing NotSupportedException, so you always get the complete plan.
  • Comment changes are skipped with a warning. SQLite has no COMMENT ON; a declared comment previously emitted no SQL silently, and now carries a warning diagnostic explaining why it never converges.
  • The plugin is configured by a DATABASE statement (replacing the PROVIDER block), and its scaffold template no longer pins a version — the host owns the PLUGIN declaration.