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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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