Delayed durability support
Open
Good First Issue :sparkles:
Up-for-Grabs :raised_hands:
- Dominant language
- C#
- Stars
- 989
- Forks
- 340
- Avg merge
- 4d 19h
- Merged PRs (30d)
- 72
Description
### Is your feature request related to a problem? Please describe.
SQL Server 2014 supports [delayed durability](https://docs.microsoft.com/en-us/sql/relational-databases/logs/control-transaction-durability?view=sql-server-ver15). This requires a slight different SQL for the commit:
`COMMIT WITH (DELAYED_DURABILITY = ON)`
### Describe the solution you'd like
A property in SqlTransaction, for example bool DelayedDurability
### Describe alternatives you've considered
Manually executing the SQL `BEGIN TRANSACTION` and `COMMIT` is the alternative but it would be nice if it's builtin.
Contributor guide
Assessment
This issue has not been assessed yet.