ASPNET网站管理工具,用户表或aspnet_Users表格内 [英] Aspnet web site administration tool, Users table or aspnet_users table
问题描述
为什么我的用户和角色在最终的用户的和的角色的表,而不是aspnet_users和aspnet_roles?
当我使用ASPNET网站管理工具(visualstudio->菜单 - >项目 - > ASPNET配置它添加用户表最终用户;在角色表和新的角色
我已经在这个问题看什么说aspnet_users和aspnnet_roles。
我使用aspnetmvc4(测试版),sqlserver2008r2,visualstudio2010。我已通过aspnet_regsql.exe的创建在数据库中aspnet_xxx-表。我闻SQLSERVER并获得对用户和角色的查询。它甚至创建了一个应用程序表。
根据要求,web.config中的部分成员:
<会员defaultProvider =DefaultMembershipProvider>
<供应商>
<清/>
<添加的connectionStringName =DefaultConnectionenablePasswordRetrieval =假
enablePasswordReset设置=真requiresQuestionAndAnswer =假
requiresUniqueEmail =假maxInvalidPasswordAttempts =5
minRequiredPasswordLength =6
minRequiredNonalphanumericCharacters =0passwordAttemptWindow =10
的applicationName =/
NAME =DefaultMembershipProvider
键入=System.Web.Providers.DefaultMembershipProvider,System.Web.Providers,版本= 1.0.0.0,文化=中性公钥= 31bf3856ad364e35/>
< /供应商>
< /会员>
旧校ASP.NET 2.0+提供商( System.Web.XXX.SqlXXXProvider
)结果
- >采用的 ASPNET 的_Users和 ASPNET 的_Roles表,通过存储的特效
新通用提供商( System.Web.Providers.XXX
)结果
- >采用的用户的和的角色的表格,通过(EF-产生的?)SQL
更多信息:
<一href=\"http://www.hanselman.com/blog/IntroducingSystemWebProvidersASPNETUniversalProvidersForSessionMembershipRolesAndUserProfileOnSQLCompactAndSQLAzure.aspx\">http://www.hanselman.com/blog/IntroducingSystemWebProvidersASPNETUniversalProvidersForSessionMembershipRolesAndUserProfileOnSQLCompactAndSQLAzure.aspx
Why do my users and roles end up in Users and Roles tables and not aspnet_users and aspnet_roles?
When I use the Aspnet web site administration tool (visualstudio->menu->project->aspnet configuration to add a user it ends up in the Users table; and new roles in the Roles table.
Everything I have read on the subject says aspnet_users and aspnnet_roles.
I am using aspnetmvc4 (beta), sqlserver2008r2, visualstudio2010. I have created the aspnet_xxx-tables in the database through aspnet_regsql.exe. I sniff sqlserver and get queries against Users and Roles. It even creates an Applications table.
As per request, the membership part of web.config:
<membership defaultProvider="DefaultMembershipProvider">
<providers>
<clear />
<add connectionStringName="DefaultConnection" enablePasswordRetrieval="false"
enablePasswordReset="true" requiresQuestionAndAnswer="false"
requiresUniqueEmail="false" maxInvalidPasswordAttempts="5"
minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
applicationName="/"
name="DefaultMembershipProvider"
type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
</providers>
</membership>
Old school ASP.NET 2.0+ providers (System.Web.XXX.SqlXXXProvider
)
--> Uses the aspnet_Users and aspnet_Roles tables, via stored procs.
The new Universal Providers (System.Web.Providers.XXX
)
--> Uses the Users and Roles tables, via (EF-generated?) SQL.
More info here (from Mr Scott H): http://www.hanselman.com/blog/IntroducingSystemWebProvidersASPNETUniversalProvidersForSessionMembershipRolesAndUserProfileOnSQLCompactAndSQLAzure.aspx
这篇关于ASPNET网站管理工具,用户表或aspnet_Users表格内的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!