System.Transactions Q

[KA Kueh]

Dear all,

Does anyone know if the new System.Transactions in .Net 2.0 works with ODBC
and OLEDB data providers?. Thanks.

Regards,
Kueh.

 

[Sahil Malik [MVP C#]]

Yup - though you'll get promotion. Also it depends on the underlying the
ODBC/OleDB db you are using.

SM

 

[KA Kueh]

Hi Sahil,

When you mean is that the transaction gets promoted, .Net will be using the
underlying MSDTC transaction. Thanks.

Regards,
Kueh.

 

[Sahil Malik [MVP C#]]

Yes . promotion = MSDTC.

SM

Hi Sahil,

When you mean is that the transaction gets promoted, .Net will be using
the underlying MSDTC transaction. Thanks.

Regards,
Kueh.

 

[KA Kueh]

Hi,

Would it be more tedious to setup the MSDTC and more resources on the PC
would be utilized and the transaction speed would be slower if MSDTC is
utilized. Thanks.

Regards,
Kueh.

 

[Sahil Malik [MVP C#]]

In short "yes". More details - read this -
http://blah.winsmarts.com/2006/06/03/a-quick-primer-on-systemtransactions.aspx

SM