ADO.NET

Edit page on GitHub

See our Database_Access page for more details.

Status and tests for ADO.NET 2.0 are available in our ADOTests page.

Tools

Some tools that can be used for ADO.NET and other technologies (ASP.NET, XML, etc).

  • sqlsharp.exe
    • SQL# is a command line query tool included with Mono to enter and execute SQL statements
  • xsd.exe
    • XML Schema Definition tool
    • 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 types in a assembly file. The XML schema created by the tool defines the XML format used by System.XML.Serialization.XMLSerializer

Generic Database access in Mono ADO.NET

An ADO.NET Provider Factory was created by Brian Ritchie. The Provider Factory is a way to dynamically create connections, commands, parameters, and data adapters based on configuration information. This implmentation is based on the interfaces exposed in ADO.NET provider classes.

Another Provider Factory implementation is being developed in 1.1 branch supporting Microsoft’s new API for generic database access. This is based on the common provider base classes available in Mono 1.1 development version. This implementation is based on the released beta API’s and are subject to change. The providers that can be accessed currently are

  • System.Data.SqlClient
  • System.Data.Odbc

Database Access from ASP.NET

  • Take a look at xsp in cvs and look at the examples in test: dbpage1.aspx and dbpage2.aspx:

  • Notice that the namespace System.Data is imported via import

  • A NameValueCollection is gotten using ConfigurationSettings.AppSetings. These settings are gotten from the file server.exe.config which is a XML file. The XML file has a section appSettings. In the appSettings section, you have keys for DBProviderAssembly, DBConnectionType, and DBConnectionString.

  • DBProviderAssembly is the assembly of the ADO.NET provider. For example: “Npgsql”

  • DBConnectionType is the System.Type of the class that implements System.Data.IDbConnection that is found in the DBProviderAssembly. For example: “Npgsql.NpgsqlConnection”

  • DBConnectionString is the ConnectionString to set to the IDbConnection object to use in opening a connection to a data source. For Example: “server=127.0.0.1;user id=monotest;password=monotest; database=monotest”

  • The function GetConnectionData() gets the database provider assembly, connection type, and connection string parameters if they exist; otherwise, it uses default values. This is done during the loading of the web page.

  • With the connection parameters, the assembly is loaded, the connection type is verified that it implements IDbConnection and an instance of the class can be created, creates a instance of the class, sets the connection string, and opens the connection.

Testing

  • Testing connection-oriented classes are done via the provider specific tests found in the mcs source at mcs/class/System.Data/Test. There is also a nunit based connected mode tests under mcs/class/System.Data/Test/ProviderTests. The following table shows the stand alone test files for specific providers. Refer Writing Connected Mode Testcases also for testing specific Data Providers.
Name Assembly /
Namespace		 Test
Microsoft
SQL Server		 System.Data /
System.Data.SqlClient		 SqlTest.cs at
System.Data/Test
PostgreSQL
(Npgsql)		 Npgsql /
Npgsql		 *.cs at
Npgsql/Test
Oracle
(Mono)		 System.Data.OracleClient /
System.Data.OracleClient		 TestOracleClient.cs at
System.Data.OracleClient/Test
ODBC
(Mono)		 System.Data.Odbc /
System.Data		 OdbcTest.cs (to connect to MS SQL Server)at
System.Data/Test

  • Testing non-connection classes are done via Mono’s modified version of NUnit.

  • To run all the NUnit tests for Mono, you need the mcs source. cd to the root of the mcs source. To run it:

  • make test

  • If you just want to run the NUnit tests for System.Data, you would cd into the mcs source at class/System.Data/Test and run it:

  • make test