Skip to content

History / SQL Server

Revisions

  • Correct the wiki against the v4 codebase Removes documented APIs that do not exist, fixes behaviour described backwards, and updates pages still describing v3. Fabricated: Settings.ForeignKeyNamingStrategy and its enum, and Settings.ApplyColumnCustomizations. Neither is in either repository. Filtering: filters are OR'd via Any(), not applied in sequence, and multiple RegexIncludeFilters are merged into one alternation first. Settings.ColumnIdentity: the shipped default returns empty for MySQL because Pomelo has no UseIdentityColumn, and honours HiLoSequences; the old example broke both. Schema prefixing: the schema is prepended verbatim and the table is singularised, so billing.Orders is billing_Order, not Billing_Orders. Defaults now follow Database.tt rather than the class initialiser, which differ for DisableGeographyTypes, UseResharper and the folder settings. NullableReverseNavigationProperties was simply wrong. Also: MySQL and Oracle do read column comments through the extended property pipeline; PostgreSQL result models cover set-returning functions only; CommentsStyle is not a flags enum; GenerationLanguage has a Javascript member; sp_describe_first_result_set is never used; the DbContext is not sealed, just not partial; and there is no EnvDTE dependency left for the scripty page to object to. Fills in eleven settings that ship in Database.tt but were undocumented, and adds a per-database DefaultSchema table - SQL Server uses SCHEMA_NAME(), not a hardcoded dbo.

    @sjh37 sjh37 committed Aug 30, 2026
  • Update documentation for v4 Database pages: PostgreSQL, MySQL, Oracle and SQLite were entirely GAC and machine.config setup instructions, and MySQL and Oracle still said "under development". Replaced with dialect guides covering connection strings, permissions, what the reader supports, type mapping and quirks. Each opens by telling v3 users to undo the GAC and machine.config changes. Added a SQL Server page for symmetry. ConnectionString: expanded from the environment variable note to worked examples for all five databases (Azure and Entra ID, RDS, PlanetScale, TNS and wallets, sockets), a per-database permissions table, the SET FMTONLY execute requirement, and three ways to keep the string out of source control. Home: SQL Server CE was listed as fully supported, MySQL and Oracle as under development, Plugin as available, and Settings.FileManagerType appeared in all four recommended-settings blocks. The Quick Start never mentioned installing the efrpg tool, so anyone following it on v4 failed immediately. Fixed, and added an index of the rest of the wiki. Removed the settings that no longer exist from Common Settings Types Explained and Settings Reference: DatabaseType.SqlCe, DatabaseType.Plugin, Settings.DatabaseReaderPlugin and Settings.FileManagerType. Updated stale EF.Reverse.POCO.v3.ttinclude references in five pages. Fixed pre-existing broken cross-links: three pages linked to Custom-file-based-templates when the page name contains U+2010, Migrations linked to "scripty" rather than "script", and seven links had case mismatches. Renamed Syntax-Colour-*.TT-and-*.TTINCLUDE-files to Syntax-Colour-for-T4. The asterisks are illegal in an NTFS filename, so the wiki could not be cloned or pulled on Windows without disabling core.protectNTFS. Deleted Upgrading-from-v2-to-v3, superseded by Upgrading-from-v3-to-v4. Added _Sidebar for navigation.

    @sjh37 sjh37 committed Aug 30, 2026