先赋一个sql语句,然后转lambda表达式。
//select a.`Name` as 停车场,
//sum(b.ShouldPayAmount) as 总金额,
//count(b.ShouldPayAmount) as 总条数
//from parkinglot a left
//join paymentorder b on b.ParkingLotId = a.Id
//where a.TenantId = 3 and a.IsDeleted != 1 group by a.'Name'
//ORDER by sum(b.ShouldPayAmount)
对多表进行连接,然后进行分组(这里只对一个分组,可以多个分组x=>new{x.t1,x.t2}),最后查询排序。
完整的代码:
class Program
{
static void Main(string[] args)
{
//select a.`Name` as 停车场,
//sum(b.ShouldPayAmount) as 总金额,
//count(b.ShouldPayAmount) as 总条数
//from parkinglot a left
//join paymentorder b on b.P