azure - When I use the Roles object I get an error of "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'" -
So, I'm searching on the Internet for a solution. I've done a lot of research and it only lags me more Have given. I'm building an MVC 5 site for Azure and I'm having trouble setting up Roll Management.
When I use Roll object, I can not find the "stored procedure" dbo.aspnet_CheckSchemaVersion '
add Name = " RoleDB" connectionString = "data source = (locali) \ v11.0; AttachDbFilename = | Data directory \ Techdb3.mdf; Integrated Security = True "Provider Name =" System.Data.SqlClient "/> & gt; RoleManager enabled =" True "& gt; & lt; Providers & gt; & lt; clear / & gt; & lt; Connection Add StringName = "RoleDB" name = "AspNetSqlRoleProvider" type = "System.Web.Security.SqlRoleProvider" applicationName = "TechAndGames" /> MVC 5 You must remove roleManager .
Some other things: Make sure your database Here are the tables you will need:
- _MigrationHistory
- AspenRalal
- ASPNet User Claim
- ASPNTUser Logs
- AspNetUserRoles
- AspNetUsers
All of these Vshykta can not be, you're doing on the ground. To get these installations properly, I (1) created a new project with the MVC 5 template, (2) locally run the project (3) went through the process of registering a new user on the site And (4) a database was created with my local SQL server (localbd) \ v11.0 and all the tables mentioned above, I then scripted those tables and copied the scripts against my real database. Sing
Then, in your application, you should be able to call the user and access the methods like User.IsInRole ("someRole"); .
Comments
Post a Comment