Advanced Querying Techniques

The Basic Operations chapter shows how to carry out most queries using LightSpeed.  Using the techniques shown there, you can perform filtering, ordering and paging; and if you are using LINQ you can easily perform more advanced queries using the standard LINQ operators or the C# and Visual Basic language integrated syntax.

This chapter describes additional query functionality such as full text search, speeding up query times by using compile queries and how to exploit database‑specific or user-defined functions in your queries.  This chapter also describes how you can complex queries if you are using query objects instead of LINQ.

Full Text Search

Invoking SQL Functions

Compiled Queries

Exploring the Query Object

Subexpressions