aspnet_regsql - Creating the Application Services Database for mysql or postgresql database

I know that it is possible (and straightforward) to create an application services database using a SQL Server database. However, I would like to use another database technology such as MySQL or PostgreSQL for my authentication/role management. I was wondering if there is a similar comma开发者_如何学Gond to do so for non-mssql databases or if there is a commonly used workaround for doing so?

The aspnet_regsql program can only create database objects for membership and role management for Microsoft SQL Server databases.

That said it is possible to create your own structures for other database tables and implement your own membership and role provider types (or use someone else's implementations).

For MySQL the Connector/Net looks like the best way to go. A search leads to a blog post about how to use and configure it. Alternatively you could implement your own, but I would recommend going with the Connector/Net.

I don't have any experience with PostgreSQL but I'd be surprised if there wasn't an existing provider out there. Again, you could implement your own if needed.