 |
| ||||
dotConnect for PostgreSQL Professional is a 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 Professinal can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider.
dotConnect for PostgreSQL Professional will allow users to build fast and lightweight applications working with PostgreSQL.
dotConnect for PostgreSQL Professional supports PostgreSQL server since 7.1 version to 8.0. The provider works with .NET Framework 1.0, 1.1, 2.0 and .NET Compact Framework, and can be used with the following devel opment environments:
· Microsoft Visual Studio .NET
· Borland Delphi 2005, Delphi 8
· Borland C#Builder
dotConnect for PostgreSQL Professional can be used together with UniDirect .NET, data provider that provides universal access to different databases within a single code.
Here are some key features of "dotConnect for PostgreSQL":
· 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 prov ider, 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
Requirements:
· NET Framework 2.0, 3.0, 3.5, and 4.0
· ADO.NET Entity Framework
Limitations:
· 30-day trial
What's New in This Release: [ read full changelog ]
· The bug with formatting the timestamp data when generating the script for user creation during PgSqlDump.Backup() is fixed
· The bug with formatting the string data with escape characters during PgSqlDump.Backup() is fixed
· The bug with generating invalid overload of the PgSqlDataTable constuctor when using Devart DataSet Wizard is fixed
· The bug, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter, is fixed
LinqConnect (formerly known as LINQ to PostgreSQL):< br /> · The bug related to the "Object does not match target type" exception when working with DbLinqDataSources and gridviews is fixed
· The bug with the implicitly converting strings to integer type in queries when working with VB.NET projects is fixed
· The bug related to the "Unsupported delete rule 'NO ACTION'" exception when creating DataContext is fixed
· The bug with update comman...
Via: dotConnect for PostgreSQL 6.3.146
