Web Search
Quick Start
Supported .NET Framework Versions
Defining Basic Connection Strings
Connecting to a Database
Using the ADO.NET Entity Framework Data Provider
Using the Data Providers
About the Data Providers
Using Connection Strings
Stored Procedures
Using IP Addresses
Transaction Support
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
Using Statement Caching
Using Connection Failover
Using Client Load Balancing
Using Connection Retry
Configuring Connection Failover
Setting Security
Using PSQL Bulk Load
Using Diagnostic Features
The ADO.NET Data Provider
About the PSQL ADO.NET Data Provider
Using Connection Strings with the ADO.NET Data Provider
Performance Considerations
Data Types
Using Streams as Input to Long Data Parameters
Parameter Markers
Parameter Arrays
The ADO.NET Entity Framework Data Provider
About the ADO.NET Entity Framework Data Provider
Configuring Entity Framework 6.0
Using Connection Strings with the PSQL ADO.NET Entity Framework Data Provider
Code First and Model First Support
Using Code First Migrations with the ADO.NET Entity Framework
Using Enumerations with the ADO.NET Entity Framework
Mapping Data Types and Functions
Extending Entity Framework Functionality
Enhancing Entity Framework Performance
Using Stored Procedures with the ADO.NET Entity Framework
Using .NET Objects
For More Information
Using the PSQL Data Providers in Visual Studio
Adding Connections
Using the PSQL Performance Tuning Wizard
Using Provider-Specific Templates
Using the PSQL Visual Studio Wizards
Adding Components from the Toolbox
Data Provider Integration Scenario
Using the Microsoft Enterprise Libraries
Data Access Application Blocks
Logging Application Blocks
Additional Resources
.NET Objects Supported
.NET Base Classes
Data Provider-specific Classes
PSQL Common Assembly Classes
Getting Schema Information
Columns Returned by the GetSchemaTable Method
Retrieving Schema Metadata with the GetSchema Method
Additional Schema Collections
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 .NET Applications for Performance Optimization
Retrieving Data
Selecting .NET Objects and Methods
Designing .NET Applications
Updating Data
Using an .edmx File
Code Examples
Bulk Load Configuration Files
Sample Bulk Data Configuration File
XML Schema Definition for a Bulk Data Configuration File
IANA Code Page Mappings
IANA Code Page Names
Glossary