Devart Forums

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

Hello, Marlin.

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

Regards, Andrey.