PostgreSQLDirect .NET Data Provider 2.50

Провайдер для доступа к базам данных PostgreSQL под .NET Framework.

PostgreSQLDirect .NET Data Provider ToolboxPostgreSQLDirect .NET is data provider to direct access to PostgreSQL database for the Microsoft .NET Framework and .NET Compact Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

PostgreSQLDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.

PostgreSQLDirect .NET uses native message-based protocol for communication with PostgreSQL server. It allows to create lightweight and fast applications working with PostgreSQL.

PostgreSQLDirect .NET provides functionality for connecting to PostgreSQL database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to PostgreSQL database.

PostgreSQLDirect .NET data provider is designed to be lightweight. It consists of a minimal layer between PostgreSQL database and your code. This extends functionality without sacrificing performance.

There are core objects that make up PostgreSQLDirect .NET data provider. Following is the description of those objects and their function.

  • PgSqlConnection - Establishes a connection to PostgreSQL database and can begin a transaction.
  • PgSqlCommand - Executes SQL statements at PostgreSQL database, and exposes parameters.
  • PgSqlDataReader - Exposes and reads a forward-only stream of data from PostgreSQL database.
  • PgSqlDataAdapter - Populates a DataSet and resolves updates with PostgreSQL database.
  • PgSqlTransaction - Enables you to enlist commands in transactions at PostgreSQL database.
  • PgSqlParameter - Defines input, output, and return value parameters for commands.
  • PgSqlException - Returned when an error is encountered at PostgreSQL database. For an error encountered at the client, PostgreSQLDirect .NET data provider throws a .NET Framework exception.

Along with the core classes listed in the preceding table, PostgreSQLDirect .NET data provider also contains the classes extending its base functionality and allowing to accomplish additional tasks.

  • PgSqlCommandBuilder - A helper object that will automatically generate command properties of PgSqlDataAdapter and populate the PgSqlParameters collection of PgSqlCommand object.
  • PgSqlDataTable - Provides all of the functionality needed to retrieve and manipulate data from a PostgreSQL server data source.
  • PgSqlScript - Serves to execute series of SQL statements separated by special symbols.
  • PgSqlLoader - Serves to load external data into the PostgreSQL database.
  • PgSqlDump - Serves to store a database or its parts as a script and also to restore database from the received script.
  • PgSqlMonitor - Allows to monitor dynamic SQL execution in applications that use PostgreSQLDirect .NET.
Key features

Following the main features of the PostgreSQL .NET Data Provider.

  • Direct access to PostgreSQL server
  • Doesn't require PostgreSQL client library and uses PostgreSQL protocol directly
  • 100% managed code
  • High performance
  • Easy to deploy
  • Supports the latest versions of PostgreSQL server
  • All PostgreSQL data types support
  • Stored functions support
  • Returning result sets from stored functions
  • Composite types support
  • .NET Compact Framework support
  • Mono Framework support
  • Advanced connection pooling feature
  • Fill DataSet with multiple query
  • PgSqlScript component to execute scripts
  • PgSqlLoader component for fast loading data
  • PgSqlDump component to backup and restore data
  • PgSqlDataTable component to retrieve and manipulate data
  • Base-Class-Based provider model
  • Ability to store data in PgSqlDataReader object
  • Ability to retrieve metadata information
  • Paginal access to query result
  • Asynchronous execution support
  • Named parameters support
  • Ability of monitoring query execution with DBMonitor
  • Advanced design-time editors
  • Dataset Wizard to leverage design-time setup
  • Generate DataSet Wizard
  • Support for Data Access Application Block in Enterprise Library
  • ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
  • TableMapping editor
  • Data preview
  • Advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
  • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
  • Help integrated into IDE
  • Free support for registered users during 1 year
  • Licensed per a developer without royalty fee


Опубликовал admin
26 Май, Пятница 2006г.



Программирование для чайников.