LINQ has bought with itself a
super power of querying Objects, Database, XML, SharePoint and nearly any other
data structure. The power of LINQ lies in the fact that it is managed code that
lets you write SQL type code to fetch data.
Whenever working with data we
always need a way to filter out the data based on different condition. In this
post we will look at some of the different ways in which we can filter data in
LINQ with the help of where clause.
Simple Filter for an
array.
Let’s say we have an array of
number and we want to filter out data based on some condition. Below is an
example
int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };
var lowNums =
from num
in numbers
where num
< 5
select
num;
Filter based on one of the
property in the class.
With the help of LINQ we can
also filer out data from a list based on value of some property.
var soldOutProducts =
from prod
in products
where
prod.UnitsInStock == 0
select prod;
Filter based on Multiple of
the property in the class.
var expensiveInStockProducts =
from prod in
products
where
prod.UnitsInStock > 0 && prod.UnitPrice > 3.00M
select prod;
Filter based on the index of the
Item in the list.In the below example we can see that we are able to filter
data based on the index of the item in the list.
string[] digits = { "zero",
"one", "two", "three", "four", "five", "six"};
var shortDigits =
digits.Where((digit, index) => digit.Length < index);
There are many other way in
which we can filter out data in LINQ. In the above post I have tried and shown
few ways using the LINQ.
Vikram
