DynamicQueryEngineUseNoLockHintOnSelects Field |
Flag to signal the DQE to tell the SqlServerSpecificCreator to create WITH NOLOCK hints on table references in select queries for FROM clauses.
WITH NOLOCK is not recommended though in high volume databases with a lot of rows, it can be a lot of blocking can occur because SqlServer forces
readers to block writers and vice versa. Please consult the SqlServer's Book online for more information about this hint and also the downsides
for using it. The setting is global and for all select queries. Default is false and it should only be set to true in those situations in which
no other option is available.
Namespace:
SD.LLBLGen.Pro.DQE.SqlServer
Assembly:
SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.2.0.0 (5.2.17.0403)
Syntax public static bool UseNoLockHintOnSelects
Public Shared UseNoLockHintOnSelects As Boolean
Field Value
Type:
BooleanRemarks Setting this flag is a global change.
See Also