How to convert sql to linq using C#

Marjorie Fiallos

9y1.5kLINQ

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';

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Catcher Wong9y ago
Accepted 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 Prajapati9y ago
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.