User roles

userroles.cs

 [Route("api/user/roles")]
        public IActionResult UserRoles()
        {
            var q1 = from userRole in _shopDbContext.UserRoles
                     join role in _shopDbContext.Roles on userRole.RoleId equals role.Id
                     join user in _shopDbContext.Users on userRole.UserId equals user.Id
                     select new
                     {
                         user.Id,
                         user.FirstName,
                         user.LastName,
                         role.Name
                     };

            return Ok(q1);
        }