PostgreSQLDirect .NET Data Provider - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

PostgreSQLDirect .NET Data Provider by Devart (formerly Core Lab)

Full-featured ADO.NET provider for direct access to PostgreSQL servers for Microsoft .NET Framework and .NET Compact Framework. PostgreSQLDirect .NET 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

PostgreSQLDirect .NET 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.

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

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

PostgreSQLDirect .NET 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.

PostgreSQLDirect .NET 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 PostgreSQLDirect .NET 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 PostgreSQLDirect .NET V3.30x?

Visual Studio 2008 supported

Entity Framework Beta 3 supported

Added Licensing Information dialog

What’s new PostgreSQLDirect .NET 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

PostgreSQLDirect .NET V2.55.24 new features:

Now supports Windows Vista

PostgreSQLDirect .NET 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

PartNumbers: PC-516382-157001 516382-157001 PC-516382-157002 516382-157002 PC-516382-157004 516382-157004 PC-516382-157000 516382-157000 PC-516382-157005 516382-157005 PC-516382-157003 516382-157003 PC-516382-157006 516382-157006 PC-516382-157007 516382-157007 PC-516382-157008 516382-157008 PC-516382-157009 516382-157009 PC-516382-157010 516382-157010 PC-516382-157011 516382-157011 PC-516382-157012 516382-157012

PurchaseOptions: PostgreSQLDirect .NET Data Provider V3.7 - Standard Edition 1 Developer License - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider V3.7 - Standard Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider V3.7 - Professional Edition 1 Developer License - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider V3.7 - Professional Edition 1 Developer Upgrade License from Standard Edition (same version) , PostgreSQLDirect .NET Data Provider V3.7 - Professional Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider V3.7 - Mobile Edition 1 Developer License - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider V3.7 - Mobile Edition 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , PostgreSQLDirect .NET Data Provider Standard Subscription Renewals 1 Developer License Subscription Renewal , PostgreSQLDirect .NET Data Provider Standard Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , PostgreSQLDirect .NET Data Provider Professional Subscription Renewals 1 Developer License Subscription Renewal , PostgreSQLDirect .NET Data Provider Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , PostgreSQLDirect .NET Data Provider Mobile Subscription Renewals 1 Developer License Subscription Renewal , PostgreSQLDirect .NET Data Provider Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Resources: Read the PostgreSQLDirect .NET Data Provider License Agreement, Download the PostgreSQLDirect .NET Data Provider V3.7 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 Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, 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, .NET Framework 1.1, .NET Framework 1.0

Product Class: Business Components

Search Items: New Product Oct 05

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