What is LINQ in C# and how do I use it?

What is LINQ in C# and how do I use it?

LINQ, or Language Integrated Query, is a feature in C# that allows you to query collections in a more readable way. You can use it with arrays, lists, and databases.

Can you show me a simple example of using LINQ?

Sure! Here's a basic example:

using System;
using System.Collections.Generic;
using System.Linq;

class Program
{
    static void Main()
    {
        List<int> numbers = new List<int> { 1, 2, 3, 4, 5 };
        var evenNumbers = from n in numbers where n % 2 == 0 select n;
        foreach (var num in evenNumbers)
        {
            Console.WriteLine(num);
        }
    }
}

This code filters even numbers from a list.

What are the benefits of using LINQ?

LINQ improves code readability and maintainability, reduces the amount of code you need to write, and allows for compile-time checking of queries.

Can LINQ be used with databases?

Yes, LINQ can be used with databases through LINQ to SQL or Entity Framework, allowing you to query database tables as if they were collections.