PostgreSQLDirect .NET History

3.75.33 26-Sep-08

Fixed bug with UniqueConstraint generation in DataSet Wizard
Fixed bug with wrong AllowDBNull mapping in DataSet Wizard
Fixed bug with wrong Relation generation after changing column mapping

3.75.32 09-Sep-08

Fixed bug with Preview Data in DataSet and DataAdapter components when data exceeds the System.Decimal's scale

Entity Framework support

Supported views in EDM Wizard
Now objects in edmx models can be named without the database prefix
Improved object sorting and grouping in EDM Wizard

3.75.31 29-Aug-08

Fixed bug with context menu in the DataSet Manager

Entity Framework support

EDM Wizard now can work with several schemas
Supported Entity SQL canonical functions: Left, Year, Month, Hour, Minute, Second, Millisecond
Fixed bug with updating entities in concurrency mode

3.75.30 20-Aug-08

Supported .NET Framework 3.5 Service Pack 1
Supported Visual Studio 2008 Service Pack 1
Implemented GetGuid(), GetByte(), and GetChar() methods in PgSqlDataReader

Entity Framework support

Supported inserting, updating, and deleting entities with stored procedures
Supported user-defined PL/pgSQL functions that return REFCURSOR
Supported user-defined PL/pgSQL functions that return unspecified row type
Supported user-defined SQL queries as functions in SSDL
Supported Create Function Import dialog
PostgreSQL type UUID is now mapped to System.Guid
PostgreSQL type ENUM is now mapped to System.String
PostgreSQL types TIME, TIME WITH TIME ZONE, and INTERVAL are now mapped to System.TimeSpan

3.70.29 18-Jul-08

Fixed bug with connection strings from app.config and Server Explorer
Fixed bug with DataSet Wizard in Visual Studio 2008
Unified provider name in Visual Studio 2008 (CoreLab.PostgreSql instead of CoreLab.PostgreSql.Entity)
Fixed bug with executing queries with comments

Entity Framework support

Supported StoreGeneratedPattern attribute with values Identity and Computed (PostgreSQL version 8.2 and above)
Fixed bug with simultaneous usage of Skip() and Take() methods
Fixed type mapping in EntityKey.EntityKeyValues

3.70.28 25-Jun-08

Connection strings from web.config are now available in Visual Studio 2008 design time
Improved PgSqlDataSource design time capabilities

3.70.27 04-Jun-08

Fixed bug with PostgreSQLDirect .NET Data Provider missing in the EDM wizard
Fixed bug with inserting a row in DbDataTable when a filter is enabled

3.70.26 29-May-08

Supported .NET Framework 3.5 Service Pack 1 Beta
Supported Visual Studio 2008 Service Pack 1 Beta
Improved support for ADO.NET Entity Framework

3.50.25 19-Mar-08

Fixed bug with licensing in Delphi for .NET and RAD Studio 2007

3.50.24 26-Feb-08

Added DB server-based data paging for ASP.NET applications
PgSqlDataSource design time improvements
ASP.NET demo pack added
PgSqlSelectStatement.TryParse method added
DataLink.DataSource property can refer to another DataLink component
Fixed bug with executing Entity Framework queries
Fixed bug with DbDataTable and some visual controls
Fixed bug with DbDataTable.FillPage method

3.30.23 20-Dec-07

Visual Studio 2008 supported
Entity Framework Beta 3 supported
Added Licensing Information dialog

3.25.22 13-Dec-07

Improved compatibility with PostgreSQL server version 8.3
Fixed bug with the PgSqlDataAdapter.Fill method in Mono
Fixed bug with compiling web applications in CodeGear RAD Studio 2007
Fixed bug with samples
Fixed bug with DataSet Wizard when editing standard DataSets

3.25.21 20-Nov-07

Fixed bug with PgSqlDataReader.GetSchemaTable method when executing stored functions
Fixed bug with filling DataSet using PgSqlDataAdapter with TableMappings
Fixed bug with filling DataSet asynchronously
Fixed bug with hidden columns in DataSet Wizard
Fixed bug with DataSet generator
Fixed bug with .NET Entity Framework support
Fixed bug with licensing in multithreaded applications

3.25.20 05-Nov-07

Fixed bug with schema generator for .NET Entity Framework
Fixed bug with case sensitive names in DbDataTable.ParentRelation

3.25.19 25-Oct-07

