IsolationLevel
(Adding message template to the top of the page)
(Updated Edited template to July 12, 2025.)
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{message|Write the content here to display this box}}
<message>Write the content here to display this box</message>
This is how a database tells how isolated a task is from other tasks in the database. See: [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]
This is how a database tells how isolated a task is from other tasks in the database. See: [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]


Line 6: Line 6:
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.  
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]]
{{Edited|July|12|2024}}
{{Edited|July|12|2025}}

Latest revision as of 05:51, 20 January 2025

This page was created by Hans.karlsen@mdriven.net on 2022-04-24. Last edited by Edgar on 2025-01-20.

This is how a database tells how isolated a task is from other tasks in the database. See: https://docs.microsoft.com/en-us/dotnet/api/system.data.isolationlevel

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.