When will you use this?

You need this before writing any LINQ — same as learning SELECT before SQL reports.

• Every .NET job expects you to filter lists and database tables with LINQ instead of manual foreach loops.
• Interviewers ask "What is LINQ?" and "IEnumerable vs IQueryable" in TCS, Infosys, and product company rounds.

Real-world: ERP inventory module

Real product: ERP inventory module (Manufacturing). operations team rely on purchase orders joined to suppliers every day. On this product, developers use Immediate Execution in LINQ to force the query to run now with ToList, Count, or First. Without it, the team would write longer loops, ship slower features, or pull too much data from SQL Server. The example below is simplified on purpose — production code adds error handling, logging, and tests around the same LINQ pattern.

Production-style code

var query = products.Where(p => p.IsActive);

int count = query.Count();        // runs now
var list = query.ToList();        // runs again — second scan!

// Better: one materialization
var listOnce = products.Where(p => p.IsActive).ToList();
int countOk = listOnce.Count;

What happens in production: In ERP inventory module, getting Immediate Execution in LINQ right means operations team see correct purchase orders joined to suppliers quickly. That is the difference between a tutorial snippet and software people trust with money and operations data.

Lesson example (start here)

Copy this smaller example first. Once it works, compare it with the real-world code above.

var query = products.Where(p => p.IsActive);

int count = query.Count();        // runs now
var list = query.ToList();        // runs again — second scan!

// Better: one materialization
var listOnce = products.Where(p => p.IsActive).ToList();
int countOk = listOnce.Count;

Line-by-line walkthrough

How it works (big picture)

• Count() on IEnumerable scans the sequence.
• Calling Count then ToList on the same deferred query may enumerate twice.
• Store ToList once if you need multiple operations.

Do this on your computer

1. Run Count on a deferred query and watch it execute.
2. run the query and get results with ToList and use .Count property on the list.
3. Prefer CountAsync on IQueryable for SQL COUNT.
4. Read the real-world section and name which part of the app uses this topic.
5. Run the example in a console app or LINQPad and confirm the output.
6. Change one filter or sort in the example and predict the result before you run it.

Experiments — try changing this

• Change a filter value (price, date, name) and run again — see how results change.
• Remove one operator from the chain, run, and read the error or different output.
• Make the Where condition always false — confirm you get zero results.

Remember

ToList/Count/First execute immediately. IQueryable + CountAsync runs SQL COUNT. Avoid enumerating the same deferred query twice.

Common questions