LINQ Code equivalent of a TSQL query

Question

2.33/5 (3 votes)

See more:

Hi
I want a linq code equivalent of this:

SQL

Select Company.Name, 
       Person.Name
             From Person, Company
                  Where Company.PersonID = Person.ID And 
                              Company.City = N"Bolton"

Entity names: Company, Person

Posted 11-Feb-12 12:00pm

Fardan

Add a Solution

4 solutions

Solution 3

Check this article
Learn SQL to LINQ (Visual Representation)[^]

EDIT
For this kind of things, use conversion tools for example LINQPad[^]

Posted 11-Feb-12 16:58pm

thatraja

Updated 11-Feb-12 21:38pm

v2

Comments

Fardan 12-Feb-12 3:21am

Not my anser.
The article doesn't include a query with more that 1 from.
(From Person, Company)

thatraja 12-Feb-12 3:39am

Check updated answer

Espen Harlinn 28-Feb-12 14:22pm

Good reply :)

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)

zyck · Accepted Answer · 2012-02-11T13:59:00

Solution 2

try this Code

C#

var QueryResult = from p in Person
                  join c in Company on p.ID equals c.PersonID 
                  where c.City == N"Bolton"
                  select new { c.Name, p.Name };

Click here for more information
Vote or Accept solution
If this will help you
thanks

Posted 11-Feb-12 13:59pm

zyck

Updated 11-Feb-12 14:03pm

v2

Comments

Fardan 12-Feb-12 3:12am

Thank you

zyck 12-Feb-12 3:47am

your welcome (n_n)

Wonde Tadesse · Accepted Answer · 2012-02-11T17:18:00

Solution 4

Use Linqer [^] tool to translate any SQL statement to LINQ.

Posted 11-Feb-12 17:18pm

Wonde Tadesse

Comments

Fardan 12-Feb-12 3:08am

Thank you. Not my answer but a useful link.

Wonde Tadesse 13-Mar-12 23:38pm

You 're welcome.

Espen Harlinn 28-Feb-12 14:19pm

Good advice :)

Wonde Tadesse 13-Mar-12 23:38pm

Thanks

VJ Reddy 23-Apr-12 19:31pm

+5

Wonde Tadesse 24-Apr-12 19:31pm

Thanks

Christian Graus · Accepted Answer · 2012-02-11T13:58:00

Solution 1

Wow - that's pretty trivial. Something like

C#

from c in categories
        join p in products on c equals p.Category into ps
        select new { Category = c, Products = ps };

That is a sample from the site below. You should be able to convert this syntax to suit your requirements.

http://msdn.microsoft.com/en-us/vstudio/aa336746[^]

Posted 11-Feb-12 13:58pm

Christian Graus

Comments

Espen Harlinn 28-Feb-12 14:20pm

5'ed! :)