Documentation:IsolationLevel: Difference between revisions

IsolationLevel

Revision as of 05:41, 27 June 2023

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.

@@ 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]
+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.
 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.
 [[Category:Database]]