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);
}
