Devart Forums

Posted: **Wed 06 Apr 2011 08:10**

serial type, including tables, Fill () is executed.

we are using:
Devart.Data: 5.0.227.0
Devart.Data.PostgreSql: 5.10.126.0
PostgreSQL 8.4

Code: Select all

CREATE TABLE table1
(
   id serial, 
    PRIMARY KEY (id)
)

Use the DataSet Wizard, DataSet1 created.

Code: Select all

DataSet1 ds = new DataSet1();

try
{
	ds.table1.Fill();
}
catch (Exception ex)
{
	System.Diagnostics.Debug.WriteLine(ex.Message);
}

For System.FormatException is inside thrown, Fill() is slow.
We can not avoid the exception coding can improve performance.

Posted: **Fri 08 Apr 2011 17:06**

Thank you for the report, we have reproduced the issue. We will analyze the situation and inform you about the results.

Posted: **Tue 19 Apr 2011 12:11**

We have fixed this issue, no FormatExceptions should be thrown now (provided that no actual errors occurred). The fix is available in the new 5.10.141 version of dotConnect for PostgreSQL. The new build can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For more information about the fixes and improvements available in dotConnect for PostgreSQL 5.10.141, please refer to
http://www.devart.com/forums/viewtopic.php?t=20791

Posted: **Mon 25 Apr 2011 06:40**

Thanks for the quick response.

The query performance has improved!
Personally I am glad that became clear the output window.

Devart Forums

PgSqlDataReader throwing a System.FormatException

PgSqlDataReader throwing a System.FormatException