azure - When I use the Roles object I get an error of "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'" -

azure - When I use the Roles object I get an error of "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'" -

so, have been searching on net solution. i've done lot of research , has left me more lost. creating mvc 5 site azure , having problem setting role management.

when utilize roles object error of "could not find stored procedure 'dbo.aspnet_checkschemaversion'" found this link don't know how apply azure.

my web.config file set this.

<add name="roledb" connectionstring="data source=(localdb)\v11.0;attachdbfilename=|datadirectory|\techdb3.mdf;integrated security=true" providername="system.data.sqlclient" /> <rolemanager enabled="true"> <providers> <clear/> <add connectionstringname="roledb" name="aspnetsqlroleprovider" type="system.web.security.sqlroleprovider" applicationname="techandgames" /> </providers> </rolemanager>

for mvc 5, need remove rolemanager tag, think. using <rolemanager> in latest mvc 5 application , getting exact same error you. removed it, error went away. think because mvc uses different role management approach.

a couple of other things: create sure have proper tables setup in database. these tables need:

_migrationhistory aspnetroles aspnetuserclaims aspnetuserlogins aspnetuserroles aspnetusers

you may not need of these, depending on doing. these setup properly, (1) created new project mvc 5 template, (2) ran project locally (3) went through registration process of new user on site , (4) looked in local sql server (localdb)\v11.0 , had created database there tables mention above. scripted tables out , ran scripts against real database.

then, in application should able phone call user , access methods user.isinrole("somerole");.

azure asp.net-mvc-5 roleprovider