Geting prepered SQL Command

Geting prepered SQL Command

Postby marlin » Wed 23 Jul 2008 12:56


I would like to get prepred SQL command

For examples:

username = "john";
password = "mypassword";

PgSqlCommand sql = new PgSqlCommand("SELECT * from uzytkownik WHERE name = :name AND password = :password ",pgsqlconnection);

sql.Parameters.Add("name", username);
sql.Parameters.Add("password", password);

Is there posibility to get from sql object value like this:

SELECT * FROM uzytkownik WHERE name = 'john' AND password = 'password';

Posts: 9
Joined: Mon 09 Jun 2008 14:15

Postby AndreyR » Thu 24 Jul 2008 16:25

Hello, Marlin.

There is no way to get a prepared SQL command if you do not use tools like DBMonitor.

Regards, Andrey.
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Return to dotConnect for PostgreSQL