/// <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);
}