Criteria constructor (1 of 10)

Creates a new criteria that contains the field name of the metafield.

public Criteria(IField field)

parameter	description
field	The field (required).

See Also

• interface IField
• class Criteria

---

Criteria constructor (2 of 10)

Initializes a new instance of the Criteria class containing a query's string representation.

public Criteria(ISqlQuery query)

parameter	description
query	The query.

Exceptions

exception	condition
ArgumentNullException	query is null
InvalidOperationException	query is an independent query with auto parameters.

Remarks

The query must share the same root query that this criteria will be used in (usually built via that query's SubQuery() method). An unrelated query's parameters are not available to the outer query, so embedding it may produce completely invalid results. Independent queries without parameters are safe to embed.

See Also

• interface ISqlQuery
• class Criteria

---

Criteria constructor (3 of 10)

Creates a new criteria with the given condition. This condition is usually a field name, but it can also be a pre-generated criteria text.

public Criteria(string expression)

parameter	description
expression	A field name or criteria condition (cannot be null).

Remarks

Usually used like: new Criteria("fieldname") >= 5.

See Also

• class Criteria

---

Criteria constructor (4 of 10)

Initializes a new instance of the Criteria class containing an expression like "alias.field".

public Criteria(IAlias alias, IField field)

parameter	description
alias	The alias.
field	The field.

Exceptions

exception	condition
ArgumentNullException	alias or field is null

See Also

• interface IAlias
• interface IField
• class Criteria

---

Criteria constructor (5 of 10)

Initializes a new instance of the Criteria class containing an expression like "alias.field".

public Criteria(IAlias alias, string field)

parameter	description
alias	The alias.
field	The field.

Exceptions

exception	condition
ArgumentNullException	alias is null

See Also

• interface IAlias
• class Criteria

---

Criteria constructor (6 of 10)

Initializes a new instance of the Criteria class containing a custom expression while keeping reference to the provided field.

public Criteria(IField field, string expression)

parameter	description
field	The field.
expression	Custom expression

See Also

• interface IField
• class Criteria

---

Criteria constructor (7 of 10)

Initializes a new instance of the Criteria class containing an expression like "tjoinNumber.field"

public Criteria(int joinNumber, IField field)

parameter	description
joinNumber	The join number.
field	The field.

Exceptions

exception	condition
ArgumentNullException	field is null

See Also

• interface IField
• class Criteria

---

Criteria constructor (8 of 10)

Initializes a new instance of the Criteria class containing an expression like "tjoinnumber.field" (t7.field).

public Criteria(int joinNumber, string field)

parameter	description
joinNumber	The join number.
field	The field.

Exceptions

exception	condition
ArgumentNullException	field is null or empty
ArgumentOutOfRangeException	joinNumber is less than zero

See Also

• class Criteria

---

Criteria constructor (9 of 10)

Initializes a new instance of the Criteria class containing an expression like "join.field".

public Criteria(string join, IField field)

parameter	description
join	The join.
field	The field.

Exceptions

exception	condition
ArgumentNullException	field is null

See Also

• interface IField
• class Criteria

---

Criteria constructor (10 of 10)

Initializes a new instance of the Criteria class containing an expression like "alias.field".

public Criteria(string alias, string field)

parameter	description
alias	The alias.
field	The field.

Exceptions

exception	condition
ArgumentNullException	Field or alias is null or empty string.

See Also

• class Criteria