Last post May 18, 2009 07:26 PM by kderacing
May 18, 2009 07:26 PM|kderacing|LINK
I had been working on a series of universal (any database) providers and decided to open source them. They are available at google code
These providers work with the built in 2.0 controls for login, password recovery, and other options. They use what I called database groups which are ways to identify where a series of providers will read/write their data. This allows you to split providers
up or use multiple MSAccess databases to avoid storage limitations. Since they are universal, you can migrate databases from one type to another then simply change the web.config file and have it work seemlessly with the same code base. This is based on the
data access classes I wrote which follow the factory pattern to select different database types and create the correct data classes from there.
Not all of them are done, and I don't have much time to continue this work so if someone is interested in taking it further please contact me from the site.
You will need the MySQL.dll that comes from the MySQL web site under the .NET providers section but the source includes a sample web application that shows how to use these providers in a real world scenario.