mirror of
https://github.com/microsoft/dotnet.git
synced 2025-12-19 17:37:07 -05:00
d3c7558185
* 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
32 lines
961 B
Markdown
32 lines
961 B
Markdown
## 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
|
|
|
|
### Category
|
|
Windows Workflow Foundation (WF)
|
|
|
|
<!-- breaking change id: 180 -->
|