Dal > Dal Assembly Enumerations > DalCommandOption
The DalCommandOption enumeration contains parameters of SQL query execution.
It is used by the following properties and methods:
| Value | Brief description |
| 0 | None. Parameters set by default are used. |
| 1 | NoLog. Queries are not logged in DebugView. NOTE. It is not intended to be used in application code. |
| 2 | ExceptionIncludeSQL. Text of the SQL query is included into the text of exception. NOTE. It is not intended to be used in application code. |
| 4 | WithoutException. Do not generate exception if SQL query is failed. NOTE. It is not intended to be used in application code. |
| 8 | CaseSensitive. Take into account case in SQL query. It is relevant on working with case sensitive DBMS. NOTE. It is not intended to be used in application code. |
| 16 | InsertIdentity. Use source values for the Identity field. NOTE. It is not intended to be used in application code. |
| 32 | FastInsert. Use the FastInsert command in a standard connection if possible. NOTE. It is not intended to be used in application code. |
| 64 | HintOptimizeFetchAll. Optimize all data sample from large cursor if possible. NOTE. It is not intended to be used in application code. |
| 128 | NoCursorInQuery. Do not use cursors in SQL queries. |
Value of InsertIdentity is used on working with Microsoft SQL Server DBMS.
Values of FastInsert, HintOptimizeFetchAll are used on working with PostgreSQL DBMS.
Disabled cursors in the NoCursorInQuery mode may affect the speed of SQL query execution. It is relevant if small data amounts are extracted.
See also:
