Marjorie Fiallos

Marjorie Fiallos

  • NA
  • 10
  • 2.3k

How to convert sql to linq using C#

Jan 16 2017 3:21 PM
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';

Answers (2)