- IQueryable is an interface available in the
System.Linq
namespace - IQueryable interface derives from the IEnumerable interface, making it iterable.
- The IQueryable interface provides the IQueryProvider, which is used to create LINQ providers used in data-centric operations such as LINQ-to-SQL etc.
- By using the
AsQueryable()
method over a collection, we can convert it into an IQueryable collection.

What is an IQueryable?
- IQueryable is an interface available in the
System.Linq
namespace - IQueryable interface derives from the IEnumerable interface, making it iterable.
- The IQueryable interface provides the IQueryProvider, which is used to create LINQ providers used in data-centric operations such as LINQ-to-SQL etc.
- By using the
AsQueryable()
method over a collection, we can convert it into an IQueryable collection.
[…] This is lot better and faster than calling out all the records and filtering on them. This approach we’re following is called “Lazy-Evaluation” which happens due to the presence of the IQueryable. […]