IsolationLevel
No edit summary
No edit summary
Line 1: Line 1:
[https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel?view=net-6.0 https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel]
[https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel?view=net-6.0 https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel]


A database way to tell how isolated a task is from other tasks for the database.
This is how a database tells how isolated a task is from other tasks in the database.


In MDriven you set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.
In MDriven, set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.


If you have a too low UpdateIsolationLevel extraction of new id's and timestamps my not be unique and cause problems with your data integrity
If you have too low a UpdateIsolationLevel extraction of new IDs and timestamps, it may not be unique and cause problems with your data integrity.
[[Category:Database]]
[[Category:Database]]

Revision as of 06:40, 14 March 2023

https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel

This is how a database tells how isolated a task is from other tasks in the database.

In MDriven, set in SqlDatabaseConfig one isolation level for update UpdateIsolationLevel and one for read FetchIsolationLevel.

If you have too low a UpdateIsolationLevel extraction of new IDs and timestamps, it may not be unique and cause problems with your data integrity.

This page was edited 98 days ago on 02/10/2024. What links here