IEnumerable vs. IList

LINQ filtering Operators - where clause

The where clause is a filtering operator and used to filter a collections based on the some specific criteria and after that returns the values from collection based on your given criteria (returns those which are specified condition is true).

It is accepts a predicate as a parameter.

The where extension method has following two overloads,
1.      Func<TSource, bool>
2.      Func<TSource,  int, bool>

A single LINQ query may contain multiple where clauses and a single clause may contain multiple predicate sub expressions.

The multiple where extension methods are valid in a single LINQ query.

For example, Multiple where clauses query,

var query = base.Context.Carts.Where(x => x.EmailID == EmailID)
        .Where(x => x.IsDeleted == false) //APPLIED TO THE RESULT OF THE PREVIOUS.
        .OrderByDescending(x => x.CartID)


var query = base.Context.Carts
       .Where(x => x.EmailID == EmailID && x.IsDeleted == false)
       .OrderByDescending(x => x.CartID)

var query = from cart in Carts
     orderby cart.CartID descending,
cart.CartNumber descending
     select cart.Name;


var query = from customer in Customers
          where customer.ID == 101
          where customer.ID == 103
          where customer.ID == 105
       select customer;

I hope it is helpful to you! Thank you!

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog -
My Books - Book 1 and Book 2 Powered by Blogger.