Building Queries

A QueryExpression is used to programmatically build a query containing data filters and search conditions that define the scope of a database search. A QueryExpression is used for single-object searches, for example, searching for all accounts that match certain search criteria. QueryExpression provides a strong typed (object based) approach to building queries that can be executed. To save a query, you can convert it to Fetch using a QueryExpressionToFetchXml request and save it as a userquery. Because QueryExpression is strongly typed, Microsoft IntelliSense support is available for the QueryExpression object within Visual Studio .NET.

In This Topic

Query Language Comparison

Using QueryExpression

Using QueryByAttribute

Using ColumnSet

Using ConditionExpression

Using FilterExpression

Testing for a Null Value

Using Link Tables

Using FetchXML

Using the Paging Cookie

Related Topics

RetrieveMultiple Method

RetrieveMultiple Message