TableAdapter-Transaction

TableAdapter-Transaction

Postby Zero-G. » Wed 01 Aug 2007 08:13

Hey

I use VB.NET 2005 & your controls v4

I have changed the Engines of my tables from MyISAM to InnoDB. One of the reasons was, that InnoDB provides Transaction.
So, the most Database related queries where made from DataSets (with TableAdapters). - So, is there a possibility to re-tool the DataSets with transactions? Or how to do this?

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby Alexey » Wed 01 Aug 2007 08:50

Datasets know nothing about storage engine. So I don't understand what is the problem.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Zero-G. » Wed 01 Aug 2007 08:54

Hey

Yes, I know, but how to provide transaction save update/insert Statements?

Or does the DataSet itself provides any kind of technologie for transaction?

THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby Alexey » Wed 01 Aug 2007 09:27

You should do this yourself. Use BeginTransaction(), etc. methods of MySqlConnection class.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL