iBatis.net查询问题

使用iBatis.net开发时遇到一个问题,用下面的联合查询语句得到的结果在存入实体类中时,会出现最后一个字段值为空的现象

SELECT dic.Id,dic.FatherId,dic.DataName,dic.Code,dic.SortingNumber,
      dic.IsAvailable,dic.Remark,dic.Createuser,dic.CreateTime,us.u_LoginName
FROM dbo.DataDictionary as dic
INNER JOIN dbo.sys_User as us
ON dic.Createuser=us.UserID

猜测可能是字段名称的问题,在将实体类中字段的名字改为u_LoginName无果之后,尝试给字段加个别名之后解决

SELECT dic.Id,dic.FatherId,dic.DataName,dic.Code,dic.SortingNumber,
      dic.IsAvailable,dic.Remark,dic.Createuser,dic.CreateTime,us.u_LoginName as LoginName
FROM dbo.DataDictionary as dic
INNER JOIN dbo.sys_User as us
ON dic.Createuser=us.UserID