Set.GetItem Method (Int32, String, Object[])

Returns an object at the specified zero-based index of the Set using element indexing order established by the specified OQL order clause.

public object GetItem(
   int index,
   string orderBy,
   params object[] parameters
);

index: The zero-based index in the source Set.
orderBy: An OQL order clause consisting of comma-separated list of one or more OQL expressions and order specifications. The expression may contain zero or more literal parameter references and it can refer to the candidate element of the source Set using the this keyword.
parameters: An array of zero or more objects that can be used as literal argument values in orderBy.

The element at the specified index in the Set. a null reference if the number of elements in the Set is less than index+1.

Exception Type	Condition
OqlParserException	orderBy does not denote a valid OQL order clause.
SqlDomException	orderBy is not applicable to the element type of the source Set. or orderBy can not be translated to the target SQL language.
SchemaException	orderBy contains expressions or features that cannot be translated with the given DataDomainSchema.

Exception Type

Condition

orderBy does not denote a valid OQL order clause.

orderBy is not applicable to the element type of the source Set.

orderBy can not be translated to the target SQL language.

SchemaException

orderBy contains expressions or features that cannot be translated with the given DataDomainSchema.