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)
        .ToList();

        //OR

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

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

        //OR

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

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 - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book