private DataTable ExecuteQuery(string query) { using (var connection = new LegacyDatabaseConnection(connectionString)) { return(connection.Execute(query)); } }
public Participant Get(long id) { try { using (var connection = new LegacyDatabaseConnection(connectionString)) { var dataTable = connection.Execute($"Select...{id}"); return(GetParticipant(dataTable)); } } catch (DatabaseNotFoundException e) { Logger.Log($"DB {e.Database} not found in server {e.Server}."); throw; //throw e; } catch (AccessDeniedException e) { //We know that actual reason is size of a table Logger.Log($"Table {e.Table} size exceeded in {e.Server}.{e.Database}"); throw; } catch (InvalidSQLOperationException e) when(e.Code == "SQL_BUSY") { //another connection is using the database //Retry; return(Get(id)); } catch (InvalidSQLOperationException e) { Logger.Log(e.Message); throw; } catch (TimeoutException e) { //Retry return(Get(id)); } }