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 a fluent model based on the Northwind database.
The following code is the LINQ example.
using ( FluentModel dbContext = new FluentModel() )
{
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 );
}
}
Using dbContext As New FluentModel()
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