Support for .NET Framework 3.5 SP1 and 4.0
Pervasive PSQL v11 provides two versions of the ADO.NET Data Provider, version 3.2 and 3.5. Both versions are installed by default with the database engine and with the Pervasive PSQL Client.
The installation puts both Data Providers under the “Program Files (x86)” directory whether you are installing the 32-bit or 64-bit version of Pervasive PSQL. The Data Providers are bitness independent, however. Each Data Provider works with both the 32-bit and the 64-bit .NET Framework.
Pervasive PSQL ADO.NET Data Provider 3.2
The Pervasive PSQL ADO.NET Data Provider 3.2 has no new features from prior versions of the 3.2 Provider. It is included for application developers who want to use that version with Pervasive PSQL v11.
Pervasive PSQL ADO.NET Data Provider 3.5
Pervasive PSQL ADO.NET Data Provider 3.5 supports the new features in .NET Framework 3.5 SP1. The Provider is compliant with the .NET Framework Versions 2.0, 3.0, 3.5, 3.5 SP1, and 4.0. The 3.5 Provider does not support new features introduced in .NET Framework 4.0 but will run under the .NET Framework 4.0 with support for all the Entity Framework 1.0 features.
In addition, the Pervasive PSQL ADO.NET Data Provider 3.5 includes the following main features:
•
Development using a set of methods tailored for the new Entity Framework consumers such as LINQ, EntitySQL, and ObjectServices.
•
Pervasive Bulk Load. The DbBulkCopy class supports bulk loading data in the Common Programming Model. In addition, the Data Provider has a provider-specific bulk load class.
•
Connection statistics support.
•
A Schema Options connection string option to specify additional schema metadata to be returned.
•
Native parameter marker and parameter binding support.
•
Microsoft Enterprise Library 4.1 (October 2008) support, including data access application block (DAAB) support.
•
Initial Command Timeout connection string option to specify an initial command timeout when a connection is established.
•
Support for Microsoft Visual Studio 2008 and Visual Studio 2010.
See
Pervasive PSQL
Data Provider for .NET Guide
in the SDK documentation for complete details.