Db > Db Assembly Interfaces > IQuery
Assembly: Db;
Namespace: Prognoz.Platform.Interop.Db;
The IQuery interface contains properties and methods of the Query repository object.
IQuery
When a new query is created, to ensure its correct work, determine the following minimum set of properties in the settings:
Property name | Brief description | |
![]() |
AutoDefineStorage | The AutoDefineStorage property determines whether data saving settings are automatically defined at query saving. |
![]() |
Database | The Database property determines a database, in which the query is stored. |
![]() |
ParamsCheck | The ParamsCheck property determines whether parameters are considered at query execution. |
![]() |
Sql | The Sql property determines the text of SQL query to a database of the Query object. |
![]() |
SqlText | The SqlText property determines the text of SQL query to a database of the Query object for certain DBMS driver. |
![]() |
Storage | The Storage property returns options for data saving. |
![]() |
SubstituteAllParamsInQuery | The SubstituteAllParamsInQuery property determines whether all parameters values to query body on execution. |
Method name | Brief description | |
![]() |
ClearSqlText | The ClearSqlText method clears query text of object query. |
![]() |
RefreshFields | The RefreshFields method updates the list of the Query object fields under the information from a database. |
See also: