I wanted save some people some time looking for providers for their non-Microsoft databases to use with .NET. Please keep in mine I have not tried or used all of these providers / tools but have found them from searching and asking around. Based on some of the feed back and comments I added a few others.
Oracle
Oracle's .NET center can be found here: http://www.oracle.com/technology/tech/dotnet/index.html
Oracle 64bit ODAC drivers can be found here: http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html
Very helpful for Oracle development and integrates directing into Visual Studio. Oracle Developer Tools for Visual Studio .NET: http://www.oracle.com/technology/tech/dotnet/tools/index.html
Oracle ASP.NET Data Providers: http://www.oracle.com/technology/tech/dotnet/aspnet/
MySQL
MySQL ADO.NET Driver (Connector/NET): http://dev.mysql.com/downloads/connector/net/
Step by Step Guide for using MySQL with ASP.NET: http://www.15seconds.com/issue/050407.htm
MySQLRoleProvider: http://www.codeproject.com/aspnet/MySQLsuite.asp
SQLite 3
SQlite3 .NET Provider: http://sourceforge.net/projects/sqlite-dotnet2
SQLite ASP.NET Membership Provider: http://www.codeproject.com/useritems/SQLiteProviders.asp
SQLite 2007 Pro Enterprise Manager is a free GUI (Graphical User Interface) for working with SQLite database. I have used it's predecessor and found it quite helpful. http://www.osenxpsuite.net/?xp=3
NHibernate
Sort of a repost but I wanted to group them together
NHibernate Data Layer Generation :http://sourceforge.net/projects/nhib-gen/
This project is hosted on SourceForge. This project requires CodeSmith to generate the code. The project generates, C# classes for business layer, data layer, and DataSources. In addition, these templates will generate some based Insert, Update, Delete ASP.NET pages.
NHibernateDataSource: http://www.codeproject.com/useritems/NHibernateDataSource.asp
PostgreSQL
I did not find and Membership or Role providers but here are some ADO drivers.
Courtesy of Loser-X
Npgsql is de facto the ADO.NET provider. Performance and stability seems alright.
PostgreSQLDirect .NET is a commercial provider, and its supposed to out-perform Npgsql while providing more features.
Firebird
I did not find and Membership or Role providers but here are some ADO drivers.
Courtesy of Loser-X
In any case, the .NET data provider is available for download, as well as a DDEX provider.
Sybase
I did not find and Membership or Role providers but here are some ADO drivers.
Updating the ASE ADO.NET Provider
Developing a Data Access Layer for Sybase Using ADO.NET: Essentials
浙公网安备 33010602011771号