Postgres SQL 结合 Dapper 时序分析

最新推荐文章于 2024-06-02 13:09:10 发布

杰克2022

最新推荐文章于 2024-06-02 13:09:10 发布

阅读量189

点赞数

本文链接：https://blog.csdn.net/wyh0318/article/details/128482995

版权

<PackageReference Include="Dapper" Version="2.0.123" />
<PackageReference Include="Npgsql" Version="6.0.0" />

var result = (await _npgsqlConnection.QueryAsync<dynamic>("SELECT minute, count(Id) as doccount FROM generate_series(:StartTime, :EndTime, interval '1 MINUTE') as g(minute) LEFT JOIN ods_tsc_order ON date_trunc('minute', ordertime) = minute GROUP BY minute ORDER BY minute;", new { StartTime = oneHourAgo.AddMinutes(-1), EndTime = request.Now.Value })).ToList();