PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
HrenuS
Posts: 3
Joined: Mon 09 Feb 2015 09:57

PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by HrenuS » Mon 09 Feb 2015 10:07

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
Devart Team
Posts: 2125
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by Pinturiccio » Tue 10 Feb 2015 14:58

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

HrenuS
Posts: 3
Joined: Mon 09 Feb 2015 09:57

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by HrenuS » Wed 11 Feb 2015 03:51

Pinturiccio wrote: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
Devart Team
Posts: 2125
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by Pinturiccio » Wed 11 Feb 2015 12:59

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
Posts: 3
Joined: Mon 09 Feb 2015 09:57

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by HrenuS » Thu 12 Feb 2015 04:42

Pinturiccio wrote: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
Devart Team
Posts: 2125
Joined: Wed 02 Nov 2011 09:44

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Post by Pinturiccio » Fri 13 Feb 2015 11:34

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.

Post Reply