请教一个关于Linq的OrderByDescending的问题

名字都被起了 2015-11-30 04:52:59

业务要求是用linq多表查询，并且按照某个表中的某一个字段进行排序



var listItem = from l in db.ListItem

                                   from g in db.Goods

                                   from p in db.gPic

                                   where l.enable == true && l.gid == g.gId && p.gid == g.gId && l.status == 1

                                   orderby l.existingTimes descending

                                   select new

                                   {

                                       existingTime = l.existingTimes,

                                       status = l.status,

                                       desc = g.descString,

                                       priceBase = g.priceBase,

                                       gpic = p.gid,

                                       showPicNum = g.showPicNum,

                                       tag = g.tag,

                                       gname = g.gName,

                                       priceType = g.priceType,

                                       property = g.property,

                                       priceUnit = g.priceUnit,

                                       regularBuyMax = g.regularBuyMax,

                                       price = g.price,

                                       buyUnit = g.buyUnit,

                                       gid = g.gId,

                                       buyable = g.buyAble,

                                       brand = g.brand,

                                       wishSetable = g.wishSetable,

                                       typeId = g.typeId,

                                       limitTime = l.limitTime,

                                       isLimit = l.isLimit,

                                       listIcons = l.listIcons,

                                       period = l.period,

                                       totalPeriod = l.totalPeriod,

                                       //isJoined = l.isJoined

                                   };