---
title: "Introduction to LINQ in C#"  
description: "the most powerful and elegant features in C#. It allows you to query collections, databases, XML."  
author: "Anubhav Sharma"  
published: 2025-04-22  
updated: 2025-04-22  
canonical: https://www.mindstick.com/blog/305507/introduction-to-linq-in-c-sharp  
category: "c#"  
tags: ["c#"]  
reading_time: 3 minutes  

---

# Introduction to LINQ in C#

**LINQ** ([Language Integrated](https://www.mindstick.com/forum/159866/what-are-the-advantages-of-using-linq-language-integrated-query-in-c-sharp) Query) is one of the most powerful and elegant features in C#. It allows you to query **[collections](https://www.mindstick.com/articles/12458/what-are-collections-in-c-sharp)**, **databases**, **XML**, and more — using a **SQL-like syntax** directly in C#.

## What is LINQ?

**LINQ** stands for **Language Integrated Query**. It provides a **consistent, readable, and type-safe** way to query different types of data sources such as:

1. [Arrays and Lists](https://answers.mindstick.com/qa/111179/how-to-work-with-arrays-and-lists-in-programming-languages)
2. XML Documents
3. Databases (via [LINQ to SQL](https://www.mindstick.com/articles/338528/how-to-use-linq-to-sql-select-query-using-c-sharp) or [Entity Framework](https://www.mindstick.com/articles/1566/crud-operations-using-entity-framework-code-first-approach))
4. JSON or Web APIs

## Benefits of LINQ

| Benefit | Description |
| --- | --- |
| Unified Query Style | Same syntax for querying different data sources |
| Type Safety | Errors caught at compile-time, not runtime |
| Readability | Code is cleaner and closer to English or SQL |
| [Productivity](https://www.mindstick.com/articles/23599/how-gadgets-can-help-boost-your-productivity) | Reduces the amount of boilerplate looping and filtering code |

## LINQ Query Syntax vs Method Syntax

C# offers **two ways** to write LINQ queries:

## 1. Query Syntax (SQL-like style)

```cs
var result = from n in numbers
             where n > 5
             orderby n
             select n;
```

## 2. Method Syntax (Lambda-based)

```cs
var result = numbers.Where(n => n > 5).OrderBy(n => n);
```

Both produce the same result — it’s just a matter of preference!

## LINQ with Collections – Example

```cs
using System;
using System.Linq;
using System.Collections.Generic;

class Program
{
    static void Main()
    {
        List<string> names = new List<string> { "Alice", "Bob", "Eve", "Charlie" };

        // LINQ query to filter names starting with 'C'
        var result = from name in names
                     where name.StartsWith("C")
                     select name;

        foreach (var name in result)
        {
            Console.WriteLine(name);  // Output: Charlie
        }
    }
}
```

## Common LINQ Operators

| Operator | Description |
| --- | --- |
| `Where` | Filters a sequence based on condition |
| `Select` | Projects each element into a new form |
| `OrderBy` | Sorts elements in [ascending order](https://www.mindstick.com/forum/157178/how-to-filter-1000-of-student-name-in-php-in-ascending-order) |
| `OrderByDescending` | Sorts in [descending order](https://www.mindstick.com/forum/160082/how-to-sort-the-results-of-an-sql-search-query-in-ascending-and-descending-order) |
| `GroupBy` | Groups elements |
| `Join` | Joins two sequences based on keys |
| `Distinct` | Removes duplicates |
| `Take`, `Skip` | Limits and skips elements |
| `Any`, `All` | Checks for conditions |

## LINQ Example with Integers

```cs
int[] numbers = { 1, 2, 3, 4, 5, 6 };

var evenNumbers = numbers.Where(n => n % 2 == 0);

foreach (int num in evenNumbers)
{
    Console.WriteLine(num);  // Output: 2, 4, 6
}
```

## LINQ to Objects vs LINQ to SQL

| Feature | LINQ to Objects | LINQ to SQL/EF |
| --- | --- | --- |
| Source | In-memory collections | Database tables |
| Execution | Immediate or deferred | Translates to [SQL queries](https://www.mindstick.com/forum/159818/how-to-use-the-coalesce-function-to-handle-null-values-in-sql-queries) |
| Libraries Used | `System.Linq` | `System.Data.Linq`, Entity Framework |

## Summary

| Topic | Description |
| --- | --- |
| LINQ [Full Form](https://answers.mindstick.com/qa/35723/what-is-the-full-form-of-adh) | Language Integrated Query |
| Main Types | Query Syntax, Method Syntax |
| Works With | Arrays, Lists, XML, SQL, JSON |
| Key Benefits | Cleaner code, type-safe, reusable logic |

## Next Steps

1. Learn **deferred execution** and how LINQ works under the hood
2. Dive into **LINQ to SQL** or **Entity Framework**
3. Explore **GroupBy**, **Join**, and **Aggregate** functions

---

Original Source: https://www.mindstick.com/blog/305507/introduction-to-linq-in-c-sharp

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.