What are some examples of LINQ queries in C#?

What are some examples of LINQ queries in C#?

LINQ, or Language Integrated Query, allows you to query collections in C#. Here are a few examples:

1. Filtering: var result = myList.Where(x => x.Age > 18);
2. Sorting: var sorted = myList.OrderBy(x => x.Name);
3. Projection: var names = myList.Select(x => x.Name);

Would you like to see more examples or details on a specific query?

Can you explain the filtering example?

Sure! The filtering example myList.Where(x => x.Age > 18) retrieves all elements from myList where the Age property is greater than 18. It uses a lambda expression to define the condition. Would you like to know how to use it with different data types?

Yes, please provide an example with a different data type.

Absolutely! If you have a list of products, you could filter by price like this:

var expensiveProducts = productList.Where(p => p.Price > 100);

This retrieves all products with a price greater than 100. Would you like to explore sorting or grouping next?

What about grouping? Can you show me an example?

Certainly! Grouping can be done using the GroupBy method. For example:

var groupedByCategory = productList.GroupBy(p => p.Category);

This groups the products by their category. Each group will contain products that share the same category. Would you like to dive deeper into any of these topics?