有没有用过SqlSuger的大佬 多表联查怎么弄啊

Question

SELECT COUNT(1),h.type FROM ten_sample_ser_delivery d
JOIN ten_sample_hearse h ON
d.CarId=h.id
WHERE 
d.STATUS !='Abolished' AND d.STATUS !='canceled'
GROUP BY h.type

我裂开了 弄了我半天了

Answer 1

// 多表查询并分组统计
var list = db.Queryable<ten_sample_ser_delivery, ten_sample_hearse >()
    .JoinQuery((d, h) => d.CarId== h.id)
    .Select((d, h) => new { h.type, TypeCount = SqlFunc.AggregateCount(h.type) })
    .GroupBy((d, h) => h.type)
    .ToList();