search

dotnetcore / FreeSql

🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
http://freesql.net
MIT License
3.99k stars 842 forks source link

WithTempQuery #1782

Open ntzw opened 1 month ago

ntzw commented 1 month ago

问题描述及重现代码：

WithTempQuery 查询时，用子表 Sum 不会赋值，但是在ToListAsync 子查询时会赋值

var withTempQuery = select.WithTempQuery(e => new Model(e)
        {

            DoneScoreCount = _freeSql.Select<Model>().Where(asr => asr.Num == e.Num).Count(),
            ZeroScoreCount = _freeSql.Select<Model>().Where(asr => asr.Num == e.Num && asr.Score <= 0).Count(),
           SelfScore = _freeSql.Select<Model>().Where(asr => asr.Num == e.Num).Sum(asr => asr.Score),

        });

数据库版本

SqlServer

安装的Nuget包

都是最新的 3.2.821

.net framework/. net core？ 及具体版本

.net6

2881099 commented 1 month ago

提供可以运行的demo