Working with ADO.NET - Universal Database Access for mono
Contents
I. Supported Databases
While Microsoft ships ADO.NET providers for MS SQL Server, SqlXML, OLE DB and - since 1.1 -
ODBC and Oracle in the namespace System.Data, Mono is far ahead MS here. Besides the
providers in System.Data, in the namespace Mono.Data currently holds providers for:
- Postgres
- MySQL
- SqlLite
- Sybase
- TDS Generic
Mono's OLE DB implementation, based on LibGDA, has additonally support for (and others already listed):
- Interbase
- IBM DB2
- MS Access
If your favorite Database is not listed here, on Unix Systems unixodbc can handle these (and others already listed)
with appropriate Drivers:
- Easysoft ODBC-ODBC Bridge
- StarSQL
- Informix
- AdabasD
- Empress
- miniSQL
- SQI
- miniSQL
- News Server
- YARD SQL
- RDBMS Linter SQL
- Ovrimos Webbase
- Mimer SQL
- Ingres
- SAPdb
Also more providers are planned:
- DB2 (directly)
- miniSQL
- SapDB
- BerkeleyDB
- Firebird/Interbase
7 Databases direct and 18 indirect should be enough for all your database needs.
Some of these providers require native libaries, but most will be pure C#, as development goes on.
All providers share a common interface, so it's relatively easy to port from one DB to
another.
[TODO]
A. Credits
Authors: Johannes Roith (johannes@jroith.de)
