•  About This Document
  • What Are the Zen Data Providers?
  • Using This Guide
  • Typographical Conventions
•  Quick Start
  •  ADO.NET Data Providers Installed with Zen
    • Supported .NET Framework Versions
  • ADO.NET Data Providers Available with SDK Download
  •  Defining Basic Connection Strings
    • Notes
  •  Connecting to a Database
    • Example: Using the Provider-Specific Objects
    • Example: Using the Common Programming Model
    • Example: Using the Zen Common Assembly
  • Using the 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 Provider
  •  About the Zen ADO.NET Data Provider
    •  Namespace
      • C#
      • Visual Basic
    • Assembly Name
  •  Using Connection Strings with the 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 Parameter Data Types
    • Data Types Supported with Stream Objects
  • Using Streams as Input to Long Data Parameters
  • Parameter Markers
  • Parameter Arrays
•  The ADO.NET Core Data Provider
  • About the ADO.NET Core Data Provider
  • 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
•  The ADO.NET Entity Framework Data Provider
  •  About the ADO.NET Entity Framework Data Provider
    • Namespace
    • Assembly Names
  •  Configuring Entity Framework 6.1
    • Configuration File Registration
    • Code-Based Registration
    • Using Multiple Entity Framework Versions Against the Same Database
  •  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 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
    • Using Overloaded Stored Procedures
  •  Using .NET Objects
    • Creating a Model
  • For More Information
•  The ADO.NET Entity Framework Core Data Provider
  •  About the ADO.NET Entity Framework Core Data Provider
    • Namespace
    • Assembly Names
  • Configuring ADO.NET Entity Framework Core Data Provider
  •  Using Connection Strings with the 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
•  Using the 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
•  Using the Microsoft Enterprise Libraries
  •  Data Access Application Blocks
    • When Should You Use the DAAB?
    • Should You Use Generic or Database-specific Classes?
    •  Configuring the DAAB
      • Adding a New DAAB Entry
      • Adding the Data Access Application Block to Your Application
    • Using the DAAB in Application Code
  •  Logging Application Blocks
    • When Should You Use the LAB?
    • Configuring the LAB
    • Adding a New Logging Application Block Entry
    • Using the LAB in Application Code
  • Additional Resources
•  .NET Objects Supported
  • .NET Base Classes
  •  Data Provider-Specific Classes
    • PsqlBulkCopy
    • PsqlBulkCopyColumnMapping
    • PsqlBulkCopyColumnMappingCollection
    • PsqlCommand Object
    • PsqlCommandBuilder Object
    • PsqlConnection Object
    • PsqlConnectionStringBuilder Object
    • 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
•  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
•  SQL Escape Sequences for .NET
  •  Date, Time, and Timestamp Escape Sequences
    • Example
  •  Scalar Functions
    • Example
  •  Outer Join Escape Sequences
    • Example
•  Locking and Isolation Levels
  • Locking
  • Isolation Levels
  • Locking Modes and Levels
•  Designing .NET Applications for Performance Optimization
  •  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
    • 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
•  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
•  Glossary
  • .NET Architecture
  • ADO.NET
  • ADO.NET Entity Framework
  • assembly
  • bulk load
  • client load balancing
  • code access security (CAS)
  • common language runtime (CLR)
  • connection failover
  • connection pooling
  • connection retry
  • Data Access Application Block (DAAB)
  • destination table
  • entity
  • global assembly cache (GAC)
  • isolation level
  • load balancing
  • locking level
  • Logging Application Block (LAB)
  • managed code
  • namespace
  • Performance Monitor
  • stream
  • schema collection
  • strong name
  • unmanaged code

About This Document

Glossary