EDB .NET Connector

The EDB .NET Connector distributed with EDB Postgres Advanced Server provides connectivity between a .NET client application and an EDB Postgres Advanced Server database server. You can:

• Connect to an instance of EDB Postgres Advanced Server.

• Retrieve information from an EDB Postgres Advanced Server database.

• Update information stored on an EDB Postgres Advanced Server database.

To understand these examples, you need a solid working knowledge of C# and .NET. The EDB .NET Connector functionality is built on the core functionality of the Npgsql open source project. For details, see the

Npgsql User Guide .

release_notes requirements_overview the_advanced_server_net_connector_overview installing_and_configuring_the_net_connector using_the_net_connector opening_a_database_connection retrieving_database_records parameterized_queries inserting_records_in_a_database deleting_records_in_a_database using_spl_stored_procedures_in_your_net_application using_advanced_queueing using_a_ref_cursor_in_a_net_application using_plugins using_object_types scram_compatibility advanced_server_net_connector_logging api_reference conclusion

• Release notes
• Product compatability
• The EDB .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 6.0
    • .NET 5.0
    • .NET Core 3.1
    • .NET Standard 2.0
    • .NET Standard 2.1
    • .NET EntityFramework Core
• 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
    • Using the EDBCommand object to execute a stored procedure
  • Example: Executing a stored procedure with IN parameters
    • Passing input values to a stored procedure
  • Example: Executing a stored procedure with IN, OUT, and INOUT parameters
    • Creating the stored procedure
    • Receiving output values from a stored procedure
• Using advanced queueing
  • Enqueueing or dequeueing a message
    • Server-side setup
    • Client-side example
  • EDBAQ classes
• Using a ref cursor in a .NET application
  • Creating the stored procedure
• Using plugins
  • GeoJSON
  • Json.NET
  • LegacyPostGIS
  • NetTopologySuite
  • NodaTime
  • RawPostGIS
• Using object types in .NET
  • Using an object type
• Scram compatibility
• EDB .NET Connector logging
  • Console logging to standard error
  • Writing a custom logger
• API reference