Forced sending queries to the server without parameters
Queries may be with or without parameters:
select *
from test_table
where id = :ID
or
select *
from test_table
However some database servers execute queries without parameters faster than the same queries with parameters. An option (for example, AllowParams) may be added; if this option is set to False, all queries will be sent to a server as text.
![](https://secure.gravatar.com/avatar/d1f3a28af2a27cd30cc7fbbe47cc57b8?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Dorin Marcoci commented
This is more a "parameter by value" replacement feature.
It may lead in sql injections.
Also different DBMSes handle parameters in different way. Quoted/unquoted, date format, etc... -
Francesco commented
This is a SDAC only suggestion in my opinion
-
Flavio commented
This feature is very important because the queries with "exec sp_executesql" are very slow. As with plain text is very fast.
-
Francesco commented
Please see also this forum entry were there is some more details (and were this was already asked): http://www.devart.com/forums/viewtopic.php?p=69497#69497