Class QueryUtilities
Provides utility methods for working with queries to the database.
Inheritance
System.Object
QueryUtilities
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 QueryUtilities
Methods
AddColumnLocalization(Select, String, String, String, Guid)
Adds localized column for specified culture to given query with the given alias from specified source.
Declaration
public static void AddColumnLocalization(this Select source, string sourceSchemaName, string columnName, string columnAlias, Guid localizationCultureId)
Parameters
Type | Name | Description |
---|---|---|
Select | source | Select query. |
System.String | sourceSchemaName | Source schema name to add localized column to. |
System.String | columnName | Name of column that has localization. |
System.String | columnAlias | Column alias. |
System.Guid | localizationCultureId | Localization culture identifier. |
AddDBEngineCompatibleIsEqualCondition(Query, EntitySchema, EntitySchemaColumn, Object, Guid, LogicalOperation)
Adds to given query new condition for checking equality of schema column value and specified value, according to column data type.
Declaration
public static void AddDBEngineCompatibleIsEqualCondition(Query query, EntitySchema schema, EntitySchemaColumn conditionColumn, object conditionValue, Guid cultureId, LogicalOperation logicalOperation = LogicalOperation.And)
Parameters
Type | Name | Description |
---|---|---|
Query | query | Query to add condition to. |
EntitySchema | schema | Entity schema to add condition to. |
EntitySchemaColumn | conditionColumn | Entity schema column to add condition to. |
System.Object | conditionValue | Value to be compared with |
System.Guid | cultureId | Localization culture identifier. |
LogicalOperation | logicalOperation | Logical operation, by which the condition is added to the query. |