/// <summary> /// Wykonuje zapytanie w bazie danych /// </summary> /// <param name="cmd">Polecenie zapytania</param> /// <returns>Komunikat o ewentualnym błędzie</returns> public static async Task <string> ExecuteNonQueryAsync(OracleCommand cmd) { var errmsg = string.Empty; try { await cmd.Connection.OpenAsync(); await cmd.ExecuteNonQueryAsync(); } catch (OracleException oex) { errmsg = OracleMessageFormatter.FirstLine(oex.Message); } catch (Exception sex) { errmsg = sex.Message; } finally { cmd.Connection.Close(); } return(errmsg); }
/// <summary> /// Wykonuje zapytanie w bazie danych /// </summary> /// <param name="cmd">Polecenie zapytania</param> /// <returns>Tabela z wynikiem lub komunikat o błędzie</returns> public static async Task <(DataTable, string)> ExecuteReaderAsync(OracleCommand cmd) { var ret = new DataTable(); try { await cmd.Connection.OpenAsync(); var odr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult); ret.Load(odr); } catch (OracleException oex) { return(null, OracleMessageFormatter.FirstLine(oex.Message)); } catch (Exception sex) { return(null, sex.Message); } finally { cmd.Connection.Close(); } return(ret, string.Empty); }