LINQ

 public ActionResult TestLinq()
        {
            // 内连接
            var resUser = from user in db.UserInfor
                          join answer in db.Answer on user.ID equals answer.UserInforID
                          where user.ID > 10 && user.ID < 20
                          select new { user.ID, user.UName, answer.AnswerDespression };

            //外连接
            var resUserLeftOut = from user in db.UserInfor
                                 join answer in db.Answer on user.ID equals answer.UserInforID into a
                                 from answerRes in a.DefaultIfEmpty()
                                 where user.ID > 10 && user.ID < 20
                                 select new { user.ID, user.UName, answerRes.AnswerDespression };


            var resLinq = from u in db.UserInfor
                          select u;

            var resLambda = db.UserInfor.Where(u => u.ID > 10 && u.ID < 20)
                .Select(u => new { u.ID, u.UName, u.UPassword });
            return View();
        }