Using the NuoDB ADO.NET Driver

NuoDB's ADO.NET driver lets you develop .NET applications that connect to a NuoDB database. It is a fully managed ADO.NET driver, written in C# for .NET 3.5 and 4.0, and implements all required ADO.NET interfaces and integrates with ADO.NET aware tools.

As a result of changes made to Visual Studio in 2015, NuoDB's ADO.NET driver can no longer be included using the IDE (Integrated Development Environment). NuoDB databases can be included programmatically as described below.

The information and examples provided here are intended to get you started using ADO.NET in a NuoDB application by using the NuoDB ADO.NET driver objects directly.

Requirements

Installation

NuoDB's ADO.NET driver is available on github. For more information, see NuoDB Community Drivers on GitHub.

The ADO.NET driver is also available at nuget.org.

For versions of Visual Studio prior to 2015, installation of NuoDB automatically registers the .NET assembly, declares the database provider, and installs the Visual Studio plugin in the available IDEs.

Previous to this version of the (gitHub) NuoDB driver installer, two steps were performed.

  1. The installer registered the driver in the GAC (Global Assembly Cache) so that any tool could load the list of available drivers and create it using the metadata.
  2. The installer registered for Visual Studio (versions 2010, 2012, 2013) an extension package that made it work with the IDE in a visually integrated way.

By installing NuoDB's ADO.NET driver using the package manager within the Visual Studio IDE from nuget.org, step 1 above is performed automatically. If you install the driver from github, you will need to perform this step manually.

Note: The driver is registered locally and will installed for each project using a NuoDB database.

Once the ADO.NET driver has been installed, execute the following using commands:

In VB

using NuoDB.Data.Client;

In C#

import NuoDB.Data.Client;

Uninstalling the NuoDB ADO.NET Driver

To uninstall the ADO.NET driver:

  1. Open the Control Panel.
  2. Select Uninstall Software.
  3. In the list of installed programs, select ADO.NET Driver for NuoDB.
  4. Click Uninstall.

See Also

Microsoft documentation for ADO.NET at https://msdn.microsoft.com/en-us/library/e80y5yhx%28v=vs.110%29.aspx.

See the following topics: