Database Drivers not provided by Microsoft (Updated)

jguadagno — Tue, 09 Oct 2007 16:59:00 GMT

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