sqlsugar 使用了 SqlFunc.Like(x.Mh002, "%*")，转换为sql语句后携带了N导致数据查询 返回
中律十六C 发布于2025/1/9
var output = await _sqlSugarClient.Queryable<CmsmhEntity>()
.Where(x => x.Mh001 == "1" && x.Mh002.StartsWith(mh002) && SqlFunc.Like(x.Mh002, "%*"))
.Select(x => new CmsmhListOutput
{
id = x.Mh005,
fullName = x.Mh004
}, true)
.OrderBy("MH002 ASC")
.ToListAsync();
SELECT [MH005] AS [id] , [MH004] AS [fullName] ,[CREATE_DATE] AS [CreateDate] ,[MH001] AS [Mh001] ,[MH002] AS [Mh002] ,[MH003] AS [Mh003] ,[MH004] AS [Mh004] ,[MH005] AS [Mh005] ,[MH006] AS [Mh006] ,[MH007] AS [Mh007] ,[MH013] AS [Mh013] ,[MH014] AS [Mh014] ,[MH016] AS [Mh016] ,[MH017] AS [Mh017] ,[MH018] AS [Mh018] ,[MH019] AS [Mh019] ,[MH020] AS [Mh020] ,[MH021] AS [Mh021] ,[MH022] AS [Mh022] ,[MH023] AS [Mh023] ,[MH024] AS [Mh024] FROM [CMSMH] WHERE ((( [MH001] = N'1' ) AND ([MH002] like N'A'+'%') ) AND ([MH002] like N'%*' ) )ORDER BY MH002 ASC
热忱回答（4）
-
fate sta VIP0
2025/1/9SqlFunc.Like(x.Mh002, sqlfunc.ToVarchar( "%*") )
这样试试
0 回复 -
fate sta VIP0
2025/1/9
如果没有Nvarchar也可以全局禁用
0 回复 -
fate sta VIP0
2025/1/9
moresetting里面
0 回复 -
中律十六C VIP0
2025/1/9
@fate sta：
可以，谢谢老师0 回复