IsolationLevel (SQLProvider)

IsolationLevel Type

Namespace: FSharp.Data.Sql.Transactions
Assembly: FSharp.Data.SqlProvider.Common.dll
Base Type: Enum
All Interfaces: IComparable , IConvertible , ISpanFormattable , IFormattable
Kind: Struct
This is an enum type definition

Transaction isolation level for database operations. Corresponds to the System.Transactions.IsolationLevel but provides SQL provider specific functionality. Only applied when SubmitUpdates creates its own (standalone) write transaction; if you wrap your own ambient System.Transactions scope, that scope's isolation level is used instead.

Record fields

Record Field	Description
`Chaos` Full Usage: `Chaos` Field type: `IsolationLevel` Modifiers: static	Allows any level of isolation, including overlapping changes (SQL Server specific) Field type: `IsolationLevel`
`DontCreateTransaction` Full Usage: `DontCreateTransaction` Field type: `IsolationLevel` Modifiers: static	Special value to indicate that no transaction should be created Field type: `IsolationLevel`
`ReadCommitted` Full Usage: `ReadCommitted` Field type: `IsolationLevel` Modifiers: static	Prevents dirty reads but allows non-repeatable reads and phantom reads. (This describes the default isolation of most DB engines - it is NOT SQLProvider's default; TransactionOptions.Default is Serializable, inherited from System.Transactions.) Field type: `IsolationLevel`
`ReadUncommitted` Full Usage: `ReadUncommitted` Field type: `IsolationLevel` Modifiers: static	Allows dirty reads, non-repeatable reads, and phantom reads (fastest but least safe) Field type: `IsolationLevel`
`RepeatableRead` Full Usage: `RepeatableRead` Field type: `IsolationLevel` Modifiers: static	Prevents dirty reads and non-repeatable reads, but phantom reads can occur Field type: `IsolationLevel`
`Serializable` Full Usage: `Serializable` Field type: `IsolationLevel` Modifiers: static	Highest isolation level - transactions are completely isolated from each other Field type: `IsolationLevel`
`Snapshot` Full Usage: `Snapshot` Field type: `IsolationLevel` Modifiers: static	SQL Server specific - provides statement-level read consistency using versioning Field type: `IsolationLevel`
`Unspecified` Full Usage: `Unspecified` Field type: `IsolationLevel` Modifiers: static	Use the default isolation level of the database Field type: `IsolationLevel`