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.

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 (default for most databases) 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`