How do convert this SQL query to Linq in VB.NET?

Question

1.00/5 (4 votes)

See more:

SQL

SELECT * FROM tecoGrupoCliente GC WHERE GC.id_grupo IN
(SELECT CL.id_grupo FROM vsgaEmpresa_ObterLista CL

Posted 26-Jul-12 5:41am

Josué Cardoso

Updated 26-Jul-12 7:49am

Sandeep Mewara

v2

Add a Solution

Comments

StianSandberg 26-Jul-12 10:44am

You are using codeproject as a linq-translator..
Why don't yous read a little about linq and learn how to do it yourself. Scott Guthrie has a blog with some basic explanations about linq: ScottGu - Using LINQ to SQL (Part 1)

Sandeep Mewara 26-Jul-12 12:50pm

:thumbsup:

Sandeep Mewara 26-Jul-12 12:50pm

What have you tried so far?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-07-26T14:38:00

If you don't know LINQ, why would you use it ? If your SQL works, and if you know SQL, and don't know enough LINQ to even attempt this, what benefit would it be for you if we do your job, and you end up with code you don't understand ?

To be clear, LINQ is not black magic. It will generate SQL to get your data, same as you've done now.

How do convert this SQL query to Linq in VB.NET?

1 solution

Solution 1

Add your solution here

Preview 0

How do convert this SQL query to Linq in VB.NET?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us