|
public BeginTransaction ( IsolationLevel isolationLevel ) : |
||
| isolationLevel | IsolationLevel | Supported isolation levels are Serializable, ReadCommitted and Unspecified. |
| return | ||
public new SqliteTransaction BeginTransaction(IsolationLevel isolationLevel)
{
return (SqliteTransaction)BeginDbTransaction(isolationLevel);
}
|
SqliteConnection::BeginTransaction ( ) : |
|
|
SqliteConnection::BeginTransaction ( IsolationLevel isolationLevel, bool deferredLock ) : |
|
|
SqliteConnection::BeginTransaction ( bool deferredLock ) : |
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();
}
}
}