EntLib Security module and Microsoft Access database

Topics: Security Application Block
Jul 28, 2008 at 2:38 PM
Hello All
   Does Enterprise Library works with Microsoft Access database and store users and roles? Or EntLib can work only with MS SQL?
Thanks
Jul 28, 2008 at 10:46 PM
Hi,

Starting with v2.0, EntLib no longer provides the Membership and Role services; these services are now provided by ASP.NET's Membership and Roles classes. The database implementations of ASP.NET's providers work only with MS SQL Server, but there are code samples for ODBC providers you could probably use to store your information in an access database like http://msdn.microsoft.com/en-us/library/44w5aswa.aspx.

Hope this helps,
Fernando
Jul 28, 2008 at 11:09 PM
And a minor addition, just like the ASP.NET cache, the Membership and Role providers can be used in any application, not just a web app.