ADO.NET Isolation Level

[cwahlmeier]

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

[amurchis]

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

http://publib.boulder.ibm.com/infoce...help/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".

cw********@data-tronics.com wrote:

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