Pervasive Data Provider for .NET - Table of Contents

Pervasive.SQL 8.7 (code NET_870, revision 1)  Sync manual in Pervasive Library

About This Manual

What Is Pervasive Data Provider for .NET?

Using This Book

Typographical Conventions

Contacting Technical Support

Quick Start

Connecting to a Database

Defining Basic Connection Strings

Using the Pervasive.SQL Data Provider

About the Data Provider

Assemblies

Namespace

Connecting with a Data Provider

Connection String Options for the Pervasive.SQL Provider

Using Connection Pooling

Modifying the Connection Object

Understanding Connection Failover and Client Load Balancing

Using Connection Failover

Client Load Balancing

Using Connection Retry

Configuring Connection Failover

Data Types

Mapping Parameter Data Types

Data Types Supported With Stream Objects

Using Streams as Input to Long Data Parameters

Parameter Markers

Parameter Arrays

Stored Procedures

Using Local Transactions

Thread Support

Unicode Support

Isolation Levels

SQL Escape Sequences

Event Handling

Error Handling

Diagnostic Support

Tracing Method Calls

PerfMon Support

Using .NET Objects

Developing Applications for .NET

Code Examples

Setting Security

Code Access Permissions

Security Attributes

.NET Objects and Properties

PsqlCommand Object

Public Properties

Public Methods

PsqlCommandBuilder Object

PsqlConnection Object

PsqlDataAdapter Object

PsqlDataReader Object

PsqlError Object

PsqlErrorCollection Object

PsqlException Object

PsqlInfoMessageEventArgs Object

PsqlParameter Object

PsqlParameterCollection Object

PsqlTrace Object

PsqlTransaction Object

SQL Escape Sequences for .NET

Date, Time, and Timestamp Escape Sequences

Scalar Functions

Outer Join Escape Sequences

Locking and Isolation Levels

Locking

Isolation Levels

Locking Modes and Levels

Designing for Best Performance

Retrieving Data

Understanding the Architecture

Retrieving Long Data

Reducing the Size of Data Retrieved

Using CommandBuilder Objects

Choosing the Right Data Type

Selecting .NET Objects and Methods

Using Parameter Markers as Arguments to Stored Procedures

Designing .NET Applications

Managing Connections

Using Native Managed Providers

Updating Data

Using the Disconnected DataSet

Synchronizing Changes Back to the Data Source

Code Examples

Sample Tables Used in the Code Examples

Sample Tables for Pervasive.SQL

Retrieving Data Using a DataReader

Retrieving a Scalar Value

Using a Local Transaction

Using the CommandBuilder

Retrieving a Result Set using a DataAdapter Object

Limiting the Rows Returned by a Select Statement

Updating Data in a Rowset

Calling a Stored Procedure

Retrieving Warning Information

Inserting Data Into LONGVARCHAR and LONGVARBINARY Columns

Glossary