IEnumerable and IQueryable in C#

Back to: CSharp LINQ and Lambda Expressions Tutorial

In C#, IEnumerable and IQueryable are two interfaces that provide a way to query data from a data source. These interfaces are commonly used in LINQ (Language-Integrated Query) to query collections or databases. Understanding the differences and use cases of these interfaces is essential for efficient data querying.

Purpose:

The purpose of this lesson is to provide a comprehensive understanding of the IEnumerable and IQueryable interfaces in C#. We will explore the differences between them and the scenarios in which they should be used. We will also provide example code to demonstrate how to use these interfaces and answer some common questions about them.

Example Code:

Let’s start with some example code to demonstrate the use of IEnumerable and IQueryable interfaces.

IEnumerable Example:

IEnumerable<int> numbers = new List<int> { 1, 2, 3, 4, 5 };
var evenNumbers = numbers.Where(x => x % 2 == 0);
foreach (var num in evenNumbers)
{
    Console.WriteLine(num);
}

In this example, we have a collection of numbers and want to get only the even numbers from that collection. We use the Where extension method provided by the IEnumerable interface to filter the collection. This will return a new IEnumerable<int> that contains only the even numbers. We then iterate over this new collection using a foreach loop and print the even numbers to the console.

IQueryable Example:

using (var db = new MyDbContext())
{
    IQueryable<Employee> employees = db.Employees;
    var filteredEmployees = employees.Where(x => x.Department == "IT");
    foreach (var emp in filteredEmployees)
    {
        Console.WriteLine(emp.Name);
    }
}

In this example, we have a database of employees and want to get only the employees who work in the IT department. We use the IQueryable interface to query the database and filter the employees based on their department. This will return a new IQueryable<Employee> that contains only the IT employees. We then iterate over this new collection using a foreach loop and print the employee names to the console.

FAQS:

What is the difference between IEnumerable and IQueryable?

The main difference is that IEnumerable executes the query on the client side, while IQueryable executes the query on the server side. This means that IQueryable is more suitable for large data sets or databases, while IEnumerable is better for in-memory collections.

When should I use IEnumerable?

IEnumerable should be used when querying in-memory collections or small data sets that do not support querying. It is easy to use and provides simple querying methods such as Where, Select, and OrderBy.

When should I use IQueryable?

IQueryable should be used when querying data sources that support querying, such as databases. It provides deferred execution and better performance for large data sets or databases. It also allows for more complex querying using joins, grouping, and aggregation.

Conclusion:

In conclusion, understanding the differences between IEnumerable and IQueryable is crucial for efficient data querying in C#. IEnumerable is best used for in-memory collections, while IQueryable is more suitable for databases or large data sets. By using these interfaces, we can write queries that are more efficient and easier to maintain.