Sunday, February 12, 2012

Begin Transaction in Asp.net

Hi All,

Can any one help by giving me the details/difference in using the

Transaction Isolation Levels (read uncommitted,read committed,repeatable read, orserializable)

in asp.net. I just want to know in which case we can use these things in begining a transaction, and will it improve the performance.

thanks in advance

Boo

Here's one article I found by searching Google forsql server transaction isolation levels:http://www.mssqlcity.com/Articles/General/TIL.htm|||

Thanks for the link but i have seen an elobrated content of the same in microsoft.com itself. My doubt is how i can use it in my VB.Net to control the transaction

Thanks

Boo

|||

jbo:

Hi All,

Can any one help by giving me the details/difference in using the

Transaction Isolation Levels (read uncommitted,read committed,repeatable read, orserializable)

in asp.net. I just want to know in which case we can use these things in begining a transaction, and will it improve the performance.

thanks in advance

Boo

The first link covers what you are asking ADO.NET transactions with SAVE POINTs which allow you to run nested transaction blocks, it is very important if you are running more than one because if you get an error transactions without SAVE POINTs all will roll back to number one. The second link download the PDF file and the ZIP file Dusan Petkovic explained SQL Server transactions better than any writer I know. Isolation level serializable is the higest should be left to banks and SQL Server because through lock escalation SQL Server can take control of your isolation level, the others read the PDF file in the second link below. Hope this helps.

http://1.davidhayden.com/blog/dave/archive/2005/10/15/2517.aspx
http://books.mcgraw-hill.com/getbook.php?isbn=0072260939&template

No comments:

Post a Comment