How to Convert SQL to LINQ Query?

A group of technologies known as Language-Integrated Query (LINQ) is built on the direct integration of query functionality into the C# language. The query expression is the component of LINQ that stands out the most to developers who write LINQ queries. The declarative query syntax is used to write query expressions. Filtering, ordering, and grouping can all be done on data sources using LINQ syntax with the least amount of code.

Convert SQL To LINQ Query:

LINQ is just like the reversal of the SQL query. In LINQ, required fields are projected before the where clause, just like in a SQL query. However, a projection occurs at the conclusion when using LINQ.

Format of SQL and LINQ Query:

• SQL Format:

SELECT

FROM

WHERE

• LINQ Format:

FROM

WHERE

SELECT

Let's take an introductory example for the conversion of SQL to LINQ:

Query in SQL Format:

SELECT *
FROM Customers
WHERE last_name = 'Robinson' AND country = 'UK';

Query in LINQ Format:

FROM Customers
WHERE last_name = 'Robinson' AND country = 'UK';
SELECT *

Let's take another example of conversion of SQL to LINQ query using C# language:

SQL Query:

The query is about finding the names from the name table and from the records column whose name contains the letter 'e'.

SELECT name FROM records WHERE CONTAINS('e');

Converting SQL query to LINQ in C#:

Example 1:

Output:

Difference Between SQL and LINQ: