dotnetcore / dotnetcore/FreeSql

ID为GUID时 sql查询转换有问题 导致数据查询不到

Open
#2,190 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

#### 问题描述及重现代码:

```c#
var list = Db.Select()
.LeftJoin((a, b) => a.User_ID == b.User_ID)
.Where((a, b) => a.DeleteMark != 0)
.WhereIf(!string.IsNullOrEmpty(OrgID), (a, b) => b.Organization_ID == OrgID)
.WhereDynamicFilter(expression)
.GroupBy((a, b) => new { a.User_ID, a.User_Code, a.User_Name, a.User_Account, a.User_Sex, a.DeleteMark, a.User_Remark, a.CreateDate })
.Count(out var total) //总记录数量
.Page(pageIndex, pageSize)
.ToList(c => new Base_UserInfo
{
User_ID = c.Key.User_ID,
User_Code = c.Key.User_Code,
User_Name = c.Key.User_Name,
User_Account = c.Key.User_Account,
User_Sex = c.Key.User_Sex,
DeleteMark = c.Key.DeleteMark,
User_Remark = c.Key.User_Remark,
CreateDate = c.Key.CreateDate
});
```

#### 数据库版本
sqlserver2019

#### 安装的Nuget包
3.5.305.0

#### .net framework/. net core? 及具体版本
转换sql 错误

SELECT TOP 15 a.[User_ID] as1, a.[User_Code] as2, a.[User_Name] as3, a.[User_Account] as4, a.[User_Sex] as5, a.[DeleteMark] as6, a.[User_Remark] as7, a.[CreateDate] as8
FROM [Base_UserInfo] a
LEFT JOIN [Base_StaffOrganize] b ON a.[User_ID] = b.[User_ID]
WHERE (a.[DeleteMark] <> 0) AND (b.[Organization_ID] = N'''ba826945-8012-486d-a243-6a34a314bb16''')
GROUP BY a.[User_ID], a.[User_Code], a.[User_Name], a.[User_Account], a.[User_Sex], a.[DeleteMark], a.[User_Remark], a.[CreateDate]

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.