public void BeginTransaction(System.Data.IsolationLevel isolation) { try { _Transaction = _Conexao.BeginTransaction(isolation); } catch (Exception ex) { throw new Exception("Não foi possível iniciar a transação.", ex); } }
/// <summary> /// 执行 SQL 语句 /// </summary> /// <param name="sql"></param> /// <returns></returns> public bool EditDatabase(string sql) { bool successState = false; Connection.Open(); SqlCeTransaction myTrans = Connection.BeginTransaction(); SqlCeCommand command = new SqlCeCommand(sql, Connection, myTrans); try { command.ExecuteNonQuery(); myTrans.Commit(); successState = true; } catch { myTrans.Rollback(); } finally { Connection.Close(); } return(successState); }