Microsoft LightSwitch makes it easy to query multiple entities and with queries you can fine tune the results using multiple parameters.
In the following, we will be considering the Orders and the Shippers tables from the
Northwind database shown next:
What we would like to achieve is to fashion a query in LightSwitch which finds orders later than a specified date (OrderDate) carried by a specified shipping company (CompanyName).
In the previous example, we created a single parameter and here we extend it to two parameters, OrderDate and CompanyName. The following stored procedure in SQL Server 2008 would produce the rows ...