CODEWITHSUNDEEP
databasetransactionslockingisolation-level
tommi
tommi

Reputation: 6973

Database: Transaction isolation levels automatically determine placement of locks?

I just started to know more about transactions, locks and isolation levels. I'm getting a little confused here and trying to get some clarification.

I had referred to these pages for more understanding:
http://msdn.microsoft.com/en-us/library/ms173763.aspx http://en.wikipedia.org/wiki/Isolation_(database_systems)

My question here is: Does the transaction isolation levels automatically determine when database tables and/or rows will be placed and when these locks will be unlocked?

Upvotes: 1

Views: 246

Answers (1)

Will Hartung
Will Hartung

Reputation: 118774

Yes, the database handles the locking for you and the ramifications of those locks based upon the isolation level. As a developer, you need to be aware of how the isolation levels impact locks, data availability, data state and data visibility within the database.

But fundamentally, it is the DB service itself which manages these aspects. You don't need to do any kinds of manual locking, for example.

Upvotes: 1

Related Questions