dotConnect for PostgreSQL - Summary

by Devart (formerly Core Lab) - Product Type: Component / .NET Class / .NET Compact Framework / 100% Managed Code

Summary

dotConnect for PostgreSQL by Devart (formerly Core Lab)

Full-featured ADO.NET provider for direct access to PostgreSQL servers for Microsoft .NET Framework and .NET Compact Framework. dotConnect for PostgreSQL Data Provider supports .NET Framework 2.0 with ADO.NET 2 features. To reach high performance the provider uses a native message-based protocol for communication with the PostgreSQL server. It uses 100% managed code and doesn't require any client software. It provides extra functionality, monitoring abilities and offers advanced design-time extensions.

Overview

dotConnect for PostgreSQL is data provider to direct access to PostgreSQL database for the Microsoft .NET Framework and .NET Compact Framework. It 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.

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

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

Key features:

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

Composite types supported

Compact Framework support

Mono Framework support

Connection pooling feature

Fill DataSet with multiple query

PgSqlScript component to execute scripts

PgSqlLoader component for fast loading data

Paginal access to query result

Named parameters support

Ability of monitoring query execution by DBMonitor

Advanced design-time editors

Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard

Help integrated into Visual Studio .NET

Free support for registered users

Licensed per a developer without royalty fees

dotConnect for PostgreSQL supports PostgreSQL server from V7.1 to V8.0. The provider works with .NET Framework 1.0, 1.1, 2.0 and .NET Compact Framework.

dotConnect for PostgreSQL comes in three editions: Professional, Standard and Mobile. Standard edition includes ADO.NET core classes and classes for native data types only. Professional edition includes additional classes, design-time extensions and wizards. Mobile edition is the same as Standard but works with .NET Compact Framework.

What’s new dotConnect for PostgreSQL V4.65?

Integration with improved dbMonitor added

Implemented Ping method in PgSqlConnection class

Added orderid column for Site Map provider for custom map node ordering

Added some DataSet Wizard design-time improvements

Changed default behaviour of DataSet generation: if index is set as an expression, this index will be ignored

Fixed bug with MembershipProvider.GetAllUsers() method

Fixed bug with DataLink.DataSource property after regeneration of DataSet

What’s new dotConnect for PostgreSQL V4.5?

Added PgSqlAlerter class to handle LISTEN/NOTIFY commands

Now supports binary mode in PgSqlLoader

New database object types supported in PgSqlDump

Added PgSqlArray class to support PostgreSQL ARRAY data type

Added support for SSL connections

Added PgSqlLargeObject class to support PostgreSQL large objects

What’s new dotConnect for PostgreSQL V4.0x?

PostgreSQLDirect .NET renamed to dotConnect for PostgreSQL

Supported LINQ to PostgreSQL

Added Entity Developer for LINQ to PostgreSQL

What’s new dotConnect for PostgreSQL V3.7x?

Added DB server-based data paging for web applications

PgSqlDataSource design time improvements

ASP.NET demo pack added

PgSqlSelectStatement.TryParse method added

DataLink.DataSource property can refer to another DataLink component

What’s new dotConnect for PostgreSQL V3.30x?

Visual Studio 2008 supported

Entity Framework Beta 3 supported

Added Licensing Information dialog

What’s new dotConnect for PostgreSQL V3.25?

.NET Entity Framework Beta 2 supported

Visual Studio 2008 Beta 2 supported

Added Visual Basic versions to CRM, WinForms, and Web samples

Supported .NET Entity Framework

Added support for x64 architecture

Enhanced command builder with generation of row refresh statements

Added DbCommand.GetRecordCount() method to determine rows count of a request

Added INullable interface for provider specific types

Added capability to store connection strings in application settings

Extended drag'n'drop capabilities in DataSet Manager

Add-in menu moved to Visual Studio package

Demo projects reorganized

Added CRM (Customer Relationship Management) demo project

Added Ping demo project for Mobile Edition

dotConnect for PostgreSQL V2.55.24 new features:

Now supports Windows Vista

dotConnect for PostgreSQL V2.50.15 new features:

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard,

TableAdapter configuration, Query Builder and configuring web component SqlDataSource

Mono support added

Enterprise Library Data Access Application Block support added for Professional edition

ASP.NET 2.0 providers added for Professional edition: Membership Provider, Role provider, Session State Provider, Profile provider

Borland Delphi 2006 support added

EnterpriseDB Postgre SQL Server supported

Provider invariant name changed

Added streaming support for PgSqlScript

Added list of Frequently Asked Questions

Full-featured ADO.NET provider for direct access to PostgreSQL servers for Microsoft .NET Framework and .NET Compact Framework.

PartNumbers: PC-516382-256111 516382-256111 PC-516382-256124 516382-256124 PC-516382-256123 516382-256123 PC-516382-256112 516382-256112 PC-516382-256125 516382-256125 PC-516382-256114 516382-256114 PC-516382-256110 516382-256110 PC-516382-256130 516382-256130 PC-516382-256127 516382-256127 PC-516382-256128 516382-256128 PC-516382-256115 516382-256115 PC-516382-256129 516382-256129 PC-516382-256131 516382-256131 PC-516382-256113 516382-256113 PC-516382-256134 516382-256134 PC-516382-256133 516382-256133 PC-516382-256116 516382-256116 PC-516382-256117 516382-256117 PC-516382-256126 516382-256126 PC-516382-256118 516382-256118 PC-516382-256119 516382-256119 PC-516382-256132 516382-256132 PC-516382-256120 516382-256120 PC-516382-256121 516382-256121 PC-516382-256135 516382-256135 PC-516382-256122 516382-256122

PurchaseOptions: dotConnect for PostgreSQL Data Provider V4.65 - Standard Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Standard Edition 1 Developer Upgrade License from V2.x Standard Edition, dotConnect for PostgreSQL Data Provider V4.65 - Standard Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Standard Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Standard Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from from V2.x Standard Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Developer Upgrade License from Standard Edition, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Developer Upgrade License from V2.x Professional Edition, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 4 Developer Team Upgrade License from Standard Edition, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from from Standard Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Upgrade from from V2.x Professional Edition - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Mobile Edition 1 Developer License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Mobile Edition 1 Developer Upgrade License from V2.x Mobile Edition, dotConnect for PostgreSQL Data Provider V4.65 - Mobile Edition 4 Developer Team License - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider V4.65 - Mobile Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 1 Developer License Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 4 Developer Team License Subscription Renewal, dotConnect for PostgreSQL Data Provider Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Resources: Read the dotConnect for PostgreSQL License Agreement, Download the dotConnect for PostgreSQL V4.65 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, .NET Compact Framework, 100% Managed Code

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2005, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, C#Builder, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: Business Components

Keywords: crlab corelab SQL query language Database DB Management Database DB Connectivity Author corelab ADO.NET direct access PostgreSQL Postgre SQL