public static void Query(this SqliteConnection source, DatabaseQueriedEventArgs args) { source.Open(); using SqliteTransaction transaction = source.BeginTransaction(); using (SqliteCommand command = source.CreateCommand()) { command.Transaction = transaction; command.CommandText = args.Query; command.ExecuteNonQuery(); } transaction.Commit(); }
public static async Task QueryAsync(this SqliteConnection source, DatabaseQueriedEventArgs args) { await source.OpenAsync(); await using SqliteTransaction transaction = source.BeginTransaction(); await using (SqliteCommand command = source.CreateCommand()) { command.Transaction = transaction; command.CommandText = args.Query; await command.ExecuteNonQueryAsync(); } transaction.Commit(); }