PSQL v12 ADO.NET Data Provider Release Notes
General Release – February 2017

Contents

This file contains the following topics:

About PSQL ADO.NET Data Provider

PSQL v12 provides two versions of the ADO.NET Data Provider: 4.0 and 4.2. All versions are installed by default with the database engine.

The PSQL ADO.NET Entity Framework data provider supports two versions of the Microsoft ADO.NET Entity Framework: 5.0 and 6.0.

All versions listed apply to both 32- and 64-bit versions of .NET Framework.

If you are using standard ADO.NET, then code written for earlier versions of the .NET Framework and earlier versions of the PSQL data provider is compatible with PSQL data provider 4.2. PSQL data provider 4.0 is included with the product for backward compatibility.

For standard ADO.NET, code written for the previous versions of the .NET Framework and PSQL data provider is compatible with the current version of the PSQL data provider. To use PSQL ADO.NET Entity Framework 4.2, your applications must target .NET Framework 4.5 or later.

Microsoft Entity Framework 6.1.0 through 6.1.3 are not supported in the current PSQL release.

The PSQL ADO.NET Data Provider runs as 100% managed code and can run and connect to the database entirely within the common language runtime (CLR).

Note  If your application uses binding redirection, the binding redirection file must be updated to Pervasive.Data.SqlClient.4.0 or Pervasive.Data.SqlClient.4.2.

Note about Windows Server 2003

In a Windows Server 2003 environment, the .NET Framework 2.0 or later is not installed by default. If .NET Framework 2.0 or later is not installed before installing PSQL, the PSQL providers are not written to the Global Assembly Cache (GAC) during PSQL installation, even though the provider assemblies are installed to the PSQL installation location. If your application design depends on an ADO.NET Provider being written to the GAC, it requires the following steps to function correctly:

See About PSQL ADO.NET Data Provider for information about which version of .NET Framework is required for each version of the ADO.NET provider.

What’s Deprecated in This Release?

Getting Started

The files required for the PSQL Data Provider for ADO.NET are provided through two different installations. The Provider assemblies are included by default when the PSQL database engine (all editions) is installed. The design-time files, sample source code, templates, and libraries, are included in the software development kit (SDK) installation for the ADO.NET access method.

Provider Assemblies

The installation of the database engine copies the Provider assemblies to version-specific directories under the PSQL\bin directory in PSQL installation location. Separate directories are used for 4.0 and 4.2.

If the installation detects a supported version of the .NET Framework, the following also occurs:

The generic Provider instance (Pervasive.Data.SqlClient) always points to the latest Provider assembly.

The Provider assemblies copied to the PSQL\bin directory are not pre-compiled at install time. That is, they are not added to the Windows native image service on the local computer. If you include the Provider assemblies as private side-by-side assemblies installed with your application and want them added to the Windows native image service on the target system, your installation must add them. Refer to the topic “Native Image Service” in the Microsoft MSDN Library.

Note  If the installation of the database engine detects any PSQL ADO.NET Data Provider prior to version 4.0, the older Provider is uninstalled.

Design-Time Files

The design-time files needed for the different PSQL Membership Providers for ASP.NET and Visual Studio integration are available for download from the PSQL website. Each assembly version has its own SDK installation executable.

The Membership Providers should be installed on the computer where .NET application development will be performed, and also on the client computers that will execute the application.

Each Membership Provider is installed to the GAC during the installation process.

Referencing the Different Providers

In addition to installing the sample source code files, templates, and libraries, the SDK installation executable also performs the following integration for the PSQL ADO.NET Data Provider:

Installing Visual Studio After Installing the PSQL ADO.NET Data Provider

If you install Visual Studio after installing the PSQL ADO.NET SDK, rerun the SDK installation executable. The SDK installation integrates the PSQL Membership Provider with Visual Studio.

Logging Application Block Configuration

For the Logging Application Block to function correctly, you must include the following line in your application:

ConfigurationManager.GetSection("Pervasive.Data.SqlClient.Entity");

Design Considerations

The following information can help you decide how you want to design your application to function with the PSQL ADO.NET Data Provider.

Design Method
Comments
Application references the generic Provider instance PSQL Provider
  • Application can use updates to the Provider released by Actian Corporation without being recompiled.
  • Application does not need to distribute the Provider files.
  • Application always uses the latest assembly version installed in the GAC by the PSQL installation and updated by PSQL patches.
Application references a version-specific Provider instance such as PSQL Provider 4.0 or PSQL Provider 4.2.
  • Application always uses the latest patches for a particular version of the Provider installed in the GAC.
  • Application will not use new releases of the Provider installed by PSQL.
