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

[Jimoyun]

问题描述及重现代码：

    var list = Db.Select<Base_UserInfo, Base_StaffOrganize>()
.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]

[Jimoyun]

.net framework 4.5

[2881099]

N'''ba826945-8012-486d-a243-6a34a314bb16'''

你这是 nvarchar 啊，里面还多了一对单引号