Search Results for

    Show / Hide Table of Contents

    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 Datasets.

    NpgsqlDatabaseInfo

    Base class for implementations which provide information about PostgreSQL and PostgreSQL-like databases (e.g. type definitions, capabilities...).

    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.

    NpgsqlGeoJSONExtensions

    Extension allowing adding the GeoJSON plugin to an Npgsql type mapper.

    NpgsqlJsonNetExtensions

    Extension allowing adding the Json.NET plugin to an Npgsql type mapper.

    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.

    NpgsqlLegacyPostgisExtensions

    Extension adding the legacy PostGIS types to an Npgsql type mapper.

    NpgsqlLengthCache

    An array of cached lengths for the parameters sending process.

    When sending parameters, lengths need to be calculated more than once (once for Bind, once for an array, once for the string within that array). This cache optimized that. Lengths are added to the cache, and then retrieved at the same order.

    NpgsqlNetTopologySuiteExtensions

    Extension allowing adding the NetTopologySuite plugin to an Npgsql type mapper.

    NpgsqlNodaTimeExtensions

    Extension adding the NodaTime plugin to an Npgsql type mapper.

    NpgsqlNoticeEventArgs

    Provides data for a PostgreSQL notice event.

    NpgsqlNotificationEventArgs

    Provides information on a PostgreSQL notification. Notifications are sent when your connection has registered for notifications on a specific channel via the LISTEN command. NOTIFY can be used to generate such notifications, allowing for an inter-connection communication channel.

    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

    NpgsqlParameter<T>

    A generic version of NpgsqlParameter which provides more type safety and avoids boxing of value types. Use TypedValue instead of Value.

    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)

    NpgsqlRawPostgisExtensions

    Extension adding the legacy PostGIS types to an Npgsql type mapper.

    NpgsqlReadBuffer

    A buffer used by Npgsql to read data from the socket efficiently. Provides methods which decode different values types and tracks the current position.

    NpgsqlRowUpdatedEventArgs

    NpgsqlRowUpdatingEventArgs

    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.

    NpgsqlWriteBuffer

    A buffer used by Npgsql to write data to the socket efficiently. Provides methods which encode different values types and tracks the current position.

    PostgresErrorCodes

    Provides constants for PostgreSQL error codes.

    PostgresException

    The exception that is thrown when the PostgreSQL backend reports errors (e.g. query SQL issues, constraint violations).

    PostgresNotice

    PostgreSQL notices are non-critical messages generated by PostgreSQL, either as a result of a user query (e.g. as a warning or informational notice), or due to outside activity (e.g. if the database administrator initiates a "fast" database shutdown).

    Structs

    NpgsqlTimeout

    Represents a timeout that will expire at some point.

    Interfaces

    INpgsqlDatabaseInfoFactory

    A factory which get generate instances of NpgsqlDatabaseInfo, which describe a database and the types it contains. When first connecting to a database, Npgsql will attempt to load information about it via this factory.

    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 a method that handles the Notice event.

    NotificationEventHandler

    Represents a method that handles the Notification event.

    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

    ProvidePasswordCallback

    Represents the method that allows the application to provide a password at connection time in code rather than configuration

    In This Article
    Back to top © Copyright 2022 The Npgsql Development Team