What are different methods to write LINQ Query in C#?

There are multiple methods to write LINQ queries in C#. Here are some commonly used methods:

1. Query Syntax (or Query Expression Syntax):
   The query syntax uses a declarative and SQL-like syntax to write LINQ queries.
   It starts with the "from" clause, followed by "where," "select," "group by," and other query operators.
   Example:
   

   
       var query = from student in students
                   where student.Age > 18
                   select student.Name;
   

2. Method Syntax (or Fluent Syntax):
   The method syntax uses extension methods provided by the LINQ operators to chain together query operations.
   It involves calling methods like "Where," "Select," "OrderBy," "GroupBy," and more on the data source or intermediate query results.
   Example:
   

   
       var query = students
                   .Where(student => student.Age > 18)
                   .Select(student => student.Name);
   

3. Mixed Syntax:
   It is possible to mix both query syntax and method syntax within the same LINQ query.
   This allows combining the readability of the query syntax with the flexibility of the method syntax.
   Example:
   

   
       var query = (from student in students
                    where student.Age > 18
                    select student)
                   .OrderByDescending(student => student.Name);
   

4. SQL-Like Syntax with Entity Framework (EF) Core:
   When using Entity Framework Core, you can write LINQ queries that resemble SQL syntax.
   These queries are translated by EF Core into the corresponding SQL statements for execution.
   Example:
   

   
       var query = dbContext.Students
                   .Where(s => s.Age > 18)
                   .OrderByDescending(s => s.Name)
                   .Select(s => s.Name);
   

5. Lambda Expressions:
   Lambda expressions allow writing inline functions and predicates within LINQ queries.
   They provide a concise and inline way to define functions and perform complex transformations.
   Example:
   

   
       var query = students
                   .Where(student => student.Age > 18 && student.Grade == "A")
                   .Select(student => new { student.Name, student.Age });
   

These methods offer flexibility in writing LINQ queries, allowing developers to choose the style that suits their preference and the specific requirements of their codebase. It's important to note that the choice of method syntax does not impact the functionality or performance of the LINQ query.