ef Linq 自定义字段列表

这里需要联合查询，然后需要重新组合新的字段，应为不想新鞋一个model。因为这样破坏了Model机制的完整性，另外用Ef重新生成的时候，害怕这点会忘记。于是就想单独的一个页面解决。

 代码如下：

            List<ExpandoObject> alist = new List<ExpandoObject>();
            var post = (from a in db.LIHANG_Apply_Class
                        join s in db.LIHANG_Student on a.Sno equals s.Sno
                        orderby
                          a.id descending
                        select new
                        {
                            id = a.id,
                            Service_Num = a.Service_Num,
                            Sno = a.Sno,
                            Reg_Class = a.Reg_Class,
                            Reg_Remark = a.Reg_Remark,
                            Total_Receive = a.Total_Receive,
                            Pay_Method = a.Pay_Method,
                            Agent = a.Agent,
                            Report_Reg = a.Report_Reg,
                            State = a.State,
                            Paid_Money = a.Paid_Money,
                            Reg_Time = a.Reg_Time,
                            Charge_Type = a.Charge_Type,
                            Card_Money = a.Card_Money,
                            Stu_Start_Time = a.Stu_Start_Time,
                            Stu_End_Time = a.Stu_End_Time,
                            Period_Part = a.Period_Part,
                            Total_Course = a.Total_Course,
                            Approver = a.Approver,
                            Mobile = s.Mobile,
                            Sname = s.Sname,
                            Campus = a.Service_Num
                        }).ToList();
            foreach (var item in post)
            {
                dynamic dc = new ExpandoObject();
                dc.id = item.id;
                dc.Service_Num = item.Service_Num;
                dc.Sno = item.Sno;
                dc.Reg_Class = item.Reg_Class;
                dc.Reg_Remark = item.Reg_Remark;
                dc.Total_Receive = item.Total_Receive;
                dc.Pay_Method = item.Pay_Method;
                dc.Agent = item.Agent;
                dc.Report_Reg = item.Report_Reg;
                dc.State = item.State;
                dc.Paid_Money = item.Paid_Money;
                dc.Reg_Time = item.Reg_Time;
                dc.Charge_Type = item.Charge_Type;
                dc.Card_Money = item.Card_Money;
                dc.Stu_Start_Time = item.Stu_Start_Time;
                dc.Stu_End_Time = item.Stu_End_Time;
                dc.Period_Part = item.Period_Part;
                dc.Total_Course = item.Total_Course;
                dc.Approver = item.Approver;
                dc.Mobile = item.Mobile;
                dc.Sname = item.Sname;
                dc.Campus = item.Campus;
                alist.Add(dc);
            }


            ViewData["List"] = alist;