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. 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.9.0.0 (5.9.0)
Syntax
public static bool UseNoLockHintOnSelects

Field Value

Type: Boolean
Remarks
Setting this flag is a global change and is not recommended. Use the LLBLGen Pro query hints system instead to specify NOLOCK hints on target elements
See Also