SQLCE3.5 database transaction processing, sqlce3.5 Database Transaction

SQLCE3.5 database transaction processing, sqlce3.5 Database Transaction

By chance, I learned from MSDN today (I always thought that SQLCE does not support transactions ).

I believe that many WINCE developers, like me, directly use sqlce. excute ("begin tran") but find that SQL ce does not support syntax errors.

In fact this is caused by T-SQL inertial thinking. The following shows how to use: (environment. NET35 + SQLCE35 + XP + VS2008)

Sqlce. open (); // open the SQLCE database. If you do not want to write the actual code.

// Start

SqlCeTransaction m_tran = sqlce. BeginTransaction (); // starts a transaction, which is encapsulated into a class different from the T-SQL.

// Execute your statement (Omitted) here and the T-SQL is basically no difference

M_tran.Rollback (); // rollback operation

.......

M_tran.Commit (); // submit a transaction

**************************************** ******** Completed, don't ask if you don't understand it. People with a basic understanding can understand it at a glance! ******************************