ADO.NET Isolation Level

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cwahlmeier@data-tronics.com - 24 Mar 2005 17:12 GMT

I have been researching ADO.NET in order to train our programming
staff. I am curious if someone would know what the default isolation
level is with and without a transaction. Furthermore, if I specify the
isolation level on the transaction object, which one is the most like
cursor stability? Is it read commited?

Any other opinions/best practices regarding ADO.NET are welcome. I
have been reading the redbook DB2 for UDB V8.2 on the Windows
Environment. It mentions that there is a new connection string keyword
for isolation level. But I haven't found it yet.

Thanks,

Craig Wahlmeier

Reply to this Message

amurchis - 29 Mar 2005 22:01 GMT

I think this is a public link to the most current DB2 documentation:

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

Try typing in ".NET isolation level" into the Search box... I've looked
over the results and I think it gives both the answers.

From what I see, the default is "ReadCommitted" and the keywords in the
connection string are (surprise! :) ), "Isolation Level" or
"IsolationLevel".

> I have been researching ADO.NET in order to train our programming
> staff. I am curious if someone would know what the default isolation
[quoted text clipped - 10 lines]
>
> Craig Wahlmeier

Reply to this Message