I am attempting to set up the role provider for MVC 5 but I can not get any calls on the Roles object to work. I receive the exception "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion". The RoleManager object and User.IsInRole calls
work just fine but I have no luck with the Roles object.
Roles.GetRolesForUser(UserName)
I have added these settings to the web.config
<add name="SqlRoleManagerConnection" connectionString="Data Source= (LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\Techdb3.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />
<roleManager enabled="true" defaultProvider="SqlRoleManager">
<providers>
<add name="SqlRoleManager"
type="System.Web.Security.SqlRoleProvider"
connectionStringName=&quo ...
Go to the complete details ...