dotnet/Documentation/compatibility/workflow-sql-persistence-adds-primary-key-clusters-and-disallows-null-values-in-some-columns.md at main

mirror of https://github.com/microsoft/dotnet.git synced 2025-12-19 17:37:07 -05:00

Files

Rich Lander d3c7558185 Update READMEs and compatibility docs (#379 )

* Update breaking change doc formatting

* Update release and breaking change READMEs

* Update Readme with BC Links 1

* Add BC changes for releases

* Update TOC for BC README

* Update 4.6.1 release

* Move breaking-change to compatibility

* Update compatiblity links

* Update compatiblity links

* Update breaking change wording

* Add testing with RyuJIT doc

* Update breaking change wording

2017-04-17 16:52:04 -07:00

961 B

Raw Permalink Blame History

Workflow SQL persistence adds primary key clusters and disallows null values in some columns

Scope

Edge

Version Introduced

4.7

Source Analyzer Status

NotPlanned

Change Description

Starting with the .NET Framework 4.7, the tables created for the SQL Workflow Instance Store (SWIS) by the SqlWorkflowInstanceStoreSchema.sql script use clustered primary keys. Because of this, identities do not support null values. The operation of SWIS is not impacted by this change. The updates were made to support SQL Server Transactional Replication.

Quirked
Build-time break

Recommended Action

The SQL file SqlWorkflowInstanceStoreSchemaUpgrade.sql must be applied to existing installations in order to experience this change. New database installations will automatically have the change.

Affected APIs

Not detectable via API analysis

961 B Raw Permalink Blame History