Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql copied to clipboard
Paging generate SQL
var list = _adminContext.GiveMoneyLog.Include(s => s.UserClerk).Include(s => s.UserSimple).Where(exp).OrderByDescending(m => m.CreateTime).Skip((page - 1) * limit).Take(limit).ToList();
The generated SQL is as follows:
SELECT *
FROM (
SELECT *
FROM `GiveMoneyLog` AS `g`
ORDER BY `g`.`CreateTime` DESC
LIMIT 10 OFFSET 1
) AS `t`
INNER JOIN `UserClerk` AS `u` ON `t`.`UserClerkId` = `u`.`Id`
INNER JOIN (
SELECT *
FROM `UserSimple` AS `u0`
WHERE `u0`.`IsDelete` = 0
) AS `t0` ON `t`.`CreateUserId` = `t0`.`Id`
ORDER BY `t`.`CreateTime` DESC
Why does paging come after join?
