Page 1 of 1

Automatically retrieve parameters from a sql statement

Posted: Mon 19 Apr 2010 09:33
by StefanL
Hi

is there a way to extract the names of all used parameters from a sql-statment with dotConnect?

Thanks
Stefan

Posted: Tue 20 Apr 2010 13:59
by Shalex
Please refer to the description of the PgSqlCommand.ParameterCheck property in our documentation. You can use this property to automatically populate PgSqlParameterCollection with the parameters used in CommandText, and iterate through it using the PgSqlCommand.Parameters property.