How to: Filter Data

This topic shows how to filter query results. The example returns a collection of OrderDatail objects that represent all orders with UnitPrice more than 15.00.

To run the code in this example, you need to create a new Telerik Data Access Domain Model based on the Northwind database.

The following code is the LINQ example.

C#


    using ( EntitiesModel dbContext = new EntitiesModel() )
    {
       var query = from orderDetail in dbContext.OrderDetails
                   where orderDetail.UnitPrice > 15
                   select new
                   {
                       orderDetail.UnitPrice,
                       orderDetail.Product.ProductName
                   };
       foreach ( var item in query )
       {
           Console.WriteLine( "ProductName: {0}, UnitPrice: {1}",
               item.ProductName, item.UnitPrice );
       }
    }

VB.NET


    Using dbContext As New EntitiesModel()
     Dim query = From orderDetail In dbContext.OrderDetails
                 Where orderDetail.UnitPrice > 15
                 Select New With {Key orderDetail.UnitPrice, Key orderDetail.Product.ProductName}
     For Each item In query
      Console.WriteLine("ProductName: {0}, UnitPrice: {1}", item.ProductName, item.UnitPrice)
     Next item
    End Using

See Also