Welcome to Actian Zen ADO.NET Data Providers
What Are the Zen ADO.NET Data Providers?
What’s New in This Release
Changes Since the 4.6 Release
Changes for the 4.6 Release
Using This Guide
Quick Start
ADO.NET Data Providers Installed with Zen
Supported .NET Framework Versions
Notes
Zen ADO.NET Data Providers Available for SDK Download
Defining Basic Connection Strings
Notes
Minimum Required Connection String Options
Connecting to a Database
Example: Using the Provider-Specific Objects
Example: Using the Common Programming Model
Example: Using the Zen Common Assembly
Using the Zen ADO.NET Entity Framework Data Provider
Using the Data Providers
About the Data Providers
Using Connection Strings
Guidelines
Using the Zen Performance Tuning Wizard
Stored Procedures
Using IP Addresses
Transaction Support
Using Local Transactions
Thread Support
Unicode Support
Isolation Levels
SQL Escape Sequences
Event Handling
Error Handling
Using .NET Objects
Developing Applications for .NET
Advanced Features
Using Connection Pooling
Creating a Connection Pool
Adding Connections to a Pool
Removing Connections from a Pool
Handling Dead Connection in a Pool
Tracking Connection Pool Performance
Using Statement Caching
Enabling Statement Caching
Choosing a Statement Caching Strategy
Using Connection Failover
Using Client Load Balancing
Using Connection Retry
Configuring Connection Failover
Setting Security
Code Access Permissions
Security Attributes
Using Zen Bulk Load
Use Scenarios for Zen Bulk Load
Zen Common Assembly
Bulk Load Data File
Example
Bulk Load Configuration File
Example
Determining the Bulk Load Protocol
Character Set Conversions
External Overflow File
Bulk Copy Operations and Transactions
Using Diagnostic Features
Tracing Method Calls
Using Environment Variables
Notes
Using Static Methods
PerfMon Support
Analyzing Performance with Connection Statistics
Enabling and Retrieving Statistical Items
The ADO.NET Data Providers
About Zen ADO.NET Data Providers
Namespace
C#
Visual Basic
Assembly Name
Using Connection Strings with the Zen ADO.NET Data Provider
Constructing a Connection String
Performance Considerations
Connection String Options that Affect Performance
Properties that Affect Performance
Data Types
Mapping Zen Data Types to .NET Framework Data Types
Mapping of Zen Data Types
Mapping Parameter Data Types
Mapping System.Data.DbTypes to PsqlDbTypes
Mapping .NET Framework Types to PsqlDbType
Data Types Supported with Stream Objects
Using Streams as Input to Long Data Parameters
Parameter Markers
Parameter Arrays
Zen ADO.NET Core Data Providers
About Zen ADO.NET Core Data Providers
Creating an Application in Visual Studio Using Zen ADO.Net Core DLL
Creating a UWP Application in Visual Studio Using Zen ADO.Net Core Data Provider
ADO.NET Data Provider Features Missing in Zen ADO.NET Core Data Provider
Zen ADO.NET Entity Framework Data Providers
About Zen ADO.NET Entity Framework Data Providers
Namespace
Assembly Names
Configuring Entity Framework 6.1
Configuration File Registration
Code-Based Registration
Using Connection Strings with the Zen ADO.NET Entity Framework Data Provider
Defining Connection String Values in Server Explorer
Changes in Default Values for Connection String Options
Code First and Model First Support
Handling Long Identifier Names
Using Code First Migrations with the ADO.NET Entity Framework
Using Enumerations with the ADO.NET Entity Framework
Mapping Data Types and Functions
Type Mapping for Database First
Type Mapping for Database First
Type Mapping for Model First
Type Mapping for Code First
Mapping EDM Canonical Functions to Zen Functions
Aggregate Canonical Functions
Math Canonical Functions
Date and Time Canonical Functions
Bitwise Canonical Functions
String Canonical Functions
Other Canonical Functions
Extending Entity Framework Functionality
Enhancing Entity Framework Performance
Limiting the Size of XML Schema Files
Using Stored Procedures with the ADO.NET Entity Framework
Providing Functionality
Mapping to Pseudo Stored Procedure
Using Overloaded Stored Procedures
Using .NET Objects
Properties and Methods Differences with the ADO.NET Entity Data Provider
Creating a Model
Upgrading Entity Framework 5 Applications to Entity Framework 6.1
For More Information
Zen ADO.NET Entity Framework Core Data Providers
About Zen ADO.NET Entity Framework Core Data Providers
Namespace
Assembly Names
Configuring the Zen ADO.NET Entity Framework Core Data Provider
Using Connection Strings with Zen ADO.NET Entity Framework Core Data Provider
Changes in Default Values for Connection String Options
Code First Support
Handling Long Identifier Names
Using Code First Migrations with the ADO.NET Entity Framework Core
Using Reverse Engineering (Scaffolding)
Type Mapping for Code First
Mapping EDM Canonical Functions to Zen Functions
Aggregate Canonical Functions
Math Canonical Functions
Date and Time Canonical Functions
String Canonical Functions
Other Canonical Functions
Extending Entity Framework Functionality
Using Stored Procedures with the ADO.NET Entity Framework Core
Upgrading an Application from Entity Framework 6.x to Entity Framework Core
Limitations
For More Information
Using Zen Data Providers in Visual Studio
Adding Connections
Adding Connections in Server Explorer
Advanced
Connection Pooling
Failover
Performance
Schema Information
Security
Standard Connection
Tracing
Adding Connections with the Data Source Configuration Wizard
Using the Zen Performance Tuning Wizard
Using Provider-Specific Templates
Creating a New Project
Adding a Template to an Existing Project
Using the Zen Visual Studio Wizards
Creating Tables with the Add Table Wizard
Creating Views with the Add View Wizard
Adding Components from the Toolbox
Data Provider Integration Scenario
A. .NET Objects Supported
.NET Base Classes
Data Provider-Specific Classes
PsqlBulkCopy
PsqlBulkCopyColumnMapping
PsqlBulkCopyColumnMappingCollection
PsqlCommand Object
PsqlCommandBuilder Object
PsqlConnection Object
PsqlConnectionStringBuilder Object
Connection String Properties
PsqlCredential Object
PsqlDataAdapter Object
PsqlDataReader Object
PsqlError Object
PsqlErrorCollection Object
PsqlException Object
PsqlFactory Object
PsqlInfoMessageEventArgs Object
PsqlParameter Object
PsqlParameterCollection Object
PsqlTrace Object
PsqlTransaction Object
Zen Common Assembly Classes
CsvDataReader
CsvDataWriter
DbBulkCopy
DbBulkCopyColumnMapping
DbBulkCopyColumnMappingCollection
B. Getting Schema Information
Columns Returned by the GetSchemaTable Method
Retrieving Schema Metadata with the GetSchema Method
MetaDataCollections Schema Collections
DataSourceInformation Schema Collection
DataTypes Collection
ReservedWords Collection
Restrictions Collection
Additional Schema Collections
Columns Schema Collection
ForeignKeys Schema Collection
Indexes Schema Collection
PrimaryKeys Schema Collection
ProcedureParameters Schema Collection
Procedures Schema Collection
TablePrivileges Schema Collection
Tables Schema Collection
Views Schema Collection
C. SQL Escape Sequences for .NET
Date, Time, and Timestamp Escape Sequences
Example
Scalar Functions
Example
Outer Join Escape Sequences
Example
D. Locking and Isolation Levels
Locking
Isolation Levels
Locking Modes and Levels
E. Designing .NET Applications for Performance Optimization
Retrieving Data
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
Opening and Closing Connections
Using Statement Caching
Using Commands Multiple Times
Using Native Managed Providers
Updating Data
Using the Disconnected DataSet
Synchronizing Changes Back to the Data Source
F. Using an .edmx File
Code Examples
G. Bulk Load Configuration Files
Sample Bulk Data Configuration File
XML Schema Definition for a Bulk Data Configuration File
H. IANA Code Page Mappings
Welcome to Actian Zen ADO.NET Data Providers
Quick Start
Using the Data Providers
Advanced Features
The ADO.NET Data Providers
Zen ADO.NET Core Data Providers
Zen ADO.NET Entity Framework Data Providers
Zen ADO.NET Entity Framework Core Data Providers
Using Zen Data Providers in Visual Studio
A. .NET Objects Supported
B. Getting Schema Information
C. SQL Escape Sequences for .NET
D. Locking and Isolation Levels
E. Designing .NET Applications for Performance Optimization
F. Using an .edmx File
G. Bulk Load Configuration Files
H. IANA Code Page Mappings
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
>
What Are the Zen ADO.NET Data Providers?
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
>
What’s New in This Release
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
>
What’s New in This Release
>
Changes Since the 4.6 Release
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
>
What’s New in This Release
>
Changes for the 4.6 Release
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Welcome to Actian Zen ADO.NET Data Providers
>
Using This Guide
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
ADO.NET Data Providers Installed with Zen
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
ADO.NET Data Providers Installed with Zen
>
Supported .NET Framework Versions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
ADO.NET Data Providers Installed with Zen
>
Supported .NET Framework Versions
>
Notes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Zen ADO.NET Data Providers Available for SDK Download
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Defining Basic Connection Strings
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Defining Basic Connection Strings
>
Notes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Defining Basic Connection Strings
>
Minimum Required Connection String Options
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Connecting to a Database
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Connecting to a Database
>
Example: Using the Provider-Specific Objects
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Connecting to a Database
>
Example: Using the Common Programming Model
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Connecting to a Database
>
Example: Using the Zen Common Assembly
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Quick Start
>
Using the Zen ADO.NET Entity Framework Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
About the Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Using Connection Strings
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Using Connection Strings
>
Guidelines
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Using Connection Strings
>
Using the Zen Performance Tuning Wizard
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Stored Procedures
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Using IP Addresses
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Transaction Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Transaction Support
>
Using Local Transactions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Thread Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Unicode Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Isolation Levels
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
SQL Escape Sequences
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Event Handling
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Error Handling
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Using .NET Objects
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using the Data Providers
>
Developing Applications for .NET
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
>
Creating a Connection Pool
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
>
Adding Connections to a Pool
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
>
Removing Connections from a Pool
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
>
Handling Dead Connection in a Pool
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Pooling
>
Tracking Connection Pool Performance
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Statement Caching
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Statement Caching
>
Enabling Statement Caching
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Statement Caching
>
Choosing a Statement Caching Strategy
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Failover
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Client Load Balancing
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Connection Retry
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Configuring Connection Failover
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Setting Security
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Setting Security
>
Code Access Permissions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Setting Security
>
Security Attributes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Use Scenarios for Zen Bulk Load
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Zen Common Assembly
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Bulk Load Data File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Bulk Load Data File
>
Example
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Bulk Load Configuration File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Bulk Load Configuration File
>
Example
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Determining the Bulk Load Protocol
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Character Set Conversions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
External Overflow File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Zen Bulk Load
>
Bulk Copy Operations and Transactions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Tracing Method Calls
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Tracing Method Calls
>
Using Environment Variables
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Tracing Method Calls
>
Using Environment Variables
>
Notes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Tracing Method Calls
>
Using Static Methods
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
PerfMon Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Analyzing Performance with Connection Statistics
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Advanced Features
>
Using Diagnostic Features
>
Enabling and Retrieving Statistical Items
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
About Zen ADO.NET Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
About Zen ADO.NET Data Providers
>
Namespace
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
About Zen ADO.NET Data Providers
>
Namespace
>
C#
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
About Zen ADO.NET Data Providers
>
Namespace
>
Visual Basic
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
About Zen ADO.NET Data Providers
>
Assembly Name
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Using Connection Strings with the Zen ADO.NET Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Using Connection Strings with the Zen ADO.NET Data Provider
>
Constructing a Connection String
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Performance Considerations
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Performance Considerations
>
Connection String Options that Affect Performance
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Performance Considerations
>
Properties that Affect Performance
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Mapping Zen Data Types to .NET Framework Data Types
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Mapping Zen Data Types to .NET Framework Data Types
>
Mapping of Zen Data Types
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Mapping Parameter Data Types
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Mapping Parameter Data Types
>
Mapping System.Data.DbTypes to PsqlDbTypes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Mapping Parameter Data Types
>
Mapping .NET Framework Types to PsqlDbType
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Data Types
>
Data Types Supported with Stream Objects
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Using Streams as Input to Long Data Parameters
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Parameter Markers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
The ADO.NET Data Providers
>
Parameter Arrays
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Core Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Core Data Providers
>
About Zen ADO.NET Core Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Core Data Providers
>
Creating an Application in Visual Studio Using Zen ADO.Net Core DLL
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Core Data Providers
>
Creating a UWP Application in Visual Studio Using Zen ADO.Net Core Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Core Data Providers
>
ADO.NET Data Provider Features Missing in Zen ADO.NET Core Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
About Zen ADO.NET Entity Framework Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
About Zen ADO.NET Entity Framework Data Providers
>
Namespace
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
About Zen ADO.NET Entity Framework Data Providers
>
Assembly Names
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Configuring Entity Framework 6.1
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Configuring Entity Framework 6.1
>
Configuration File Registration
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Configuring Entity Framework 6.1
>
Code-Based Registration
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Connection Strings with the Zen ADO.NET Entity Framework Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Connection Strings with the Zen ADO.NET Entity Framework Data Provider
>
Defining Connection String Values in Server Explorer
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Connection Strings with the Zen ADO.NET Entity Framework Data Provider
>
Changes in Default Values for Connection String Options
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Code First and Model First Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Code First and Model First Support
>
Handling Long Identifier Names
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Code First Migrations with the ADO.NET Entity Framework
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Enumerations with the ADO.NET Entity Framework
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Type Mapping for Database First
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Type Mapping for Database First
>
Type Mapping for Database First
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Type Mapping for Model First
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Type Mapping for Code First
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
Aggregate Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
Math Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
Date and Time Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
Bitwise Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
String Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Mapping Data Types and Functions
>
Mapping EDM Canonical Functions to Zen Functions
>
Other Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Extending Entity Framework Functionality
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Enhancing Entity Framework Performance
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Enhancing Entity Framework Performance
>
Limiting the Size of XML Schema Files
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Stored Procedures with the ADO.NET Entity Framework
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Stored Procedures with the ADO.NET Entity Framework
>
Providing Functionality
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Stored Procedures with the ADO.NET Entity Framework
>
Providing Functionality
>
Mapping to Pseudo Stored Procedure
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using Stored Procedures with the ADO.NET Entity Framework
>
Using Overloaded Stored Procedures
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using .NET Objects
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using .NET Objects
>
Properties and Methods Differences with the ADO.NET Entity Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Using .NET Objects
>
Creating a Model
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
Upgrading Entity Framework 5 Applications to Entity Framework 6.1
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Data Providers
>
For More Information
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
About Zen ADO.NET Entity Framework Core Data Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
About Zen ADO.NET Entity Framework Core Data Providers
>
Namespace
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
About Zen ADO.NET Entity Framework Core Data Providers
>
Assembly Names
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Configuring the Zen ADO.NET Entity Framework Core Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Using Connection Strings with Zen ADO.NET Entity Framework Core Data Provider
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Using Connection Strings with Zen ADO.NET Entity Framework Core Data Provider
>
Changes in Default Values for Connection String Options
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Code First Support
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Code First Support
>
Handling Long Identifier Names
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Using Code First Migrations with the ADO.NET Entity Framework Core
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Using Reverse Engineering (Scaffolding)
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
>
Aggregate Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
>
Math Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
>
Date and Time Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
>
String Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Type Mapping for Code First
>
Mapping EDM Canonical Functions to Zen Functions
>
Other Canonical Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Extending Entity Framework Functionality
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Using Stored Procedures with the ADO.NET Entity Framework Core
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Upgrading an Application from Entity Framework 6.x to Entity Framework Core
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
Limitations
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Zen ADO.NET Entity Framework Core Data Providers
>
For More Information
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Advanced
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Connection Pooling
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Failover
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Performance
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Schema Information
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Security
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Standard Connection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections in Server Explorer
>
Tracing
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Connections
>
Adding Connections with the Data Source Configuration Wizard
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using the Zen Performance Tuning Wizard
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using Provider-Specific Templates
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using Provider-Specific Templates
>
Creating a New Project
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using Provider-Specific Templates
>
Adding a Template to an Existing Project
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using the Zen Visual Studio Wizards
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using the Zen Visual Studio Wizards
>
Creating Tables with the Add Table Wizard
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Using the Zen Visual Studio Wizards
>
Creating Views with the Add View Wizard
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Adding Components from the Toolbox
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
Using Zen Data Providers in Visual Studio
>
Data Provider Integration Scenario
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
.NET Base Classes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlBulkCopy
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlBulkCopyColumnMapping
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlBulkCopyColumnMappingCollection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlCommand Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlCommandBuilder Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlConnection Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlConnectionStringBuilder Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
Connection String Properties
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlCredential Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlDataAdapter Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlDataReader Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlError Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlErrorCollection Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlException Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlFactory Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlInfoMessageEventArgs Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlParameter Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlParameterCollection Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlTrace Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Data Provider-Specific Classes
>
PsqlTransaction Object
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
>
CsvDataReader
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
>
CsvDataWriter
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
>
DbBulkCopy
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
>
DbBulkCopyColumnMapping
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
A. .NET Objects Supported
>
Zen Common Assembly Classes
>
DbBulkCopyColumnMappingCollection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Columns Returned by the GetSchemaTable Method
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
>
MetaDataCollections Schema Collections
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
>
DataSourceInformation Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
>
DataTypes Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
>
ReservedWords Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Retrieving Schema Metadata with the GetSchema Method
>
Restrictions Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
Columns Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
ForeignKeys Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
Indexes Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
PrimaryKeys Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
ProcedureParameters Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
Procedures Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
TablePrivileges Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
Tables Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
B. Getting Schema Information
>
Additional Schema Collections
>
Views Schema Collection
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Date, Time, and Timestamp Escape Sequences
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Date, Time, and Timestamp Escape Sequences
>
Example
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Scalar Functions
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Scalar Functions
>
Example
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Outer Join Escape Sequences
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
C. SQL Escape Sequences for .NET
>
Outer Join Escape Sequences
>
Example
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
D. Locking and Isolation Levels
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
D. Locking and Isolation Levels
>
Locking
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
D. Locking and Isolation Levels
>
Isolation Levels
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
D. Locking and Isolation Levels
>
Locking Modes and Levels
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Retrieving Data
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Retrieving Data
>
Retrieving Long Data
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Retrieving Data
>
Reducing the Size of Data Retrieved
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Retrieving Data
>
Using CommandBuilder Objects
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Retrieving Data
>
Choosing the Right Data Type
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Selecting .NET Objects and Methods
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Selecting .NET Objects and Methods
>
Using Parameter Markers as Arguments to Stored Procedures
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
>
Managing Connections
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
>
Opening and Closing Connections
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
>
Using Statement Caching
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
>
Using Commands Multiple Times
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Designing .NET Applications
>
Using Native Managed Providers
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Updating Data
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Updating Data
>
Using the Disconnected DataSet
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
E. Designing .NET Applications for Performance Optimization
>
Updating Data
>
Synchronizing Changes Back to the Data Source
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
F. Using an .edmx File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
F. Using an .edmx File
>
Code Examples
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
G. Bulk Load Configuration Files
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
G. Bulk Load Configuration Files
>
Sample Bulk Data Configuration File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
G. Bulk Load Configuration Files
>
XML Schema Definition for a Bulk Data Configuration File
Developer Reference
>
Data Access Methods
>
ADO.NET Data Providers
>
H. IANA Code Page Mappings