E
Eric
I'm developing an application in C#. The application consist of a data layer
which must be capable of using mysql, mssql and access for data storage.
I started using OleDb with interfaces like IdbConnection to achive this.
Everything worked fine until i came at the issue of locking. I found out
that
Access only supports IsolationLevel.ReadCommited which only avoids
dirty reads. I need more advanced locking for my application.
I then tried the same with the classic ADODB (com interface) and found out
that
i have far more locking options working (on Access). Why can't i use let's
say
Isolationlevel.Serializable with OleDb but can use it with ADODB? I can make
use of ADODB for all supported databases but i prefer to use the Native .NET
drivers
(SqlConnection & MySqlConnection) since there have a far better performance.
Thanks in advance for any advice!
which must be capable of using mysql, mssql and access for data storage.
I started using OleDb with interfaces like IdbConnection to achive this.
Everything worked fine until i came at the issue of locking. I found out
that
Access only supports IsolationLevel.ReadCommited which only avoids
dirty reads. I need more advanced locking for my application.
I then tried the same with the classic ADODB (com interface) and found out
that
i have far more locking options working (on Access). Why can't i use let's
say
Isolationlevel.Serializable with OleDb but can use it with ADODB? I can make
use of ADODB for all supported databases but i prefer to use the Native .NET
drivers
(SqlConnection & MySqlConnection) since there have a far better performance.
Thanks in advance for any advice!