Mono.Data.Sqlite.SqliteConnection.BeginTransaction C# (CSharp) Method

BeginTransaction() public method

Creates a new SqliteTransaction if one isn't already active on the connection.
public BeginTransaction ( ) : SqliteTransaction
return SqliteTransaction
    public new SqliteTransaction BeginTransaction()
    {
      return (SqliteTransaction)BeginDbTransaction(_defaultIsolation);
    }

Same methods

SqliteConnection::BeginTransaction ( IsolationLevel isolationLevel ) : SqliteTransaction
SqliteConnection::BeginTransaction ( IsolationLevel isolationLevel, bool deferredLock ) : SqliteTransaction
SqliteConnection::BeginTransaction ( bool deferredLock ) : SqliteTransaction

Usage Example

示例#1
0
        public void UpdateAllScores(List <Score> scores)
        {
            Mono.Data.Sqlite.SqliteConnection  conn  = null;
            Mono.Data.Sqlite.SqliteTransaction trans = null;
            try
            {
                conn  = openDbConnection();
                trans = conn.BeginTransaction();

                var command = conn.CreateCommand();
                command.Transaction = trans;
                command.CommandText = "DELETE FROM [Score]";
                command.ExecuteNonQuery();
                command.Dispose();

                foreach (var score in scores)
                {
                    this.addScore(conn, trans, score);
                }

                trans.Commit();
            }
            catch (Exception exc)
            {
                trans.Rollback();
                throw exc;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
        }
All Usage Examples Of Mono.Data.Sqlite.SqliteConnection::BeginTransaction