Home  /  Application Development: Language Bindings and Gateways  /  Using the InterSystems Managed Provider for .NET  /  Introduction

Using the InterSystems Managed Provider for .NET
[Back]  [Next] 
InterSystems: The power behind what matters   

This book describes how to use the SqlClient .NET assembly, which provides two different but complementary ways to access InterSystems IRIS™ from a .NET application:
The SqlClient assembly is implemented using .NET managed code throughout, making it easy to deploy within a .NET environment. It is thread-safe and can be used within multithreaded .NET applications. This chapter describes how to install the Managed Provider (see SqlClient Installation and Configuration) and provides additional instructions for setting up Entity Framework (see Setting Up the Entity Framework Provider).
The InterSystems IRIS .NET Help File
The InterSystems IRIS .NET help file provides the most current and detailed documentation for both object and relational APIs. This file is named IrisProvider.chm, and it is available as a stand-alone help file in <iris-install-dir>\dev\dotnet\help.
SqlClient Installation and Configuration
This section provides specifies requirements, and provides instructions for installing the SqlClient assembly and configuring Visual Studio.
InterSystems IRIS is not required on computers that run your InterSystems IRIS .NET client applications, but the clients must have a TCP/IP connection to the InterSystems IRIS Server and must be running a supported version of the .NET Framework.
The SqlClient assembly (InterSystems.Data.IRISClient.dll) is installed along with the rest of InterSystems IRIS, and requires no special preparation.
To use the SqlClient assembly in a .NET project, you must add a reference to the assembly, and add the corresponding Using statements to your code (as described in the following section).
There is a separate version of InterSystems.Data.IRISClient.dll for each supported version of .NET. These files are located in the following subdirectories of <iris-install-dir>\dev\dotnet\bin:
See InterSystems IRIS Installation Directory in the Installation Guide for the location of <iris-install-dir> on your system.
All InterSystems IRIS assemblies for .NET are installed to the .NET GAC (Global Assembly Cache) when InterSystems IRIS is installed.
Configuring Visual Studio
This section describes how to set up a Visual Studio project using the SqlClient assembly.
To add a SqlClient assembly reference to a project:
  1. From the Visual Studio main menu, select Project > Add Reference
  2. In the Add Reference window, click on Browse...
  3. Browse to the subdirectory of <iris-install-dir>\dev\dotnet\bin that contains the assembly for the version of .NET used in your project (as listed in the previous section), select InterSystems.Data.IRISClient.dll, and click OK.
  4. In the Visual Studio Solution Explorer, the InterSystems.Data.IRISClient assembly should now be listed under References.
Add Using Statements to the Application
Add Using statements for the two main namespaces in the InterSystems.Data.IRISClient.dll assembly before the beginning of your application's namespace. InterSystems.Data.IRISClient provides code in the namespace InterSystems.Data.IrisClient, so this namespace must be referenced in the using statement.
  using InterSystems.Data.IRISClient;

  namespace DotNetSample {
Both the SqlClient and IrisTypes namespaces are included in the InterSystems.Data.IRISClient.dll assembly.
Setting Up the Entity Framework Provider
Follow the instructions in this section if you want to use the InterSystems IRIS Entity Framework Provider.
System Requirements
To use InterSystems IRIS Entity Framework Provider, you need the following software:
Run Setup and Set Variables
Follow these steps:
  1. Extract the contents of install-dir\dev\dotnet\bin\v4.0.30309\ into a folder (in the same directory as the zip file) called IrisEF. Run \IrisEF\setup.cmd.
  2. In the displayed Windows Explorer folder, right-click Developer Command Prompt for VS2013 > Run as Administrator and enter:
    devenv /setup
    This command repopulates this key from HKEY_LOCAL_MACHINE:
Copy Files to Visual Studio
Copy the two files from the IrisEF directory to Visual Studio:
from the directory <iris-install-dir>\dev\dotnet\bin\v4.0.30319\IrisEF\Templates to the directory C:\Program Files (x86)\Microsoft Visual Studio 1x.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen
Connect Visual Studio to InterSystems IRIS Server
To connect Visual Studio to an InterSystems IRIS instance, follow the steps below:
  1. Open Visual Studio and select View > Server Explorer.
  2. Right-click Data Connections and select Add Connection. In the Add Connection Dialog:
    1. Select Server
    2. Enter Username and password. Click Connect.
    3. Select a namespace from the list. Click OK.
Configure Nuget Local Repository
Follow these steps to configure the Package Manager to find the local Nuget repository:
  1. Create a directory as a Nuget repository. You might call it Nuget Repository. You could put it anywhere – a good choice might be <yourdoclibraryVS2013>\Projects (where Visual Studio stores projects by default).
  2. Copy the file <installdir>\dev\dotnet\bin\v4.0.30319\IrisEF\Nuget\InterSystems.Data.Entity6. and paste it into your Nuget repository directory. Click OK.
  3. Click the plus sign+. Enter the path that contains InterSystems.Data.Entity6. Click OK