What are some examples of LINQ queries?

What are some examples of LINQ queries?

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

1. Filtering: var result = from item in collection where item.Property == value select item;
2. Sorting: var sorted = collection.OrderBy(item => item.Property);
3. Grouping: var grouped = from item in collection group item by item.Property into g select new { Key = g.Key, Items = g.ToList() };

Can you explain the filtering example?

Sure! The filtering example retrieves items from a collection where a specific property matches a given value. For instance, if you have a list of products and want to find all products with a price less than 20, you would write: var cheapProducts = from product in products where product.Price < 20 select product;

What about the grouping example?

The grouping example organizes items into groups based on a shared property. For example, if you have a list of students and want to group them by their grades, you would use: var groupedByGrade = from student in students group student by student.Grade into g select new { Grade = g.Key, Students = g.ToList() }; This creates a collection where each group contains students with the same grade.

Can you give me a more complex LINQ query?

Absolutely! Here's a more complex example that combines filtering, sorting, and grouping:

var result = from order in orders
             where order.Total > 100
             group order by order.Customer into g
             orderby g.Key.Name
             select new { Customer = g.Key, Orders = g.ToList() };
``` This query retrieves customers with orders over 100, groups them by customer, and sorts the groups by customer name.