Re: Snapshot Isolation Level - how to select?

One of features of SQL Server 2005 are isolation levels based on row
versioning. New read commited isolation level does not require any change
in
code, but somehow it doesn't fit to our requirements. The other (Snapshot
isolation) is exactly what we want. In our code we set IsolationLevel
property on Connection object choose required behavior. The problem is
there
is no IsolationLevel enum defined for Snaphot isolation in ADO (as
opposite
to Ado.NET).

Well are the Isolation enums for ADO.NET the same values as ADO?
Because if they are, I would try the value for ADO.NET and cast it to the
enum type for ADO. I have no idea if this would work.

Stephen Howe


.

Relevant Pages