About the PSQL ADO.NET Data Provider

About the PSQL ADO.NET Data Provider

The PSQL ADO.NET data provider is compliant with the Microsoft .NET Framework 2.0, 3.0, 3.5, 3.5 SP1, 4.0, 4.5, 4.5.1, 4.5.2, 4.6.1, and 4.6.2 Preview. The data provider is built with 100% managed code; it can run and connect to the database entirely within the common language runtime (CLR).

Code that runs in the native operating system, such as client libraries and COM components, is called unmanaged code. You can mix managed and unmanaged code within a single application. However, unmanaged code reaches outside the CLR, which means that it effectively raises complexity, reduces performance, and opens possible security risks.

The namespace for the ADO.NET data provider is Pervasive.Data.SqlClient. When connecting to the PSQL database, you use the PsqlConnection and PsqlCommand objects in the Pervasive.Data.SqlClient namespace.

The following code fragment shows how to include the ADO.NET data provider’s namespace in your applications:

using System.Data;

using System.Data.Common;

using Pervasive.Data.SqlClient;

' Access PSQL

Imports System.Data

Imports System.Data.Common

Imports Pervasive.Data.SqlClient

The strongly named assembly for the ADO.NET data provider is placed in the Global Assembly Cache (GAC) during installation. The assembly name is Pervasive.Data.SqlClient.dll.

The Pervasive.Data.Common assembly includes features such as support for bulk load.