468,290 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,290 developers. It's quick & easy.

ADO.NET Isolation Level

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

Nov 12 '05 #1
1 2481
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Markus Breuer | last post: by
9 posts views Thread by yu_sha | last post: by
3 posts views Thread by Eric Porter | last post: by
5 posts views Thread by m0002a | last post: by
3 posts views Thread by RG | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.