title: ASP.NET Core MVC - starts to query database, then stops with no errors
body: <p>I have a simple project, and I am a little new. All I am trying to do is with a brand new project list the users and roles in the system. I have already created my <code>ApplicationUser</code> model and logins using the scaffolding.</p>
  <p>Now I am trying create a controller with a model and view. However it seems to start to query the database, then just stops with no information... Has anyone seen this? Can you point me in the right direction possibly?</p>
  <p>I seem to have gotten stuck and do not have enough experience to figure this one out.</p>
  <p>Controller</p>
  <pre><code>public class UserRolesController : Controller
  {
      private readonly UserManager&lt;ApplicationUser&gt; _userManager;
      //private readonly RoleManager&lt;IdentityRole&gt; _roleManager;
  
      public UserRolesController(UserManager&lt;ApplicationUser&gt; userManager/*, RoleManager&lt;IdentityRole&gt; roleManager*/)
      {
          //_roleManager = roleManager;
          _userManager = userManager;
      }
  
      public async Task&lt;IActionResult&gt; Administration()
      {
          var users = await _userManager.Users.ToListAsync();
  
          var userRolesViewModel = new List&lt;UserRolesViewModel&gt;();
  
          foreach (ApplicationUser user in users)
          {
              var thisViewModel = new UserRolesViewModel();
              thisViewModel.UserId = user.Id;
              thisViewModel.FullName = user.FullName;
              thisViewModel.Email = user.Email;
              //thisViewModel.FirstName = user.FirstName;
              //thisViewModel.LastName = user.LastName;
              //thisViewModel.Roles = await GetUserRoles(user);
  
              userRolesViewModel.Add(thisViewModel);
          }
  
          return View(userRolesViewModel);
      }
  }
  </code></pre>
  <p>Debug log:</p>
  <blockquote>
  <p>'dotnet.exe' (CoreCLR: clrhost): Loaded 'C:\Program Files\dotnet\shared\Microsoft.NETCore.App\6.0.1\System.Diagnostics.Process.dll'.<br />
  Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. The thread 0x6e4 has exited with code 0 (0x0).</p>
  <p>{&quot;EventId&quot;: 20101, &quot;LogLevel&quot;: &quot;Information&quot;, &quot;Category&quot;: &quot;Microsoft.EntityFrameworkCore.Database.Command&quot;, &quot;Message&quot;:&quot;Executed DbCommand (49ms) [Parameters=[], CommandType=\u0027Text\u0027, CommandTimeout=\u002730\u0027]\r\nSELECT [a].[Id], [a].[AccessFailedCount], [a].[BirthDate], [a].[ConcurrencyStamp], [a].[Email], [a].[EmailConfirmed], [a].[FullName], [a].[JobDescription], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName]\r\nFROM [AspNetUsers] AS [a]&quot;,&quot;State&quot;:{&quot;Message&quot;:&quot;Executed DbCommand (49ms) [Parameters=[], CommandType=\u0027Text\u0027, CommandTimeout=\u002730\u0027]\r\nSELECT [a].[Id], [a].[AccessFailedCount], [a].[BirthDate], [a].[ConcurrencyStamp], [a].[Email], [a].[EmailConfirmed], [a].[FullName], [a].[JobDescription], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName]\r\nFROM [AspNetUsers] AS [a]&quot;, &quot;elapsed&quot;:&quot;49&quot;, &quot;parameters&quot;:&quot;&quot;, &quot;commandType&quot;:&quot;Text&quot;, &quot;commandTimeout&quot;:30, &quot;newLine&quot;:&quot;<br />
  &quot;commandText&quot;:&quot;SELECT [a].[Id], [a].[AccessFailedCount], [a].[BirthDate], [a].[ConcurrencyStamp], [a].[Email], [a].[EmailConfirmed], [a].[FullName], [a].[JobDescription], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName] FROM [AspNetUsers] AS [a]&quot;,&quot;{OriginalFormat}&quot;:&quot;Executed DbCommand ({elapsed}ms) [Parameters=[{parameters}], CommandType=\u0027{commandType}\u0027, CommandTimeout=\u0027{commandTimeout}\u0027]{newLine}{commandText}&quot;}}   Microsoft.EntityFrameworkCore.Database.Command: Information: Executed DbCommand (49ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccessFailedCount], [a].[BirthDate], [a].[ConcurrencyStamp], [a].[Email], [a].[EmailConfirmed], [a].[FullName], [a].[JobDescription], [a].[LockoutEnabled], [a].[LockoutEnd], [a].[NormalizedEmail], [a].[NormalizedUserName], [a].[PasswordHash], [a].[PhoneNumber], [a].[PhoneNumberConfirmed], [a].[SecurityStamp], [a].[TwoFactorEnabled], [a].[UserName] FROM [AspNetUsers] AS [a]<br />
  The thread 0x6cc has exited with code 0 (0x0).</p>
  </blockquote>