PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

[HrenuS]

Hello. We want to buy your product. But prevents the following problem. There is a line connecting the schemes.

Code: Select all

var conn = new PgSqlConnection ("Server = ***; Port = 5433; User Id = ***; password = ***; Schema = mySchema1, mySchema2; Database = ***; Unicode = true;");
Try to load settings.
conn.Open ();
var cmd = new PgSqlCommand ("StoreProcInSchema2", conn);
cmd.CommandType = CommandType.StoredProcedure;
PgSqlCommandBuilder.DeriveParameters (cmd);

we obtain:
An unhandled exception of type 'System.InvalidOperationException' occurred in Devart.Data.PostgreSql.dll

Additional information: Function StoreProcInSchema2 not found.

If you change the connection string and put mySchema2 in the first place, then everything is OK!

Code: Select all

var conn = new PgSqlConnection ("Server = ***; Port = 5433; User Id = ***; password = ***; Schema = mySchema2, mySchema1; Database = ***; Unicode = true;");
Try to load settings.
conn.Open ();
var cmd = new PgSqlCommand ("StoreProcInSchema2", conn);
cmd.CommandType = CommandType.StoredProcedure;
PgSqlCommandBuilder.DeriveParameters (cmd); - OK!

[Pinturiccio]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

[HrenuS]

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Well, we will wait for the results.

[Pinturiccio]

We have fixed the bug with the PgSqlCommandBuilder.DeriveParameters method, when more than one schema is set in a connection string and the corresponding schema name is not used in command text. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

[HrenuS]

We have fixed the bug with the PgSqlCommandBuilder.DeriveParameters method, when more than one schema is set in a connection string and the corresponding schema name is not used in command text. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

Thank you!

[Pinturiccio]

New build of dotConnect for PostgreSQL 7.3.352 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=31279.