.net mvc 中如何多表查询数据

[qq_23172683]

   Strong.IBLL.ISysUserService _userService = new SysUserService();
  public ActionResult GetAllUserInfos()
        {
            int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
            int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
            var userInfo = new UserInfoQuery()
            {
                PageIndex = pageIndex,
                PageSize = pageSize,
                Total = 0,
                IsEanble = true
            };
            var data = from u in _userService.LoadSearchData(userInfo)
                       select new
                       {
                           u.UserId,
                           u.UserName,
                           u.PassWord,
                           u.CreateDate,
                           u.CreatePerson,
                           u.UpdateDate,
                           u.UpdatePerson,
                           u.IsEnable,
                           u.SortNum,
                           u.Description
                       };

            var result = new { total = userInfo.Total, rows = data };
            return Json(result);
        }

这样查询的是一个用户表，但是我还想和角色表关联起来请问如何去写呢？

[Justin-Liu]

查查linq多表查询

[q107770540]

 var data = from u in _userService.LoadSearchData(userInfo)
            join r in _userService.Roles on u.roleId equals r.Id
                       select new
                       {
                           r.RoleName,
                           u.UserId,
                           u.UserName,
                           u.PassWord,
                           u.CreateDate,
                           u.CreatePerson,
                           u.UpdateDate,
                           u.UpdatePerson,
                           u.IsEnable,
                           u.SortNum,
                           u.Description
                       };
 

[蝶恋花雨]

var data = (from u in _userService.LoadSearchData(userInfo)
            join r in _userService.Roles on u.roleId equals r.Id
                       select new UserInfo
                       {
                          RoleName= r.RoleName,
                          UserId= u.UserId,
                           SortNum=u.SortNum,
                          Description= u.Description
                       }).ToList<UserInfo>();
                       
                       public class UserInfo
                      {
                        public string RoleName{get;set;}
                        /////
                      }

[蝶恋花雨]

var data = (from u in _userService.LoadSearchData(userInfo)
            join r in _userService.Roles on u.roleId equals r.Id
                       select new UserInfo
                       {
                           r.RoleName,
                           u.UserId,
                           u.SortNum,
                           u.Description
                       }).ToList<UserInfo>();
                       
                       public class UserInfo
                      {
                        public string RoleName{get;set;}
                        /////
                      }

[xiaoqiu_net]

linq多表啊， form x in xtab join y in ytab select new { 取属性(x.xxxx,y.xxx) }

[qq_23172683]

引用 2 楼 q107770540 的回复:

 var data = from u in _userService.LoadSearchData(userInfo)
            join r in _userService.Roles on u.roleId equals r.Id
                       select new
                       {
                           r.RoleName,
                           u.UserId,
                           u.UserName,
                           u.PassWord,
                           u.CreateDate,
                           u.CreatePerson,
                           u.UpdateDate,
                           u.UpdatePerson,
                           u.IsEnable,
                           u.SortNum,
                           u.Description
                       };
 

谢谢了，解决了我的问题

[threenewbee]

引用 6 楼 qq_23172683 的回复:

[quote=引用 2 楼 q107770540 的回复:]

 var data = from u in _userService.LoadSearchData(userInfo)
            join r in _userService.Roles on u.roleId equals r.Id
                       select new
                       {
                           r.RoleName,
                           u.UserId,
                           u.UserName,
                           u.PassWord,
                           u.CreateDate,
                           u.CreatePerson,
                           u.UpdateDate,
                           u.UpdatePerson,
                           u.IsEnable,
                           u.SortNum,
                           u.Description
                       };
 

谢谢了，解决了我的问题[/quote] 督察的答案完全正确。解决了就及时结贴吧。

[hsl_44]

都没有用Linq和Lamda表达式写的吗？

[qq_15148111]

db.用户表.AsEnumerable().join(db.角色表,a=>a.角色编号,b=>b.角色编号,(a,b)=>new{a,b}).select(item=>new{ jueId=item.b.角色编号 }).tolist();