Is it possible to do an ADO.NET transaction using just the OleDb space
and not touch the managed SqlClient at all?

I am trying to build a common data component that must work with
Oracle and MsSql and 3 other databases, all support XA-style
transactions. I hope that I can use just the OleDb provider to do
transactions so keep from doing many provider-specific things.

Is it possible?

Thanks.

Sure (but it is a database transaction, never an ado.net transaction).
See OleDbConnection.BeginTransaction Method.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com


"localhost" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
>
> Is it possible to do an ADO.NET transaction using just the OleDb space
> and not touch the managed SqlClient at all?
>
> I am trying to build a common data component that must work with
> Oracle and MsSql and 3 other databases, all support XA-style
> transactions. I hope that I can use just the OleDb provider to do
> transactions so keep from doing many provider-specific things.
>
> Is it possible?
>
> Thanks.
>
>

Thanks for Miha's quick response!

Hi localhost,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to start transactions in the
OleDb provider. If there is any misunderstanding, please feel free to let
me know.

We can use OleDbTransaction class to achieve this. Just as Miha said, using
OleDbConnection.BeginTransaction method, we can get an OleDbTransaction
object to manipulate on. For more information about OleDbTrasaction class
and OleDbConnection.BeginTransaction method, please check the following
links:

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdataoledboledbtransactionclasstopic.asp

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfSystemDataOleDbOleDbConnectionClassIDbConnectionBeginTransactionTopic.a
sp

HTH. If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."