Filtering Data with Queries

Filtering Data with Queries in LightSwitch


In LightSwitch, you can use queries to work with a subset of data. For example, instead of displaying all orders, you can use a query to display orders for customers in a certain country or region.

In this set of lessons you’ll learn how to create both simple and parameterized queries and apply them to screens.


These lessons build upon the My First Application project that you last modified in the Displaying Local Information in a LightSwitch Application lesson. If your application isn't already open in Visual Studio, on the menu bar, choose File, Open Project to open it.

Read this lesson

To learn

Creating a Basic Query in LightSwitch

How to create a basic query in the Query Designer.

Creating a LightSwitch Screen Based on a Query

How to create a screen to display the results of a query.

Creating a Parameterized Query in LightSwitch

How to create a query that includes a value determined at run time.

Using a Parameterized Query on a LightSwitch Screen

How to display the results of a parameterized query.

© 2016 Microsoft