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.


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


    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