.NET Entity Framework Beta 2 supported
Visual Studio 2008 Beta 2 supported
Added Visual Basic versions to CRM, WinForms, and Web samples
Fixed bug with editing filtered and sorted DbDataTable
Fixed bug with design time editors of DbDataTable.ParentRelation
Fixed bug with editing relation resultset with DataLink
Fixed bug with building Refresh SQL when TableMappings are used
Fixed bug with editing PgSqlConnection in design time
Fixed bug with columns containing question mark
Fixed bug with serial and bigserial fields in Integration Services Project
Added scheme creation SQL statements to dump text

3.20.18 19-Sep-07

Bug with Enterprise Library missing in the installation fixed
Bug with Visual Studio 2005 integration fixed
Bug with PgSqlDataTable design time fixed
Bug with DataSet Wizard fixed
Bug with InterForm design time fixed

3.20.17 04-Sep-07

Bug with PgSqlDataTable component designer fixed

3.20.16 30-Aug-07

Supported Visual Studio codename Orcas Beta 1
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

3.00.10 19-Jun-07

Bug with fetching big numeric types fixed
Bug with changing serial records
Bug with Membership.GetNumberOfUsersOnline() method fixed
Bug with MembershipUser.IsOnline property fixed

3.00.9 30-May-07

Bug with DbDataSet.ReadXml() fixed
Bug with closing IDbDataReader in DbDataTable fixed
Bug with 7.x server relations in DDEX fixed
Bug with TIMESTAMP and TIME fields on some Linux servers fixed
Bug with PgSqlDataReader.GetSchemaTable() fixed
Bug with PgSqlSelectStatement fixed
Bug with PgSqlDump.Backup() fixed

3.00.8 13-Apr-07

Application development enhancement

Added DataSet Manager to control dataset instances in the project
Added DataSet Editor for convenient datasets manipulation
New PgSqlDataSet class to use with PgSqlDataTable
New component DataLink added for flexible data binding
New capabilities added to PgSqlDataTable class
Added capability for cross-form components cooperation
Design time visualization extended
Supported addin and DataSet Wizard integration with Borland Developer Studio

.NET 2 features

Added PgSqlDependency class to support Database Change Notification
Added PgSqlDataSourceEnumerator class to support Server Enumeration feature
Added support for Batch Update in PgSqlDataAdapter
Added support for returning provider-specific types in PgSqlDataReader and PgSqlDataAdapter

Other features

SQL Server 2005 Business Intelligence Solutions supported
Added PgSqlSelectStatement class for building SELECT statements
Added PgSqlTimeStamp class to represent TIMESTAMP and DATE types
Added list of hosts in connection form and connection properties
Added PgSqlLoader.LoadTable() method
Base level classes moved to the new assembly CoreLab.Data.dll
New demo projects added
Added DbLoader class that serves to load external data into database
Added PostgreSQLDirect .NET information to Visual Studio 2005 splash screen and About box
Bug with SQL expressions in SELECT statements fixed
Bug with creating Table Adapters with PostgreSQLDirect .NET DataSet Wizard fixed

2.55.25 01-Mar-07

Bug with using stored functions in UPDATE/DELETE/INSERT commands of TableAdapter in DataSet Designer fixed
Bug with using stored functions with unnamed parameters in Server Explorer fixed

2.55.24 25-Jan-07

Bug with installation on Vista x64 edition fixed
Bug with retrieving password in PgSqlMembershipProvider fixed
Bug with creating DataSet with tables and relations through DDEX fixed

2.55.23 12-Dec-06

Windows Vista support added

2.50.22 24-Nov-06

Bug with case-sensitive UserName, Email, ApplicationName, RoleName in Web providers fixed
Bug with removing items in PgSqlSessionStateStore provider fixed
Bug with error message when decryption key is not defined in PgSqlMembershipProvider fixed
Bug with adding a request with parameters to DataAdapter in DataSet fixed
Bug with creating Update and Delete commands for DataAdapter in DataSet fixed
Bug with reading out data in FetchAll=false mode fixed
Bug with handling broken connections in connection pool fixed

2.50.21 19-Sep-06

Data Design Extensibility (DDEX) features supported for Visual Studio 2005 Standard Edition
Fixed bug with PgSqlCommandBuilder for queries with FROM ONLY clause

2.50.20 08-Sep-06

Data Design Extensibility features included in Standard Edition of PostgreSQLDirect .NET
Fixed bug with Visual Studio integration
Fixed bug with converting NULL DateTime values
Fixed bug with connection after command timeout error

2.50.19 23-Aug-06

Fixed bug with filling DataSet with Interval type data
Fixed bug with retrieving relations in DataSet Wizard

