What are some examples of LINQ queries in C#?

What are some examples of LINQ queries in C#?

LINQ (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);
4. Grouping: var grouped = myList.GroupBy(x => x.City);

Would you like to see more detailed examples?

Yes, 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 a database?

That sounds interesting! How do I use LINQ with a database?

You can use LINQ with databases through Entity Framework. For example, you can write a query like this:

var adults = context.Users.Where(u => u.Age > 18).ToList();

This retrieves all users older than 18 from the database. Would you like to learn more about Entity Framework?