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

Posted: Oct 09 2007, 10:59 AM by jguadagno | with 9 comment(s)
Filed under: , , , , , , , , , ,

Comments

rrobbins said:

I've used MySQL with ASP and ASP.NET when the client could not afford SQL Server hosting fees. Watch out for the MM/DD/YYYY date format which is not supported in queries.

You should also be concerned about SQL Injection attacks because you do not have the PHP functions mysql_real_escape_string() or addslashes() to sanitize user input.

# October 9, 2007 1:31 PM

microsoft » Database Drivers not provided by Microsoft said:

Pingback from  microsoft » Database Drivers not provided by Microsoft

# October 9, 2007 1:56 PM

DotNetKicks.com said:

You've been kicked (a good thing) - Trackback from DotNetKicks.com

# October 9, 2007 2:27 PM

Loser-X said:

Nice post by Joseph Guadagno about database drivers not provided by Microsoft . He missed a few though

# October 9, 2007 3:34 PM

Sachman Bhatti said:

PostgreSQL:

Npgsql, a PostgreSQL ADO.NET driver: npgsql.projects.postgresql.org

# October 11, 2007 12:27 PM

LaptopHeaven said:

I have been looking for Sybase .NET drivers.  It seems Sybase keeps a tight lock on their drivers. Has anyone found a place for Sybase .NET/ADO.NET drivers?

# October 11, 2007 12:35 PM

Loser-X said:

Membership and Role providers for Postgres:

blog.woodchop.com/.../postgresql-membership-provider-for.html

The official .NET provider for Firebird includes Membership, Role and Profile providers.

# October 11, 2007 3:30 PM

Nick Hodges said:

CodeGear's RAD Studio includes an ASP.NET provider implementation that will hook to any of our nine dbExpress drivers, including Interbase, Oracle, and SQL Server.

# October 11, 2007 6:48 PM

Technical Related Notes » Blog Archive » links for 2007-10-12 said:

Pingback from  Technical Related Notes  » Blog Archive   » links for 2007-10-12

# January 11, 2009 7:55 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)