public async Task <DemographicQuery> UpdateDemographicQueryAsync(DemographicQuery query)
{
log.LogInformation("Updating DemographicQuery SqlStatement:{SqlStatement}", query.SqlStatement);
var record = new DemographicQueryRecord(query);
ThrowIfInvalid(record);
using (var cn = new SqlConnection(opts.ConnectionString))
{
await cn.OpenAsync();
await cn.ExecuteAsync(
queryUpdate,
new { sql = record.SqlStatement, user = user.UUID },
commandTimeout : opts.DefaultTimeout,
commandType : CommandType.StoredProcedure
);
return(query);
}
}
string CteDemographicInternals(DemographicQuery demographicQuery) => demographicQuery.SqlStatement;
public DemographicQueryRecord(DemographicQuery query)
{
SqlStatement = query.SqlStatement;
}
