Navigation

Using Databases

From Mono

Mono can interact with a variety of commercial and open source databases using ADO.NET. The project's current goal for data access is to be compatible with .NET 1.1 and .NET 1.0. We also would like to extend data access beyond what is included with .NET 1.0 and .NET 1.1, such as, include access to more databases, such as, PostgreSQL and MySQL, but also provide classes that help in creating data source-agnostic code, such as, Mono.Data.ProviderFactory.

We are working on .NET 2.0 compatibility features as well as improving .NET 1.x compatibility.

This document does not aim to be a tutorial on ADO.NET, since there are many fine books and online resources that can help you, only a guide to using databases with Mono.

Database Providers

The following database providers are available for Mono applications:

Tools

The following Mono tools are useful when working with ADO.NET:

  • sqlsharp.exe (SQL#), a command line query tool included with Mono to enter and execute SQL statements.
  • xsd.exe , XML Schema Definition tool
    • XDR to XSD - used to generate an XML schema from an XDR (XML Data Reduced schema) file. XDR was used by Microsoft prior to XSD becoming a W3C recommendation, and it needs to be supported for legacy reasons.
    • XML to XSD - used to generate an XML schema from an XML file.
    • XSD to DataSet - used to generate DataSet classes from an XSD schema file. The DataSet classes created can then be used with XML data.
    • XSD to Classes - used to generate classes from an XSD schema file. The classes created can be used with System.XML.Serialization.XMLSerializer to read and write XML code that follows the schema.
    • Classes to XSD - used to generate an XML schema from type(s) in a assembly file. The XML schema created by the tool defines the XML format used by System.XML.Serialization.XMLSerializer.
Retrieved from "http://www.mono-project.com/Using_Databases"