determine if IsolationLevel XYZ is supported RRS feed

  • Question

  • Hello, 

    i am working on a multi-dbms solution.

    One problem is that not every IsolationLevel is supported on every Platform.

    for example Oracle does not support ReadUncommited.

    Is there a way to determine wich IsolationLevels are supported by a IDbConnection , without a try-catch ?

    Wednesday, December 29, 2010 4:17 PM

All replies

  • No, but you can do some virtual or abstract method that answer your requirement.

    Its not only an support or not thing, think other differences like in Informix isolation level is independent of the fact you are in a transaction or not, other dbms requires a transaction to set an isolation level for example.

    Thursday, May 12, 2011 7:04 PM