问个LINQ排序问题

   var query = (from a in db.BANK_FIN_PRD
                         join b in db.BANK_FIN_DETAIL
                         on a.INNER_CODE equals b.INNER_CODE
                         where SqlMethods.Like(a.PRD_NAME, "%" + ProName + "%")
                          select new MulTable
                         {
                             Proid = a.INNER_CODE.ToString(),
                             ProName = a.PRD_NAME,
                             ProPrice = b.ENTR_MIN_CURNCY.ToString(),
                             ProLicai = b.INC_DATE.ToString(),
                         }
                         );

            List<MulTable> list = query.Take(takes).Skip(skips).ToList();

            return list;

这个是我写的一个查询。现在要根据INNER_CODE PRD_NAME  这几个字段进行动态升序降序。。求大神们指点。 linq --------------------编程问答-------------------- order by new{INNER_CODE=a.INNER_CODE,PRD_NAME=a.PRD_NAME}

--------------------编程问答--------------------

 var query = (from a in db.BANK_FIN_PRD

                          join b in db.BANK_FIN_DETAIL

                          on a.INNER_CODE equals b.INNER_CODE

                          where SqlMethods.Like(a.PRD_NAME, "%" + ProName + "%")

                          orderby  a.INNER_CODE descending,a.PRD_NAME ascending

                           select new MulTable

                          {

                              Proid = a.INNER_CODE.ToString(),

                              ProName = a.PRD_NAME,

                              ProPrice = b.ENTR_MIN_CURNCY.ToString(),

                              ProLicai = b.INC_DATE.ToString(),

                          }

                          );

--------------------编程问答-------------------- 你要是动态升序或降序，估计得加if条件了 --------------------编程问答--------------------

引用 2 楼 q107770540 的回复:

C# code?12345678910111213 var query = (from a in db.BANK_FIN_PRD join b in db.BANK_FIN_DETAIL on a.INNER_CODE equals b.INNER_CODE ……

楼上正解 --------------------编程问答-------------------- 反正是延迟查询，可以用if 判断。

补充：.NET技术 ,  LINQ