Geting prepered SQL Command

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
marlin
Posts: 9
Joined: Mon 09 Jun 2008 14:15

Geting prepered SQL Command

Post by marlin » Wed 23 Jul 2008 12:56

Hi

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';

marlin

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by 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.

Post Reply