Query Syntax and Method Syntax

LINQ (C#)

LINQ Quary Syntex

In LINQ, we write LINQ query by following certain rules and the syntax is quite different from the SQL.(from,where,orderby,let,in..etc)

At compile time, query expressions are converted to Standard Query Operator method calls

Microsoft Highly Recomend to write quary syntext

very readable and Understadable Code structure for other developers

LINQ Methode Syntex

In LINQ, method syntaxes will use the extension methods of Enumerable or Queryable static classes.

compiler does behind the scenes when you write queries by using query syntax

Syntex are Case Sensitive

code structure is pretty complex when use lambda expressions but very easy to implement the code senarios

Conclution

Highly Recomended to learn and use both and depend on the situations