public static void ExtractData() { Logger.LogEvent("**************** STARTING MANAGER UPDATE ****************"); try { using (var sqlConnection = SqlDBUtil.GetConnection()) { using (var oracleConnection = OracleDBUtil.GetConnection()) { Logger.LogEvent(" Trying to connect to server.."); sqlConnection.Open(); Logger.LogEvent(" Connected to server"); SqlDBUtil.TruncateTable(sqlConnection); SqlDBUtil.ExecuteInsert(sqlConnection, oracleConnection); Logger.LogEvent(" Extract and import part is DONE!"); Logger.WriteLogToFile(); } } } catch (OracleException oraEx) { EmailUtility.SendEmail("ORACLE EXCEPTION: " + "\r\n" + oraEx.Message, "Import Failed!"); Logger.LogException(oraEx.Message); Logger.WriteLogToFile(); throw; } catch (Exception ex) { EmailUtility.SendEmail("Other EXCEPTION while retrieving data from Oracle db: " + "\r\n" + ex.Message, "Import Failed!"); Logger.LogException(ex.Message); Logger.WriteLogToFile(); throw; } }