Click or drag to resize
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

Field Value

Type: Boolean
Remarks
Setting this flag is a global change.
See Also