EDB Postgres™ Advanced Server .NET Connector Guide

The EDB Postgres™ Advanced Server .NET Connector distributed with EDB Postgres™ Advanced Server (Advanced Server) provides connectivity between a .NET client application and an Advanced Server database server. This guide provides installation instructions, usage instructions, and examples that demonstrate the functionality of the Advanced Server .NET Connector:

• How to connect to an instance of Advanced Server.

• How to retrieve information from an Advanced Server database.

• How to update information stored on an Advanced Server database.

This document assumes that you have a solid working knowledge of both C# and .NET. The Advanced Server .NET Connector functionality is built on the core functionality of the Npgsql open source project. The Npgsql User’s Manual is available online.

• What’s New
• Requirements Overview
  • Supported Server Versions
  • Supported Platforms
• The Advanced Server .NET Connector - Overview
  • The .NET Class Hierarchy
• Installing and Configuring the .NET Connector
  • Installing the .NET Connector
  • Configuring the .NET Connector
    • Referencing the Library Files
    • .NET Framework Setup
      • .NET Framework 4.0
      • .NET Framework 4.5
      • .NET Framework 4.5.1
      • .NET Standard 2.0
    • Entity Framework 5/6
    • EnterpriseDB VSIX for Visual Studio 2015/2017/2019
      • Installation and Configuration for Visual Studio 2015/2017/2019
      • Model First and Database First Usage
• Security and Encryption
  • Scram Compatibility
• Using the .NET Connector
• Opening a Database Connection
  • Connection String Parameters
  • Example - Opening a Database Connection using ASP.NET
  • Example - Opening a Database Connection from a Console Application
  • Example - Opening a Database Connection from a Windows Form Application
• Retrieving Database Records
  • Retrieving a Single Database Record
• Parameterized Queries
• Inserting Records in a Database
• Deleting Records in a Database
• Using SPL Stored Procedures in your .NET Application
  • Example - Executing a Stored Procedure without Parameters
  • Example - Executing a Stored Procedure with IN Parameters
  • Example - Executing a Stored Procedure with IN, OUT, and INOUT Parameters
• Using Advanced Queueing
  • Enqueue or Dequeue a message
    • Serve-side setup
    • Client-side sample
  • EDBAQ Classes
• Using a Ref Cursor in a .NET Application
• Using Plugins
  • GeoJSON
  • Json.NET
  • LegacyPostGIS
  • NetTopologySuite
  • NodaTime
  • RawPostGIS
• API Reference
• Conclusion