[SugarColumn(ColumnName = "roles",ColumnDataType = "String",IsJson = true)]
public List<string> roles { get; set; }
这种情况,单表查询,一切正常。能返回一个实体集,当连表查询,直接返回null
var data = bll.Context.Queryable<sys_user, sys_employee>((i, e) =>
new JoinQueryInfos(JoinType.Inner, i.code == e.code))
Select((i, e) => new {
i.roles
})
.ToPageList(pageindex, pagesize, ref count);
以上分页查询,就获取不了数据,最后加上ToString()则正常返回了字符串
roles = i.roles.ToString()