ASP.NET会员/角色提供Postgres的？ [英] ASP.NET Membership/Role providers for Postgres?
问题描述
我创建一个MVC网站，并希望使用内置的成员和角色的.NET。
我使用PostgreSQL的（Npgsql）的.NET数据提供程序，但我有麻烦定义成员defaultProvider和PostgreSQL连接字符串连接到我的本地数据库。
谁能帮助？
I am creating an MVC site and would like to use the built in Membership and Roles for .Net. I'm using the the .Net Data Provider for Postgresql (Npgsql), but am having trouble defining the membership defaultProvider and Postgresql connection string to connect to my local database. Can anyone help?
推荐答案
我还没有证实这一点，但将在一期工程很快就会使用它。希望我将有更多的信息来遵循，它会只是工作：）
I have not verified this, but will be using it in a project soon. Hopefully I will have more info to follow, and it will "just work" :)
HTTP：//$c$c.google.com/p/pgsqlprovider/
希望用这个软件堆栈
在Windows Server 2008
PostgreSQL的
PostGIS的
城堡的ActiveRecord
NHibernate的
NHibernate.Spatial
ASP.NET MVC 3与会员/角色提供
Windows Server 2008
PostgreSQL
PostGIS
Castle ActiveRecord
NHibernate
NHibernate.Spatial
ASP.NET MVC 3 with Membership/Role providers
[后续]
我跑的NuGet命令安装封装Nauck.PostgresSQLProvider安装丹尼尔Nauck和Jason Sznol。
I ran the NuGet command "Install-Package Nauck.PostgresSQLProvider" to install the PostgreSQL ASP.NET Membership Provider created by Daniel Nauck and Jason Sznol.
<一个href=\"http://nuget.org/List/Packages/Nauck.PostgresSQLProvider\">http://nuget.org/List/Packages/Nauck.PostgresSQLProvider
项目主页
<一href=\"http://dev.nauck-it.de/projects/aspsqlprovider\">http://dev.nauck-it.de/projects/aspsqlprovider
您需要运行该SQL创建成员表：
<一href=\"http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/changes/src/NauckIT.PostgreSQLProvider/DatabaseSchema.sql\">http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/changes/src/NauckIT.PostgreSQLProvider/DatabaseSchema.sql
You'll need to run this SQL to create the membership tables:
http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/changes/src/NauckIT.PostgreSQLProvider/DatabaseSchema.sql
最后web.config文件将需要更新...我用这个例子的方向：
<一href=\"http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/entry/src/Example/Web.config\">http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/entry/src/Example/Web.config
Finally the web.config file will need to be updated... I used this example for direction:
http://dev.nauck-it.de/projects/aspsqlprovider/repository/revisions/master/entry/src/Example/Web.config
到目前为止认证的作品一样，哈希密码，这就是全部留下来测试授权。
So far authentication works, as does hashed passwords, all thats left to test is authorization.
这篇关于ASP.NET会员/角色提供Postgres的？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
