Database Access
Mono has many ADO.NET Data Providers to get you connected. Find the database you want to connect to and follow the link for instructions on how to set it up, as well as sample code for accessing the database.
Providers for Open Source databases:
- PostgreSQL: Npgsql is a managed provider for PostgreSQL
- SQLite: provider for SQLite versions 2 and 3. Requires native sqlite library.
- Firebird: managed provider for Firebird
- MySQL: MySQL Connector/Net is the recommended provider for MySQL from MySQL. ByteFX.Data.MySqlClient is no longer maintained.
Providers for commercial databases:
- Mimer SQL Mimer Data Provider for Mimer SQL, from Mimer [1]
- ODBC requires ODBC software which is available for Unix and Windows
- Oracle provider for Oracle 8i, 9i, 10g, and 11g and requires Oracle client software
- Microsoft SQL Server managed provider for Microsoft SQL Server 7.0, 2000, 2005 and 2008 databases
Commercially Supported Providers:
- VistaDB The VistaDB embeddable and commercial library.
- OpenLink Software has High-Performance, Fully Managed .NET Data Providers for Major Databases which you can download.
Open Source Providers:
- MySQL Connector/Net from MySQL AB is the recommended .NET and Mono data provider for MySQL
- NPgsql is a fully managed provider for PostgreSQL and is included with Mono.
- Firebird fully managed provider for Firebird databases and is included with Mono.
- Advanced Data Provider ADP, is a transparent factory for ADO.NET which loads providers dynamically.
- MaxDB MaxDB database.
Object Persistent Libraries and Object Databases
- NHibernate NHibernate is a .NET based object persistence library for relational databases. NHibernate is a port of the excellent Java Hibernate relational persistence tool.
Commercial Object Persistent Libraries and Object Databases:
- db4o is an open source object database for .NET and Mono, a non-intrusive persistence system that stores any complex object with one single line of code.
- siaqodb is an object database for Mono, .NET and Silverlight.
Database Tools
- MonoDevelop Database - an Add-In to MonoDevelop providing a SQL Query and Database Browser tool.
Unmaintained Providers in Mono:
- OLE DB
- Ancient Microsoft SQL Server and Sybase databases
- ByteFX.Data.MySqlClient is a MySQL Managed data provider. ByteFX.Data is no longer maintained, but it is included with Mono. Please use the MySQL Connector/Net provider from MySQL AB instead.
- IBM DB2 Universal Database provider for IBM DB2 requires DB2 client software
- Sybase managed provider for Sybase ASE 12.0 and up databases