Application references the Provider’s strong name (a name that consists of an assembly's text name, version number, and culture information (if provided), with a public key and a digital signature generated over the assembly).
  • Application distributes that specific version of the Provider.
  • Application installs the specific Provider as a private side-by-side assembly in the application installation folder.

Membership Provider for ASP.NET 2.0

The ASP.NET Login controls use the custom PSQL Membership Provider to specify a separate database for storing user information.

Additional information about writing a custom membership provider is available at http://msdn2.microsoft.com/en-us/library/f1kyba5e.aspx.

See Libraries for the location of the Membership Provider.

The sample ASP.NET application included with the libraries and samples shows how to create users, change passwords, recover passwords, and validate users.

Libraries

The SDK installation executable copies the following libraries to version-specific directories under the PSQL\bin directory. (See also “Where are the PSQL files installed?” in Getting Started with PSQL.)

Library
Description
PSQL.Membership.Provider.dll
Allows the ASP.NET Login controls to use a PSQL database.
PSQL.VisualStudio.DataTools.dll
Used by the VS.NET development environment for Server Explorer integration.

Membership Provider Requirements

Steps to use the Membership Provider

Login Controls within ASP.NET will now use the PSQL Membership Provider.

Users Table Script
CREATE TABLE Users 
( 
 PKID UniqueIdentifier NOT NULL PRIMARY KEY, 
  Username Char (255) NOT NULL, 
  ApplicationName char (255) NOT NULL, 
  Email Char (128) NOT NULL, 
  Comment Char (255), 
  "Password" Char (128) NOT NULL, 
  PasswordQuestion Char (255), 
  PasswordAnswer Char (255), 
  IsApproved SmallInt, 
  LastActivityDate DateTime, 
  LastLoginDate DateTime, 
  LastPasswordChangedDate DateTime, 
  CreationDate DateTime, 
  IsOnLine SmallInt, 
  IsLockedOut SmallInt, 
  LastLockedOutDate DateTime, 
  FailedPasswordAttemptCount Integer, 
  FailedPasswordAttemptWindowStart DateTime, 
  FailedPasswordAnswerAttemptCount Integer, 
  FailedPasswordAnswerAttemptWindowStart DateTime 
) 
Example Modified WEB.CONFIG
<connectionStrings> 
<add name="PsqlServices" connectionString="ServerDSN=ASPNETPSQL;" /> </
connectionStrings> <system.web> 
<membership defaultProvider="PsqlMembershipProvider" userIsOnlineTimeWindow="120"> 
<providers> 
<clear /> 
<add  
name="PsqlMembershipProvider"  
type="PSQL.Membership.PsqlMembershipProvider"  
connectionStringName="PsqlServices" 
enablePasswordRetrieval="true" 
enablePasswordReset="true" 
requiresQuestionAndAnswer="true"  
writeExceptionsToEventLog="true"  
debug="false" 
passwordFormat="Clear"/> 
</providers> 
</membership> </system.web>

IPv6 Environment

The PSQL ADO.NET data providers support IPv6 environments (IPv4/IPv6 mixed or IPv6-only).

Documentation

To help with the development of your .NET applications, see PSQL Data Provider for .NET Guide and PSQL Programmer’s Guide in the PSQL SDK documentation.

Samples

The following table summarizes the samples provided with the ADO.NET Data Provider. By default, the SDK installation executable copies the sample files to version-specific directories under the Application Data\Actian\PSQL directory. Note that the application data location varies depending on the bit-architecture of the operating system. See “Where are the PSQL files installed?” in Getting Started with PSQL.

Folder
Sample
Purpose of Sample
Provider
CommandBuilder
Creating a command from an SQL statement
CreateDatabaseObjects
Creating database objects such as a table or stored procedure
DataAdapter
Using the data adapter to read or modify data
DataGridUpdate
Updating data in a grid control
DataReader
Using the data reader to get data
Escapes
Processing escape functions in statements
LimitingRows
Limiting the number of rows returned in a result set
LocalTransactions
Processing a transaction
LongDataTypes
Using long data types such as LONGVARCHAR
ScalarValue
Executing scalar functions to return a value
StoredProcedures
Using stored procedures
MembershipProvider
ASPX files for using the membership provider with the ASP.NET Login controls
Various login activities, changing password, and so forth
Enterprise Library
Sample using Microsoft Enterprise Library
Demonstrating the use of Microsoft Enterprise Library

Known Issues and Usage Notes

All known issues for PSQL v12 are published on the PSQL website.

The following additional notes apply to using the PSQL v12.11 ADO.NET data provider:

Technical Support

You can obtain technical support from several online options at the PSQL website:

Disclaimer

ACTIAN CORPORATION LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

Copyright © 2016 Actian Corporation. All Rights Reserved.


Actian Corporation

*** End of Release Notes ***