Skip to content
NSchema

All versions since 3.0.0

All versions

3.0.0

First release of the SQL Server provider for NSchema, tracking NSchema 3.2.0 (and requiring NSchema.Core 3.2.0 for in-place column alteration and inline-body trigger support).

Added

  • NSchemaApplicationBuilder.UseSqlServerSchema(...) extensions for registering the provider. Overloads for a connection string and a SqlConnectionStringBuilder configuration delegate, plus a no-arg form for a connection registered elsewhere, and UseSqlServerGenerator() for registering only the SQL generator.
  • SqlServerSchemaProvider implements ISchemaProvider to reads the live database from the sys.* catalog views (tables, columns with identity/computed/default, primary keys, foreign keys, unique and check constraints, indexes with INCLUDE/filters, views, sequences, functions/procedures, table grants, triggers, and MS_Description extended-property comments).
  • SqlServerSqlGenerator implements ISqlGenerator to translates an NSchema MigrationPlan into T-SQL: bracket-quoted identifiers, IDENTITY(seed, increment), persisted computed columns, CREATE OR ALTER views and routines, extended-property comments, and a folded ALTER COLUMN for paired type/nullability changes. Features SQL Server has no equivalent for raise a clear NotSupportedException.
  • SqlType.Money, SqlType.Xml, and SqlType.RowVersion extension helpers for SQL Server-specific column types.

3.0.1

Fixed

  • Fixes the ability to drop schemas by updating to NSchema.Core 3.3.0 that properly emits DROP statements for schema children.

4.0.0

Added

  • Added plugin manifest to allow for automatic registration of the provider coming in `NSchema 4.0.0.

4.3.0 Latest

Added

  • Supports the MIGRATION FOR data migrations introduced in NSchema.Core 4.3: the migration’s SQL is executed verbatim at its planned position in the migration.