2.50.18 04-Aug-06

Fixed bug with DataSet Wizard
Returned metadata structure for PgSqlConnection.GetSchema has been changed
Fixed bug with PgSqlDataAdapter.BatchUpdateSize initial value (was 0)
Fixed bug with infinity and -infinity DateTime values
Fixed bug with PgSqlDataReader.GetSchemaTable
Fixed bug with converting C++ samples in Visual Studio 2005
Bug with creating Table Adapters with PostgreSQLDirect .NET DataSet Wizard fixed
Bug with SQL expressions in SELECT statements fixed

2.50.17 25-Jul-06

Fixed bug with using stored functions in Data Source Wizard
Fixed bug with mapping NULL columns in parameters
Fixed bug with processing empty string fields

2.50.16 22-May-06

Bug with Initial Schema parameter in ConnectionString for .NET Framework 1.x fixed
Fixed bug with PgSqlConnection.GetSchema for "Indexes" and "Groups" arguments
Fixed bug with getting int2vector and oidvector values
Fixed bug with using stored functions in DataSource Wizard

2.50.15 17-Apr-06

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
ASP.NET 2.0 providers added: Membership Provider, Profile Provider, Role Provider, Session State Provider
DataSet Wizard added
Enterprise Library Data Access Application Block support added
Mono support added
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
Bug with setting empty parameter in connection string fixed
Bug with fetching oidvector values for PostgreSQL 8.0 and later fixed
Bug with finalizators fixed
Bug with licensing in Std version for .NET2 Framework fixed
Bug with .NET and .NET2 versions compatibility fixed
Bug with mixed case in database objects names fixed
Bug with parameters regenerating in PgSqlDataAdapter editor fixed
Bug with DataSet generator fixed

2.40.14 08-Feb-06

Bug with licensing fixed
Bug with PgSqlCommand.FetchSize property fixed
Fixed broken links to documentation
Incompatibility issues with .NET Framework and Mono fixed

2.40.13 20-Dec-05

Supported .NET Framework 2.0 release version
Supported Visual Studio 2005 release version
Supported PostgreSQL server 8.1 release version
Supported Pervasive Postgres SQL server
Compact .NET Framework 2.0 supported
Added support for InputOutput parameters
Bug with update from NULL value in Preview Data form of DataAdapter fixed
Precision of PgSqlInterval class increased due to bigger maximal days number

2.20.12 17-Oct-05

NULLs are not treated as empty strings on data fetch any more
Bug with generating dataset schema in case of multiple columns with the same name fixed

2.20.11 12-Oct-05

Bug with generating dataset schema fixed

2.20.10 30-Sep-05

Composite types supported
Tested with Mono Framework
Bug with PgSqlConnection.GetSchema() method fixed
Bug with setting transaction isolation level fixed
Bug with updating fields with user defined types fixed
Bug with converting double type values fixed

2.11.9 29-Jul-05

Bug with generating update commands on quoted table names fixed

2.11.8 01-Jul-05

PgSqlCommandBuilder.UpdatingFields property added
CoreLab.PostgreSql.PgSqlLoader now inherits from CoreLab.Common.DbLoader
Bug with reading unicode characters fixed
Bug with TEXT type column size fixed
Bug with generation update commands for geometric type columns fixed

2.10.7 08-Jun-05

Bugs with values conversion fixed

2.10.6 30-May-05

Support for Microsoft Visual Studio 2005 Beta 2 added
Publisher policy file added for versions compatibility
Bug with cross-database reference in PgSqlCommandBuilder fixed
Bug with integer values conversion in PgSqlDataReader fixed
Bug with precision in interval values fixed

2.10.5 28-Apr-05

Bug with Unicode strings for PostgreSQL 7.2 fixed
Bug with "Bit" type values fixed

2.10.4 12-Apr-05

Bug with fetching "Bit" type values in binary format fixed
Bug with getting count of bytes in PgSqlDataReader.GetBytes() method fixed
Bug with named parameters for stored procedures fixed

2.10.3 30-Mar-05

Performance increased
Output parameters support added
"DefaultValue" column in GetSchemaTable() result added
Bug with PgSqlException serialization fixed
Bug with timestamp type fixed
Bug with upper case database name fixed
Bug causing memory leaks on server fixed

2.00.2 25-Feb-05

Bug with GetSchemaTable for PostgreSQLDirect server version 7.2 fixed
Bug with numeric type conversion fixed
Bug with CommandBehavior fixed
Bug with PgSqlCommand.Prepare fixed

