search

shuxinqin / Chloe

A lightweight and high-performance Object/Relational Mapping(ORM) library for .NET --C#
https://github.com/shuxinqin/Chloe/wiki
MIT License
1.52k stars 457 forks source link

原生sql 数据库可以执行(mysql) #308

Closed ImXINCAT closed 2 years ago

ImXINCAT commented 2 years ago

image

SELECT ( @i := @i + 1 ) sort, a.ParentId, COUNT( a.PlayerId ) AS SumPlayerId, COUNT( a.Score >= 20000 OR NULL ) AS ActiveSumPlayerId, SUM( a.Score ) AS SumScore FROM award_statistic a,( SELECT @i := 0 ) t GROUP BY a.ParentId HAVING COUNT( a.PlayerId ) BETWEEN 1 AND 100 ORDER BY SumPlayerId DESC LIMIT 0, 30

ImXINCAT commented 2 years ago

MySqlException: Parameter '@i' must be defined.

shuxinqin commented 2 years ago

这个应该是驱动不支持... 我没这么玩过，我也不知道咋整哦~