目录
多表查询
var list = from u in _context.Users
join c in _context.UserCharacters on u.Id equals c.UserId
join t in _context.CharacterTypes on c.CharacterTypeId equals t.Id
where c.CharacterTypeId == 0 && u.Username == "1"
orderby u.Id descending
select new
{
username = u.Username,
characterTypeName = t.Name
};
分组查询
var result = (from u in _context.Users
group u by u.Username into g
select new
{
username = g.Key,
count = g.Count(),
message="this is message"
}
);