select 的时候 isJson=true,但是查询的数据为null 返回

SqlSugar 沟通中
2 394

public record SysPluginVersionDto : BaseIgnoreIdEntityDto

{

    [SugarColumn(IsJson = true)]

    public object? NodeData { get; set; }


    [SugarColumn(IsJson = true)]

    public object? DependencyData { get; set; }

}

 var list = await _baseRepository.AsQueryable()

            .Where(m => m.PluginIdentifier == identifier)

            .WhereIF(createAt.HasValue, m => m.CreateAt < createAt!.Value)

            .OrderByDescending(m => m.CreateAt)

            .Select<SysPluginVersionDto>(m => new SysPluginVersionDto()

            {

                NodeData = m.NodeData,

                DependencyData = m.DependencyData,

            })

            .ToListAsync();

        return list;

为什么查询到的 (NodeData 和 DependencyData) 都是null,已经在Dto中加了 IsJson = true 了


下面这是实体就能查询到


public class SysPluginVersion : VinAuthFrameworkBaseEntity

{

    [SugarColumn(IsJson = true, ColumnDescription = "节点数据")]

    public object? NodeData { get; set; }


    [SugarColumn(IsJson = true, ColumnDescription = "依赖数据")]

    public object? DependencyData { get; set; }

}


var list = await _baseRepository.AsQueryable()

            .Where(m => m.PluginIdentifier == identifier)

            .WhereIF(createAt.HasValue, m => m.CreateAt < createAt!.Value)

            .OrderByDescending(m => m.CreateAt)

            .ToListAsync();

        return list;




热忱回答2