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