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!

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - and
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like Powered by Blogger.
ASK Questions