How to convert sql to linq using C#

Question

Hi  please Can someone help me ? I have a sql query which I need to convert in LINQ SELECT '1' REG FROM a WHERE tipo LIKE 'DEPOSITO%' AND id IN (SELECT secuencia FROM b WHERE formulario = 'D1526' AND num = ' 123456789 ') UNION ALL SELECT '1' REG FROM a WHERE tipo LIKE 'DEPOSITO%' AND id IN(SELECT secuencia FROM b WHERE formulario_padre = 'D1526') UNION ALL SELECT '1' REG FROM c WHERE uti 0 AND formulario='D1526';

Catcher Wong · Answer

Hi marjorie you can try this: var res = (from a in table1 where a.tipo.StartsWith( DEPOSITO ) && (from b in table2 where b.formulario == D1526 && b.num == 123456789 select b.secuencia).ToList().Contains(a.id) select new { REG = 1 }) .Concat( from a in table1 where a.tipo.StartsWith( DEPOSITO ) && (from b in table2 where b.formulario_padre == D1526 select b.secuencia).ToList().Contains(a.id) select new { REG = 1 }) .Concat( from c in tablec where c.uti != 0 && c.formulario == D1526 select new { REG = 1 }).ToList(); Notice : the mapping between LINQ and your SQL are as follow : LINQ SQL Concat union all Contains in LIKE 'DEPOSITO%' StartWith(DEPOSITO)

Vishal Prajapati · Answer

Hello..... have you tried Linqer??? Linqer is a SQL to Linq converter.It helps you to learn LINQ and convert your existing SQL statements.. Not every SQL statement can be converted to LINQ but Linqer covers many different types of SQL expressions. Linqer supports both .NET languages - C# and Visual Basic.