Contents

Library > Products > Pervasive.SQL > Pervasive.SQL 9.1 > Data Provider for .NET Guide > Contents

Previous

Data Provider for .NET Guide (9.1 revision 1)

Next

About This Manual v

What Is Pervasive Data Provider for .NET? vi

Using This Book vii

Typographical Conventions viii

Contacting Technical Support ix

1 Quick Start 1-1

Connecting to a Database 1-2

Defining Basic Connection Strings 1-5

2 Using the Pervasive.SQL Data Provider 2-1

About the Data Provider 2-2

Connecting with a Data Provider 2-5

Connection String Options for the Pervasive.SQL Provider 2-5

Using Connection Pooling 2-9

Modifying the Connection Object 2-11

Understanding Connection Failover and Client Load Balancing 2-12

Using Connection Failover 2-12

Client Load Balancing 2-13

Using Connection Retry 2-14

Configuring Connection Failover 2-15

Data Types 2-17

Mapping Parameter Data Types 2-18

Data Types Supported With Stream Objects 2-21

Using Streams as Input to Long Data Parameters 2-22

Parameter Markers 2-23

Parameter Arrays 2-24

Stored Procedures 2-25

Using Local Transactions 2-27

Thread Support 2-28

Unicode Support 2-29

Isolation Levels 2-30

SQL Escape Sequences 2-31

Event Handling 2-32

Error Handling 2-33

Diagnostic Support 2-34

Tracing Method Calls 2-34

PerfMon Support 2-35

Using .NET Objects 2-37

Developing Applications for .NET 2-38

Code Examples 2-39

3 Setting Security 3-1

Code Access Permissions 3-2

Security Attributes 3-3

4 .NET Objects and Properties 4-1

PsqlCommand Object 4-2

Public Properties 4-2

Public Methods 4-3

PsqlCommandBuilder Object 4-5

PsqlConnection Object 4-7

PsqlDataAdapter Object 4-9

PsqlDataReader Object 4-11

PsqlError Object 4-15

PsqlErrorCollection Object 4-15

PsqlException Object 4-17

PsqlInfoMessageEventArgs Object 4-19

PsqlParameter Object 4-20

PsqlParameterCollection Object 4-21

PsqlTrace Object 4-23

PsqlTransaction Object 4-25

A SQL Escape Sequences for .NET A-1

Date, Time, and Timestamp Escape Sequences A-2

Scalar Functions A-3

Outer Join Escape Sequences A-8

B Locking and Isolation Levels B-1

Isolation Levels B-3

Locking Modes and Levels B-6

C Designing for Best Performance C-1

Retrieving Data C-2

Understanding the Architecture C-2

Retrieving Long Data C-2

Reducing the Size of Data Retrieved C-2

Using CommandBuilder Objects C-3

Choosing the Right Data Type C-3

Selecting .NET Objects and Methods C-5

Using Parameter Markers as Arguments to Stored Procedures C-5

Designing .NET Applications C-6

Managing Connections C-6

Using Native Managed Providers C-6

Updating Data C-7

Using the Disconnected DataSet C-7

Synchronizing Changes Back to the Data Source C-7

D Code Examples D-1

Sample Tables Used in the Code Examples D-2

Sample Tables for Pervasive.SQL D-2

Retrieving Data Using a DataReader D-4

Retrieving a Scalar Value D-5

Using a Local Transaction D-6

Using the CommandBuilder D-7

Retrieving a Result Set using a DataAdapter Object D-8

Limiting the Rows Returned by a Select Statement D-9

Updating Data in a Rowset D-10

Calling a Stored Procedure D-12

Retrieving Warning Information D-14

Inserting Data Into LONGVARCHAR and LONGVARBINARY Columns D-15

Publication contents

Prev topic:
Next topic: About This Manual