Class S.FieldExpression

Inheritance

object

S.FieldExpression

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.Data

Assembly: SoDataBase.dll

Syntax

public static class S.FieldExpression

Methods

Count(Argument)

Counts the rows defined by expression or table; counting is done for the argument expression with an implied DISTINCT. Use CountAll if you need the total number of rows.

Declaration

public static Count Count(Argument arg)

Parameters

Type	Name	Description
Argument	arg	The Count argument.

Returns

Type	Description
Count	a new instance of the Count class based on the argument provided.

CountAll(Argument)

Counts the rows defined by expression or table; this variant counts the total result set.

Declaration

public static CountAll CountAll(Argument arg)

Parameters

Type	Name	Description
Argument	arg	The Count argument.

Returns

Type	Description
CountAll	a new instance of the Count class based on the argument provided.

Distinct(FieldInfo)

Distinct keyword; gives distinct rows by comparing ALL fields

Declaration

public static Distinct Distinct(FieldInfo field)

Parameters

Type	Name	Description
FieldInfo	field	This field becomes an ordinary return field, it has no effect on the distinct comparison

Returns

Type	Description
Distinct	a new instance of the Distinct class based on the argument provided.

FieldTypeConvert(FieldInfo, FieldDataType)

FieldTypeConvert will convert the in-parameter field to the incoming fieldDatatype.

Declaration

public static FieldTypeConvert FieldTypeConvert(FieldInfo field, FieldDataType newType)

Parameters

Type	Name	Description
FieldInfo	field	The field you want to convert.
FieldDataType	newType	The new type of the field.

Returns

Type	Description
FieldTypeConvert	a new instance of the FieldTypeConvert class based on the arguments provided.

FieldTypeConvert(FieldInfo, FieldDataType, int)

FieldTypeConvert will convert the in-parameter field to the incoming fieldDatatype with length like the in-parameter length.

Declaration

public static FieldTypeConvert FieldTypeConvert(FieldInfo field, FieldDataType newType, int newLength)

Parameters

Type	Name	Description
FieldInfo	field	The field you want to convert.
FieldDataType	newType	The new type of the field.
int	newLength	The length of the conversion.

Returns

Type	Description
FieldTypeConvert	a new instance of the FieldTypeConvert class based on the arguments provided.

JsonValue(FieldInfo, string)

Perform a scalar JSON value lookup

Declaration

public static JsonValue JsonValue(FieldInfo field, string jsonAccessor)

Parameters

Type	Name	Description
FieldInfo	field	Text column in database to look into
string	jsonAccessor	Path expression - typical example: $.executeMode to address a root element; $.array[1].thing to extract the thing element from the second element of the "array" array

Returns

Type	Description
JsonValue

Exceptions

Type	Condition
ArgumentException	Only a subset of characters are allowed in JSON paths to limit SQL Injection vulnerabilities

Max(Argument)

Finds the maximum value in a column by expression.

Declaration

public static Max Max(Argument arg)

Parameters

Type	Name	Description
Argument	arg	The Max argument.

Returns

Type	Description
Max	a new instance of the Max class based on the argument provided.

Min(Argument)

Finds the minimum value in a column by expression.

Declaration

public static Min Min(Argument arg)

Parameters

Type	Name	Description
Argument	arg	The arg.

Returns

Type	Description
Min	a new instance of the Min class based on the argument provided.

NewAlias(string)

Alias on for example Field or aggregation

Declaration

public static Alias NewAlias(string alias)

Parameters

Type	Name	Description
string	alias	The alias

Returns

Type	Description
Alias	a new instance of the Alias class based on the argument provided.

Sum(Argument)

Finds the sum of a column by expression.

Declaration

public static Sum Sum(Argument arg)

Parameters

Type	Name	Description
Argument	arg	The Sum argument.

Returns

Type	Description
Sum	a new instance of the Sum class based on the argument provided.