Selecting information from 2 DB´s

Selecting information from 2 DB´s

Postby JORGEMAL » Thu 30 Jan 2014 15:53

Is it possible to perform a select statement to retrieve data from 2 databases located in 2 different servers and get the result in, let´s say, one DataReader or one DataTable?

One approach for getting the information into a DataTable is to perform 2 selects, fill 2 different DataTables and, finally, do a DataTable merge. However, I am interested in knowing if there is an approach to do all this in only one step, with one query, one pgsqlConnection, one pgsqlCommand.

Respectfully,
Jorge Maldonado
JORGEMAL
 
Posts: 165
Joined: Thu 03 Jul 2008 23:55

Re: Selecting information from 2 DB´s

Postby Pinturiccio » Fri 31 Jan 2014 16:31

I am interested in knowing if there is an approach to do all this in only one step, with one query, one pgsqlConnection, one pgsqlCommand.

PgSqlConnection can establish a connection only to one PostgreSQL database at the same time. This is the designed behaviour so there is no an approach to select data from two databases in one DataTable in one step with dotConnect for PostgreSQL.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL