MVC仓储使用join

代码：

            var result = from mpc in this.Context.Set<Domain.S_MENU_PURVIEWCODE>()

                         join menu in this.Context.Set<Domain.S_MENU>()

                on new { mpc.M_ID }

                equals new { menu.M_ID }

                         select new

                         {

                             mpc.MPC_ID,

                             mpc.MPC_NAME,

                             mpc.MPC_CODE,

                             mpc.MPC_DISABLED,

                             menu.M_NAME,

                             menu.M_CODE

                         };