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