public List <TbGuestBook> GetData() { var query = from gb in ctx.TbGuestBook orderby gb.PostTime descending select gb; return query.ToList(); } 这是一个用LinQ查询单个表的方法,这个查询没有问题,返回的结果是List <TbGuestBook>。
现在我要在两个表中组合查询 var query = from user in ctx.User join userCard in ctx.CardUser on user.ID equals userCard.UserId into ords from o in ords.DefaultIfEmpty() orderby user.ID descending select new {user, o};