2.00.1 09-Feb-05

Support composite types(row types) result set in stored procedures
Bug with GetSchemaTable fixed
Bug with timestamp converting fixed
Bug with PgSqlLoader fixed
Bug with PgSqlDump fixed

2.00.0 24-Jan-05

Support for .NET Framework 2.0 added
Support for Microsoft Visual Studio .NET 2005 Beta 1
Support for Borland Delphi 2005
Support ADO.NET 2 features including:
Support for metadata schemas added
The Base-Class-Based provider model used
Connection pooling enhancements functionality added, that allows you to programmatically "drain" the connection pool
New PgSqlConnectionStringBuilder component to build connection strings to represent data sources
PostgreSQL 8.0 support added
Support for transferring data in binary format added
PgSqlInterval type added
Performance increased due to using binary format of transferring data for protocol 3.0 and optimizing data conversion for protocol 2.0
PgSqlConnection.AutoCommit is obsolete (not supported since server version 7.4)

1.85.3 07-Dec-04

Bug with quoting fixed

1.85.2 29-Nov-04

Bug with notification messages fixed
Bug with PgSqlDump.QuoteIdentifier fixed
Bug with interval types conversion fixed
PgSqlException deserialization constructor added

1.85.1 22-Oct-04

PgSqlCommand.InsertOid property added
Bug with prepared statements fixed
Bug with BLOB distortion fixed
Bug with geometry types fixed
Bug with loader fixed
Bug with type conversion fixed

1.85.0 22-Sep-04

Support for multiple ExecuteReader added
New component PgSqlDataTable added
New methods for asynchronous working added
Support for paginal access to query result added
Support for command timeout added
Bug with connection timeout fixed

1.80.1 02-Jul-04

Bug with connection pooling fixed
Bug with component deserialization for Compact Framework fixed
Bug with timestamp types conversion fixed
Bug with connect to PostgreSQL server 7.2 fixed
Bug with special chars in command parameters fixed

1.80.0 07-Jun-04

Support for Compact Framework added
PgSqlDataReader.HasRows property added
Support for connection timeout added

1.70.0 17-May-04

PostgreSQL 7.4 protocol was supported
Full PostgreSQL 7.4 error information
Native PostgreSQL 7.4 parameters and unnamed parameters added
Unicode property was added to PgSqlConnection class
Charset property was added to PgSqlConnection class
AutoCommit property was added to PgSqlConnection class
FetchAll property was added to PgSqlCommand class
New component PgSqlScript added
New component PgSqlLoader added
New component PgSqlDump added
Connection pooling was improved
C++ sample added

1.51.0 12-Feb-04

Support for Borland Delphi 8 added

1.50.4 26-Jan-04

Bug with custom update commands in DataAdapter was fixed

1.50.3 22-Jan-04

Bug with Migration Wizard was fixed

1.50.2 09-Jan-04

Fixed bug with update quoted table names
Bug with update tables with multiple key fields was fixed
Database name was removed from table name inside automatic generated updates

1.50.1 23-Dec-03

Fixed bug with generating automatic updates
Bug with MD5 authentication was fixed
GetSchemaTable from multiply SELECT queries added
Fixed bug with Fill dataset from multiply SELECT queries

1.50.0 18-Dec-03

PostgreSQL 7.4 support
Support for connection pooling added
MD5 and Crypt user authentication methods available
GetSchemaTable with full KeyInfo added
Batch execution of multiply SELECT statements enabled
New structures and classes for geometric and LOB types were added
New component PgSqlMonitor was added
Enhanced connection editor enabled
Documentation integrated into Visual Studio .NET
XML documentation for code completion added
New sample applications added
Support for Borland C#Builder added

1.10.4 04-Nov-03

Bug with hanging up PgSqlDataReader on attempt to call Close() method after all data was fetched fixed

1.10.3 23-Oct-03

Fixed bug with closing connection before data reader was closed
PgSqlDataReader.Close() method call not necessary if all data was fetched
Bug with insert NULL values was fixed
Bug with connection pooling was fixed
Bug with fetch large number of date datatype fields was fixed

1.10.2 15-Oct-03

Performance was greatly improved
Invalid date format bug was fixed

1.10.1 14-Jul-03

Bug with large fetch data was fixed

1.10 24-Jun-03

Visual Studio .NET 2003 support added
Property editors for PgSqlCommandBuilder.KeyFields and PgSqlCommandBuilder.UpdatingTable added

1.00 10-Apr-03

First release of PostgreSQLDirect .NET data provider