Skip to content
← Customer Feedback for LINQPad

Settings and activity

1 result found

  1. Allow to set query transaction isolation level

    129 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    13 comments  ·  LINQPad Feature Suggestions  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Mark Burke commented  · 

    I have just been adding these two lines (comment and command) to any linqpad script querying production databases as the first command to execute prior to running the query. Usually at the start of Main().

    // Required to prevent concurrent locking of transactions
    this.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;");