PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

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

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

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

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

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

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

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

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

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

Re: PgSqlCommandBuilder.DeriveParameters(PgSqlcommand cmd) problem!

Postby 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/postgresql/download.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.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL