convert sql query to linq

Question

0.00/5 (No votes)

See more:

Hi
This is my query
Please convert to linq

SQL

select j.Sno,j.Title, s.CompanyName  from  CompanyReviews j full outer join Company s
on j.cid=s.Id
where s.Id=98

Thank you...

Posted 5-Jun-14 2:14am

NagaRaju Pesarlanka

Add a Solution

Comments

[no name] 5-Jun-14 8:20am

Please try yourself. We are not a code translation service.

NagaRaju Pesarlanka 5-Jun-14 8:25am

sorry, I got previouse question answere bit late, Thats why I posted again. I am really sorry.

Ajith K Gatty 5-Jun-14 8:34am

some already posted solution for your previous question.Kindly check it. If it is not working as per your need please come back.
Good Luck

4 solutions

Solution 1

Have a look at the samples provided at http://www.codeducky.org/sql-queries-in-linq/[^]

Tyr by yourself and if you are struck somewhere, post the code you have tried so that we can help you

Posted 5-Jun-14 2:23am

Naz_Firdouse

Solution 2

See this query something like below

var query = from j in CompanyReviews
                 join s in Company on j.cid equals s.Id into gj
                 from subpet in gj.DefaultIfEmpty()
     where s.Id=98
                 select new { j.Sno,j.Title, CompanyName= (subpet == null ? String.Empty : subpet.CompanyName) };

Get more details from
msdn: left outer join query[^]

Posted 5-Jun-14 3:00am

sankarsan parida

Solution 3

var query = (from p in CompanyReviews 
 join pa in Company on p.cid equals pa.Id into temp1
 from comp in temp1.DefaultIfEmpty()
 select new { p.Sno, p.Title, comp.CompanyName }).Union(
 from pa2 in Company
 join p2 in CompanyReviews on pa2.Id equals p2.cid into temp2
 from camp in temp2.DefaultIfEmpty()
 select new { camp.Sno, camp.Title, pa2.CompanyName }
Where p.Id=98);

Posted 5-Jun-14 3:17am

CodeChecker 5689

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)

NagaRaju Pesarlanka · Accepted Answer · 2014-06-05T19:17:00

C#

var reviwdata = from j in context.CompanyReviews
                            join s in context.Companies on new { Cid = (Int32)j.Cid } equals new { Cid = s.Id }
                            where
                            s.Id == compId
                            select new
                            {
                                j.Sno,
                                j.Title,
                                j.Cons,
                                j.Date,
                                j.Rating,
                                j.CorrentOrFormer,
                                j.JobTitle,
                                j.Pros,
                                s.CompanyName
                            };