Class HintsHelper
Inheritance
System.Object
HintsHelper
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public static class HintsHelper
Methods
SpecifyNoLockHints(Select, Boolean)
Adds the NoLock table hint to the current query.
Declaration
public static void SpecifyNoLockHints(this Select source, bool useHint = true)
Parameters
Type | Name | Description |
---|---|---|
Select | source | Request for a sample. |
System.Boolean | useHint | A characteristic that defines whether to apply a table hint when the query is executed. An optional parameter, the default value is |
SpecifyNoLockHints(UpdateSelect)
Declaration
public static void SpecifyNoLockHints(this UpdateSelect source)
Parameters
Type | Name | Description |
---|---|---|
UpdateSelect | source |
SpecifyNoLockHints(UpdateSelect, Boolean)
Declaration
public static void SpecifyNoLockHints(this UpdateSelect source, bool useHint)
Parameters
Type | Name | Description |
---|---|---|
UpdateSelect | source | |
System.Boolean | useHint |
WithHints(Delete, BaseHint[])
Adds table instructions to the current data deletion request.
Declaration
public static Delete WithHints(this Delete source, params BaseHint[] hints)
Parameters
Type | Name | Description |
---|---|---|
Delete | source | Query to delete data. |
BaseHint[] | hints | Enumeration of table hints. |
Returns
Type | Description |
---|---|
Delete | The current delete request. |
WithHints(Join, BaseHint[])
Declaration
public static Join WithHints(this Join source, params BaseHint[] hints)
Parameters
Type | Name | Description |
---|---|---|
Join | source | |
BaseHint[] | hints |
Returns
Type | Description |
---|---|
Join |
WithHints(Select, BaseHint[])
Declaration
public static Select WithHints(this Select source, params BaseHint[] hints)
Parameters
Type | Name | Description |
---|---|---|
Select | source | |
BaseHint[] | hints |
Returns
Type | Description |
---|---|
Select |
WithHints(Update, BaseHint[])
Adds table instructions to the current data update request.
Declaration
public static Update WithHints(this Update source, params BaseHint[] hints)
Parameters
Type | Name | Description |
---|---|---|
Update | source | Request a data update. |
BaseHint[] | hints | Enumeration of table hints. |
Returns
Type | Description |
---|---|
Update | Request a data update. |