convert sql query to linq

Try this link:

http://www.sqltolinq.com/[^]

You can download software to Convert Sql to linq or vise versa.

Thanks

hi,

try like these

var x =from p in db.Persons orderby a.FirstName descending select p;

the word displayby is not a sql keyword
and for newid()
have look at this link

select Id,ScheduleDate,TimeSlot,DecommissionedDate from lnkRegScheduleDate
where ID = (Select Max(Id) from lnkRegScheduleDate where  RegId = @RegId)

SELECT     Engineering.IncomingDetail.DocumentId, MAX(Engineering.IncomingHeader.DccReceivedDate) AS maxDccReceivedDate
FROM         Engineering.IncomingHeader INNER JOIN
                      Engineering.IncomingDetail ON Engineering.IncomingHeader.ID = Engineering.IncomingDetail.IncomingHeaderId INNER JOIN
                      Engineering.[Document] ON Engineering.IncomingDetail.DocumentId = Engineering.[Document].ID
WHERE     (Engineering.[Document].IsOmit = 0)
GROUP BY Engineering.IncomingDetail.DocumentId

Hi,
You can try this one....

var Query = from temp in db.Employee orderby temp.Displayby ascending select temp;
Employee objemp = new Employee();
string newid = objemp.Id.ToString();

Select BrandDescription, CAPEXLookUp, count (*) frpm CAPEXRecord
            inner join Facility on CAPEXRecord.facilityId= facility.facilityId
            inner join FacilityBrand on facility.facilityBrand=facilityBrand.FacilityBrandId
            inner join CAPEXLookUp on CapexLookUp.LookUpId= CAPEXRecord.lookupId
            group by facilitybrand.branddescription, CAPEXLookUp.Description

select top 10 * from customerReviews where reviewid not in (select top 2 reviewid from customerReviews);

select max(codigo) from Provisiones
where IdPeriodo = 13 and IdCentroCosto in (
select IdCentroCosto from CentroCostos where IdCompania = 1)

SELECT CAST(a.FechaIngreso AS DATE),p.Apellido,
SUM(CASE WHEN ag.Id is NULL THEN 0 ELSE 1 END) AS Generales,
SUM(CASE WHEN ld.Id is NULL THEN 0 ELSE 1 END) AS Leyes,
SUM(CASE WHEN aa.Id is NULL THEN 0 ELSE 1 END) AS ModificadoGenerales,
SUM(CASE WHEN ald.Id is NULL THEN 0 ELSE 1 END) AS ModificadoLeyes
FROM dbo.Avisos a
LEFT JOIN dbo.Aviso_Generales ag ON a.id = ag.Id
LEFT JOIN dbo.Avisos_LeyesDecretos ld ON a.id = ld.id
LEFT JOIN dbo.AvisosAuditoria aa ON aa.AvisoId = a.Id
LEFT JOIN dbo.AvisoAuditoria_Generales aag ON aa.Id = aag.Id
LEFT JOIN dbo.AvisosAuditoria_LeyesDecretos ald ON aa.id = ald.id
INNER JOIN dbo.Personas p ON a.PersonaId = p.Id
WHERE a.FechaIngreso >= '20180222'
GROUP BY CAST(a.FechaIngreso AS DATE),p.Apellido