 |
| ||||
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 behaviour is changed: when a connection is terminated, PgSqlAlerter waiting process is terminated too and an exception is thrown
LinqConnect (formerly known as LINQ to PostgreSQL):
· The bug with enumerating queries that have empty result sets is fixed
· The bug with materializing query results into invalid object properties is fixed
· The query cache bug with distinguishing compiled queries that have nullable parameters is fixed
· The bug with deleting many-to-many links of entity having multiple many-to-many associations is fixed
Entity Developer:
· The b ehaviour is changed: the warning, related to the missing property setter, is disabled (LinqConnect models)
· The behaviour is changed: for the association, in which the many-side entity hasn't the primary key, the code and the mapping are not generated (LinqConnect models)
· The behaviour is changed: the properties, that correspond autoincrement fields, are generated with a ReadOnly keyword in VB.NET (LinqConnect models...
Via: dotConnect for PostgreSQL 6.1.40
