⇄

SQL ⇄ LINQ Converter

Translate SELECT queries into C# LINQ, and LINQ back into SQL

Try an example

SQL Query

LINQ Query

What this tool handles

Single-table SELECT … FROM … WHERE … queries — no joins
ORDER BY (multiple columns, ASC/DESC)
GROUP BY with COUNT, SUM, AVG, MIN, MAX
LIKE patterns, IN, NOT IN, BETWEEN, IS NULL

LINQ query syntax (from … where … select …)
LINQ method syntax (.Where().OrderBy().Select())
LIMIT ↔ .Take(), plus basic .Skip() support
Column aliases via AS ↔ anonymous-type properties

Web Analytics