/// <summary> /// Executes a scalar query /// </summary> /// <returns></returns> private async Task <dynamic> ExecuteScalar() { try { using (OdbcConnection cn = new OdbcConnection(this.ConnectionString)) { using (OdbcCommand cmd = new OdbcCommand(this.Query, cn)) { cn.Open(); var result = await cmd.ExecuteScalarAsync(); return(result); } } } catch (Exception ex) { throw ex; } }
public static async Task <T> SelectGenericAsync <T>(string executeStatement) { using (OdbcConnection con = new OdbcConnection(GlobalConstants.ConnectionString)) { using (OdbcCommand com = new OdbcCommand(executeStatement, con)) { if (con.State == ConnectionState.Closed) { con.Open(); } object result = await com.ExecuteScalarAsync(); if (result == DBNull.Value || result is null) { throw new NullReferenceException("selected value is null"); } return((T)result); } } }