Translate sql statement to Linq expression

Question

0.00/5 (No votes)

See more:

Hello!

I'm not that familiar with Linq and lambda.
I have this SQL statement that i want to translate into a Linq or Lamda expression.

SQL

Select A, C, D, Count(D) AS ‘E’ FROM TABLE
WHERE C = 2 AND D = 4 
GROUP BY A, C, D

Can someone help me translate this into Linq or Lambda?

Thanks!

Posted 1-Dec-11 0:15am

CrafterIt

Updated 1-Dec-11 2:01am

v3

Add a Solution

Comments

Amir Mahfoozi 1-Dec-11 6:33am

Are you sure that this is a correct SQL statement ?

CrafterIt 1-Dec-11 7:06am

No sorry, forgot to add group by A, C, D

Amir Mahfoozi 1-Dec-11 7:41am

It still looks incorrect to me :) there should be a comma between d and count(d)

CrafterIt 1-Dec-11 8:05am

you are right, forgot that too :)

3 solutions

Add a Solution

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

Anuj Banka · Answer 1 · 2011-12-01T00:55:00

Solution 1

This is just an example don't know the run time results::

var z = from x in Table
where x.c = 2 and d = 4
select  A = x.a, B = x.b ,D =x.d , E = x.D.Count()

But you can get idea from this

You also can take help from this link

How To: LINQ To SQL Transformations - Part II[^]

Posted 1-Dec-11 0:55am

Anuj Banka

Updated 1-Dec-11 0:56am

v2

Comments

CrafterIt 1-Dec-11 7:09am

Thanks, i will look at it.

RaviRanjanKr · Answer 2 · 2011-12-01T01:20:00

Solution 2

Try
Converting SQL to LINQ, Part 1: The Basics (Bill Horst)[^]

Posted 1-Dec-11 1:20am

RaviRanjanKr

Comments

CrafterIt 1-Dec-11 8:06am

Thanks this looks promising :)

SuhasHaridas · Answer 3 · 2012-08-13T00:33:00

Solution 3

SQL

here i am posting some thing about Linq basic operation select, insert, delete, update.

http://suhasharidas.blogspot.in/2012/08/create-linq-to-sql-connection-with.html[^]

Posted 13-Aug-12 0:33am

SuhasHaridas

Translate sql statement to Linq expression

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Translate sql statement to Linq expression

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us