阅读背景:

LINQ,EF联合查询join

来源:互联网 
public object GetListAdmin()
        {
            //return db_C56.Admins
            //   .Where(a => a.Status != "D").ToList();

            var query1 = db_C56.Admins.Join(db_C56.Area, a => a.AreaID, ar => ar.ID, (a, ar) => new
            {
                userName = a.UserName,
                pwd = a.Password,
                dName = a.DisplayName,
                areaId = a.AreaID,
                hasNode = a.HasNode,
                roleName = a.RoleName,
                status = a.Status,
                areaName = ar.Name
            });

            var query = from a in db_C56.Admins
                        join ar in db_C56.Area
                        on a.AreaID equals ar.ID
                        where a.Status != "D"
                        select new
                        {
                            userName = a.UserName,
                            pwd = a.Password,
                            dName = a.DisplayName,
                            areaId = a.AreaID,
                            hasNode = a.HasNode,
                            roleName = a.RoleName,
                            status = a.Status,
                            areaName = ar.Name
                        };
            return query.ToList().Select(C => new Admin
            {
                UserName = C.userName,
                Password = C.pwd,
                DisplayName = C.dName,
                AreaID = C.areaId,
                AreaPath = C.areaName,
                HasNode = C.hasNode,
                RoleName = C.roleName,
                Status = C.status,
            });
        }public object GetListAdmin()
        {
        



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: