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:

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 and 2005 databases
  • Sybase managed provider for Sybase ASE 12.0 and up databases

Commercially Supported Providers:

  • EffiProz is an embeddable SQL database featuring stored procedures, compatibility with SQL CE data types. It written in pure C# and distributed as a single 1.5 Mb dll. It support Mono, MonoTouch and MonoDroid as well as standard .NET. Some distinguishing features can be found here.
  • 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

Unmaintained Providers in Mono: