BetweenExpression Class (RemObjects.DataAbstract.Expressions)

This is a Library topic for Data Abstract for .NET
This page is generated from external data, please do not update

Namespaces — Interfaces — Classes — Enums — Implements

Overview

The BetweenExpression is derived from the WhereExpression class and represents expression that checks belonging to a range of values.

This is one of the classes used to dynamically build WHERE statements from code (Dynamic Where feature of Data Abstarct).

For example, a WHERE clause of this query

SELECT * FROM Customers WHERE CustomerId between 5000 AND 5010;

will be presented as:

WhereExpression lResult;
lResult = new BetweenExpression(
              new FieldExpression("CustomerId"),
              new ConstantExpression("5000", DataType.Integer),
              new ConstantExpression("5010", DataType.Integer));

Location

Assembly: RemObjects.DataAbstract.dll
Namespace: RemObjects.DataAbstract.Expressions
Ancestry: WhereExpression | BetweenExpression

Properties

Expression
Represents datapiont expression (for example, field name) in current between expression. Prism: `property Expression: WhereExpression read write` C#: `WhereExpression Expression { get; set; }` VB: `Property Expression As WhereExpression`
Kind
Gets the type of the expression. For the current class, the type is WhereKind.Between. Prism: `property Kind: WhereKind read` C#: `WhereKind Kind { get; }` VB: `Property ReadOnly Kind As WhereKind`
Lower
Represents lower value of the current between expression. Prism: `property Lower: WhereExpression read write` C#: `WhereExpression Lower { get; set; }` VB: `Property Lower As WhereExpression`
Upper
Represents upper value of the current between expression. Prism: `property Upper: WhereExpression read write` C#: `WhereExpression Upper { get; set; }` VB: `Property Upper As WhereExpression`

Class Methods

Combine (WhereExpression, WhereExpression): WhereExpression (declared in WhereExpression)
Creates new BinaryExpression from given aLeft and aRight operands, using operator And. Oxygene: `class method Combine(left: WhereExpression; right: WhereExpression): WhereExpression` C#: `static WhereExpression Combine(WhereExpression left, WhereExpression right)` VB: `Shared Function Combine(left As WhereExpression, right As WhereExpression) As WhereExpression` Parameters: left: right:
Combine (WhereExpression, WhereExpression, BinaryOperator): WhereExpression (declared in WhereExpression)
Oxygene: `class method Combine(left: WhereExpression; right: WhereExpression; operator: BinaryOperator): WhereExpression` C#: `static WhereExpression Combine(WhereExpression left, WhereExpression right, BinaryOperator operator)` VB: `Shared Function Combine(left As WhereExpression, right As WhereExpression, operator As BinaryOperator) As WhereExpression` Parameters: left: right: operator:
FromString (declared in WhereExpression)
Creates new WhereExpression from string, which should contain where node in the correct Dynamic Where XML Format. Oxygene: `class method FromString(xml: String): WhereExpression` C#: `static WhereExpression FromString(String xml)` VB: `Shared Function FromString(xml As String) As WhereExpression` Parameters: xml:
FromStringToSql (declared in WhereExpression)
Oxygene: `class method FromStringToSql(xml: String): String` C#: `static String FromStringToSql(String xml)` VB: `Shared Function FromStringToSql(xml As String) As String` Parameters: xml:
FromXmlNode (declared in WhereExpression)
Creates new WhereExpression from xml node, which should be in the correct Dynamic Where XML Format. Oxygene: `class method FromXmlNode(node: XmlNode): WhereExpression` C#: `static WhereExpression FromXmlNode(XmlNode node)` VB: `Shared Function FromXmlNode(node As XmlNode) As WhereExpression` Parameters: node:
ParseExpression (declared in WhereExpression)
Oxygene: `class method ParseExpression(node: XmlNode): WhereExpression` C#: `static WhereExpression ParseExpression(XmlNode node)` VB: `Shared Function ParseExpression(node As XmlNode) As WhereExpression` Parameters: node:
Validate (WhereExpression): Boolean (declared in WhereExpression)
Validates that WhereExpression doesn't contain any errors, using WhereValidator. The main purpose of this validation - to scan all objects of WhereExpession tree and make sure that it contains correct field names. Validates that WhereExpression doesn't contain any errors, using WhereValidator. The main purpose of this validation - to scan all objects of WhereExpession tree and make sure that it contains correct field names. Oxygene: `class method Validate(expression: WhereExpression): Boolean` C#: `static Boolean Validate(WhereExpression expression)` VB: `Shared Function Validate(expression As WhereExpression) As Boolean` Parameters: expression:

Instance Methods

constructor ()
Creates a new instance of BetweenExpression class. Oxygene: `constructor` C#: `constructor()` VB: `Sub New`
constructor (WhereExpression, WhereExpression, WhereExpression)
Creates new instance of BetweenExpression class. Oxygene: `constructor(expression: WhereExpression; lower: WhereExpression; upper: WhereExpression)` C#: `constructor(WhereExpression expression, WhereExpression lower, WhereExpression upper)` VB: `Sub New (expression As WhereExpression, lower As WhereExpression, upper As WhereExpression)` Parameters: expression: lower: upper:
ApplyFieldMapping
Oxygene: `method ApplyFieldMapping(columnMappings: SchemaColumnMappingCollection)` C#: `void ApplyFieldMapping(SchemaColumnMappingCollection columnMappings)` VB: `Sub ApplyFieldMapping(columnMappings As SchemaColumnMappingCollection)` Parameters: columnMappings:
ApplySourceTableNumber
Oxygene: `method ApplySourceTableNumber(number: Int32): WhereExpression` C#: `WhereExpression ApplySourceTableNumber(Int32 number)` VB: `Function ApplySourceTableNumber(number As Int32) As WhereExpression` Parameters: number:
ApplyTableMapping
Oxygene: `method ApplyTableMapping(schemaTable: String; databaseTable: String)` C#: `void ApplyTableMapping(String schemaTable, String databaseTable)` VB: `Sub ApplyTableMapping(schemaTable As String, databaseTable As String)` Parameters: schemaTable: databaseTable:
ApplyTableNameOrAlias
Oxygene: `method ApplyTableNameOrAlias(name: String)` C#: `void ApplyTableNameOrAlias(String name)` VB: `Sub ApplyTableNameOrAlias(name As String)` Parameters: name:
ExtractAllConstantExpression
Oxygene: `method ExtractAllConstantExpression(expressions: List<ConstantExpression>)` C#: `void ExtractAllConstantExpression(List<ConstantExpression> expressions)` VB: `Sub ExtractAllConstantExpression(expressions As List<ConstantExpression>)` Parameters: expressions:
ExtractAllFieldNames
Oxygene: `method ExtractAllFieldNames(fieldNames: List<String>)` C#: `void ExtractAllFieldNames(List<String> fieldNames)` VB: `Sub ExtractAllFieldNames(fieldNames As List<String>)` Parameters: fieldNames:
ExtractAllParams
Oxygene: `method ExtractAllParams(parameters: SchemaParameterCollection)` C#: `void ExtractAllParams(SchemaParameterCollection parameters)` VB: `Sub ExtractAllParams(parameters As SchemaParameterCollection)` Parameters: parameters:
ReadFromXml
Creates WhereExpression from the given xml node, that should be in the correct Dynamic Where XML Format. Oxygene: `method ReadFromXml(node: XmlNode)` C#: `void ReadFromXml(XmlNode node)` VB: `Sub ReadFromXml(node As XmlNode)` Parameters: node:
ToSQLString (): String (declared in WhereExpression)
Oxygene: `method ToSQLString: String` C#: `String ToSQLString()` VB: `Function ToSQLString As String`
ToSQLString (StringBuilder)
Converts between expression to it's SQL representation. Oxygene: `method ToSQLString(destination: StringBuilder)` C#: `void ToSQLString(StringBuilder destination)` VB: `Sub ToSQLString(destination As StringBuilder)` Parameters: destination:
ToString (declared in WhereExpression)
Oxygene: `method ToString: String` C#: `String ToString()` VB: `Function ToString As String`
ToXmlNode (declared in WhereExpression)
Creates query node (in the Dynamic Where XML Format) from WhereExpression. Oxygene: `method ToXmlNode: XmlNode` C#: `XmlNode ToXmlNode()` VB: `Function ToXmlNode As XmlNode`
ToXmlString (declared in WhereExpression)
Creates query node (in the Dynamic Where XML Format) from WhereExpression and returns it in the string format. Oxygene: `method ToXmlString: String` C#: `String ToXmlString()` VB: `Function ToXmlString As String`
Validate (): Boolean (declared in WhereExpression)
Oxygene: `method Validate: Boolean` C#: `Boolean Validate()` VB: `Function Validate As Boolean`
WriteToXml
Creates WHERE node (in the Dynamic Where XML Format) from between expression. Oxygene: `method WriteToXml(node: XmlNode)` C#: `void WriteToXml(XmlNode node)` VB: `Sub WriteToXml(node As XmlNode)` Parameters: node:

BetweenExpression Class (RemObjects.DataAbstract.Expressions)

Contents

Overview

Location

Properties

Class Methods

Instance Methods

See Also

Personal tools

Namespaces

Variants

Views

Actions

Search

Navigation

products

platforms

special

Toolbox