Enum IsolationLevel 

pub enum IsolationLevel {
    ReadUncommitted,
    ReadCommitted,
    RepeatableRead,
    Serializable,
    Snapshot,
}

Transaction isolation level.

SQL Server supports these isolation levels for transaction management.

Variants

ReadUncommitted

Read uncommitted (dirty reads allowed).

Lowest isolation - transactions can read uncommitted changes from other transactions. Offers best performance but no consistency guarantees.

ReadCommitted

Read committed (default for SQL Server).

Transactions can only read committed data. Prevents dirty reads but allows non-repeatable reads and phantom reads.

RepeatableRead

Repeatable read.

Ensures rows read by a transaction don’t change during the transaction. Prevents dirty reads and non-repeatable reads, but allows phantom reads.

Serializable

Serializable (highest isolation).

Strictest isolation - transactions are completely isolated from each other. Prevents all read phenomena but has highest lock contention.

Snapshot

Snapshot isolation.

Uses row versioning to provide a point-in-time view of data. Requires snapshot isolation to be enabled on the database.

Implementations

impl IsolationLevel

pub fn as_sql(&self) -> &'static str

Get the SQL statement to set this isolation level.

pub fn name(&self) -> &'static str

Get the isolation level name as used in SQL Server.

Trait Implementations

impl Clone for IsolationLevel

fn clone(&self) -> IsolationLevel

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for IsolationLevel

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for IsolationLevel

fn default() -> IsolationLevel

Returns the “default value” for a type.

impl PartialEq for IsolationLevel

fn eq(&self, other: &IsolationLevel) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Copy for IsolationLevel

impl Eq for IsolationLevel

impl StructuralPartialEq for IsolationLevel