var view = (from a in logDB.LoginLog.ToList()
join b in sthxnDB.Sys_User.Select(t => new { t.id, t.Account, t.Name, t.FK_DepId }).ToList() on a.UserId equals b.id into temp1
from t1 in temp1.DefaultIfEmpty()
join c in sthxnDB.Sys_Deps.Select(t => new { t.depId, t.name }).ToList() on **t1.FK_DepId** equals **c.depId.ToString()** into temp2
from t2 in temp2.DefaultIfEmpty()
select new LoginDto
{
Account = t1.Account,
id = t1.id.ToString(),
UserName = t1.Name,
DepName= t2.name
}).ToList();
异常原因:表连接中存在不一致的字段类型
解决方案:将不同类型字段改成如上一致类型即可