Namespace Npgsql
Classes
NpgsqlBinaryExporter
Provides an API for a binary COPY TO operation, a high-performance data export mechanism from a PostgreSQL table. Initiated by BeginBinaryExport(String)
NpgsqlBinaryImporter
Provides an API for a binary COPY FROM operation, a high-performance data import mechanism to a PostgreSQL table. Initiated by BeginBinaryImport(String)
NpgsqlCommand
Represents a SQL statement or function (stored procedure) to execute against a PostgreSQL database. This class cannot be inherited.
NpgsqlCommandBuilder
This class is responsible to create database commands for automatic insert, update and delete operations.
NpgsqlConnection
This class represents a connection to a PostgreSQL server.
NpgsqlConnectionStringBuilder
Provides a simple way to create and manage the contents of connection strings used by the NpgsqlConnection class.
NpgsqlConnectionStringPropertyAttribute
Marks on NpgsqlConnectionStringBuilder which participate in the connection string. Optionally holds a set of synonyms for the property.
NpgsqlCopyTextReader
Reader for a text export, initiated by BeginTextExport(String).
NpgsqlCopyTextWriter
Writer for a text import, initiated by BeginTextImport(String).
NpgsqlDataAdapter
This class represents an adapter from many commands: select, update, insert and delete to fill
NpgsqlDataReader
Reads a forward-only stream of rows from a data source.
NpgsqlException
The exception that is thrown when server-related issues occur.
NpgsqlFactory
A factory to create instances of various Npgsql objects.
NpgsqlLargeObjectManager
Large object manager. This class can be used to store very large files in a PostgreSQL database.
NpgsqlLargeObjectStream
An interface to remotely control the seekable stream for an opened large object on a PostgreSQL server. Note that the OpenRead/OpenReadWrite method as well as all operations performed on this stream must be wrapped inside a database transaction.
NpgsqlNoticeEventArgs
Provides data for a notice event.
NpgsqlNotificationEventArgs
EventArgs class to send Notification parameters.
NpgsqlOperationInProgressException
Thrown when trying to use a connection that is already busy performing some other operation. Provides information on the already-executing operation to help with debugging.
NpgsqlParameter
This class represents a parameter to a command that will be sent to server
NpgsqlParameterCollection
Represents a collection of parameters relevant to a NpgsqlCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited.
NpgsqlRawCopyStream
Provides an API for a raw binary COPY operation, a high-performance data import/export mechanism to a PostgreSQL table. Initiated by BeginRawBinaryCopy(String)
NpgsqlRowUpdatedEventArgs
NpgsqlRowUpdatingEventArgs
NpgsqlSnakeCaseNameTranslator
A name translator which converts standard CLR names (e.g. SomeClass) to snake-case database names (some_class)
NpgsqlStatement
Represents a single SQL statement within Npgsql.
Instances aren't constructed directly; users should construct an NpgsqlCommand object and populate its CommandText property as in standard ADO.NET. Npgsql will analyze that property and constructed instances of NpgsqlStatement internally.
Users can retrieve instances from Statements and access information about statement execution (e.g. affected rows).
NpgsqlTransaction
Represents a transaction to be made in a PostgreSQL database. This class cannot be inherited.
PostgresException
The exception that is thrown when the PostgreSQL backend reports errors (e.g. query SQL issues, constraint violations).
PostgresNotice
A non-critical (warning or info) message generated by the backend. Can be synchronous (i.e. in response to a query) or asynchronous (a totally unrelated backend-side event).
Interfaces
INpgsqlNameTranslator
A component which translates a CLR name (e.g. SomeClass) into a database name (e.g. some_class) according to some scheme. Used for mapping enum and composite types.
Enums
ServerCompatibilityMode
An option specified in the connection string that activates special compatibility features.
SslMode
Specifies how to manage SSL.
StatementType
Specifies the type of SQL statement, e.g. SELECT
TargetServerType
Specifies connection server.
Delegates
NoticeEventHandler
Represents the method that handles the Notification events.
NotificationEventHandler
Represents the method that handles the Notification events.
NpgsqlRowUpdatedEventHandler
Represents the method that handles the RowUpdated events.
NpgsqlRowUpdatingEventHandler
Represents the method that handles the RowUpdating events.
ProvideClientCertificatesCallback
Represents the method that allows the application to provide a certificate collection to be used for SSL client authentication