Do you know that? 2M+ businesses that use oDesk next

Different transaction isolation levels in WCF

  • Read Uncommitted: - Also known as Dirty isolation level. It makes sure that corrupt Data cannot be read. This is the lowest isolation level
  • Read Committed: - It ensures not to read the data that has been changed by any other application and is not yet committed. It is the default level.
  • Repeatable Read: - It stops the usage of dirt read and non-repeatable read. It states that data fetched through a query will be locked and will not be updated by any other transaction.
  • Serializable: - It does not allow any modification and addition of new data till the transaction is completed. This is considered to be a very restrictive level.
  • Snapshot: - It raises error on modifying a data that has already been changed by any transaction.