How can I use LINQ in ASP.NET Core for querying data?

How can I use LINQ in ASP.NET Core for querying data?

You can use LINQ in ASP.NET Core by leveraging the built-in LINQ methods with your DbContext. For example, you can use methods like .Where(), .Select(), and .ToList() to query your data.

Can you show me a simple example of a LINQ query?

Sure! Here's a simple example:

var products = await _context.Products
    .Where(p => p.Price > 100)
    .Select(p => new { p.Name, p.Price })
    .ToListAsync();

This query retrieves all products with a price greater than 100.

What if I want to order the results?

You can use the .OrderBy() method to sort your results. For example:

var products = await _context.Products
    .Where(p => p.Price > 100)
    .OrderBy(p => p.Name)
    .ToListAsync();

This will order the products by their name.

Can I join two tables using LINQ?

Yes, you can join tables using LINQ. For example:

var query = from o in _context.Orders
            join c in _context.Customers on o.CustomerId equals c.Id
            select new { o.OrderId, c.Name };

This will give you a list of orders along with the customer names.