Joseph Guadagno

Rants, Raves and other stuff about ASP.NET development.

Database Drivers not provided by Microsoft (Updated)

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

Sybase support for ADO.NET 

Developing a Data Access Layer for Sybase Using ADO.NET: Essentials

Comments

No Comments