SELECT * FROM ADRES

How to convert the following SQL query into LINQ Query

select * from Cid where vid=665 and bookid=4

How to convert SQL Query into LINQ ??

SELECT max(Sub.SubjectID) AS SubjectID,max(Sub.SubjectName) AS SubjectName, Sub.AreaDetails_ID,max(Area.Assessment_AreaName) AS Assessment_AreaName
FROM tbl_Subject AS Sub INNER JOIN
tbl_CCEAssessmentAreaDetails AS Area on Sub.AreaDetails_ID = Area.AreaDetails_ID INNER JOIN
tbl_CCEComprehensiveType AS Comprehensive on Sub.ComprehenciveTypeID = Comprehensive.ComprehenciveTypeID
WHERE Sub.CourseID = 22 AND Sub.status = 'A' AND Sub.GoverningBodyID = 1 AND Sub.ComprehenciveTypeID = 2
GROUP BY Sub.AreaDetails_ID

LINQ is for people who don't understand SQL...

Is it possible to convert sql statement into Linq statement using LinqPad?

I want to convert this statement using linq pad my quey is

SELECT * FROM TblSourceA FULL OUTER JOIN TblSourceB ON TblSourceA.First=TblSourceB.First OR TblSourceA.Last=TblSourceB.Last;

because how i use or oprator in Linq query

@nurullah - so you're pasting a SQL query into the comment box in the hope that it will magically convert!

select * from CekSenet
left join (select top 1 ceksenet.CariKartFk,ceksenet.CekSenetFk from CekSenet order by CekSenetPK desc ) acs on acs.CekSenetFk = CekSenet.CekSenetPK
where CekSenet.CekSenetFk =0 and acs.CariKartFk = 8

Hi,

Linqer does that: http://www.sqltolinq.com/
regards,

Matthijs

What other tools? I have never seen anything that does that!