Loading UtilityHub...

JSON / XML Power Tools

JSON Formatter & Validator

JSON ? SQL Table

Paste JSON to detect schema

Generated SQL

Paste JSON and click "Generate SQL"...

Quick Examples

WhereJoinGroupByOrderByAggregateLeft JoinDistinctContains/INLikeInsertUpdateDelete

LINQ ? SQL Reference

LINQSQL
.Where(x => x.Age > 18)WHERE Age > 18
.Select(x => new { x.Id })SELECT Id
.OrderBy(x => x.Name)ORDER BY Name ASC
.OrderByDescending(x => x.Age)ORDER BY Age DESC
.Take(10)TOP 10 / LIMIT 10
.Skip(20).Take(10)OFFSET 20 FETCH NEXT 10
.Count() / .Sum() / .Average()COUNT(*) / SUM() / AVG()
.Distinct()SELECT DISTINCT
.GroupBy(x => x.Dept)GROUP BY Dept
.Any(x => x.IsAdmin)EXISTS (SELECT 1...)
x.Name.Contains("test")Name LIKE '%test%'
x.Value ?? 0ISNULL(Value, 0)
.Join(b, a=>a.Id, b=>b.AId,...)INNER JOIN b ON a.Id=b.AId

XML Formatter & Validator

JSON ↔ C# Class Converter

Web hosting by Somee.com