title: Roles.GetRolesForUser() & Roles.GetAllRoles() returns empty
body: <p>web.config</p>
  
  <pre><code>&lt;roleManager enabled="true" defaultProvider="SqlRoleManager"&gt;
    &lt;providers&gt;
      &lt;clear /&gt;
      &lt;add name="SqlRoleManager"
           type="System.Web.Security.SqlRoleProvider"
           connectionStringName="DefaultConnection"
           /&gt;
    &lt;/providers&gt;
  &lt;/roleManager&gt;
  </code></pre>
  
  <p>in asp.net mvc 5, i'm trying to detect the role of the current user so i can redirect him to a page specific to it's role but</p>
  
  <p>in my controller</p>
  
  <pre><code>if (Roles.IsUserInRole(User.Identity.GetUserName(), "superadmin")
  </code></pre>
  
  <p>or</p>
  
  <pre><code>if (Roles.IsUserInRole(User.Identity.Name, "superadmin")
  </code></pre>
  
  <p>the both are not true, i'm sure that i'm logged bec <code>User.Identity.GetUserName()</code> is displaying my login</p>
  
  <p>Trying to debug, i found that <code>Roles.GetRolesForUser()</code> is empty, i've checked online resources but still no solution</p>
  
  <p>Further debugging shows that <code>Roles.GetAllRoles()</code> is also empty, but my AspNetRoles table has 5 records.</p>
  
  <p>I've looked at AspNetUserRoles and i found my current User id assigned to specific role id</p>
  
  <p>and i've successfully run <code>aspnet_regsql.exe</code> to add all features but still cannot get the Roles</p>
  
  <p>i think <code>aspnet_regsql.exe</code> is for web forms (i'm not sure)</p>