convert SQL to LINQ query

Question

i want to convert this query into LINQ Select D.ID as ID D.OName ( Select Count (*) from tblve WHERE MID = D.ID and Vme '' ) D.MilD.Speed from tblRe M inner join tblReg D On M.RID = D.RID main problem is subquery

Satya Karki · Answer

Hi to convert SQL query to LINQ you can try below site. http://www.sqltolinq.com/

Vinay Singh · Answer

Hi try the below tool to convert it https://www.linqpad.net/ http://www.sqltolinq.com/

Jaman Savar · Answer

Select * from order

Francisco Jose · Answer

declare @usuario int = 0; declare @fase int = -1; declare @grupoTrabalho int = 0; declare @dataInicio datetime = '2021-06-01 00:00:00'; declare @dataFim datetime = '2021-06-30 23:59:59'; set dateformat ymd print @dataInicio print @dataFim SELECT convert(varchar(10)TEMP.Data 103) TEMP.Usuário TEMP.Fase TEMP.Grupo SUM(TEMP.QTD_DOCS) 'Total de Imagens' SUM(TEMP.QTD_IMGS) 'Total de Imagens' SUM(TEMP.Horas_Trab) AS 'Horas_Trab' FROM ( SELECT convert(varchar(10)h.data_hora_fim 103) as 'Data' U.nome as 'Usuário' h.fase 'Fase' g.nome 'Grupo' SUM(H.qnt_docs) AS 'QTD_DOCS' SUM(H.qnt_imgs) AS 'QTD_IMGS' SUM(DATEDIFF(MINUTE h.data_hora_fim data_hora_inicio)/60) AS 'Horas_Trab' FROM SCAN_LOTE L join SCAN_LOTE_HISTORICO H ON H.lote_id=L.id join USUARIO U on H.[usuario_id]=U.id join GRUPO G on l.grupo_trabalho_id = G.id where (h.data_hora_inicio BETWEEN @dataInicio and @datafim) and (h.data_hora_fim BETWEEN @dataInicio and @dataFim) and (H.usuario_id = @usuario or @usuario = 0) and (L.fase = @fase or @fase = -1) and (L.grupo_trabalho_id = @grupoTrabalho or @grupoTrabalho = 0) AND U.USUARIO_EXTERNO and H.usuario_id = u.id AND H.FINALIZADO = 1 AND L.EXCLUIDO = 0 GROUP BY h.data_hora_fim u.nome h.fase g.nome UNION SELECT 'Total' '-' '-' '-' SUM(H.qnt_docs) 'Total de Documentos' SUM(H.qnt_imgs) 'Total de Imagens' SUM(DATEDIFF(MINUTE h.data_hora_fim data_hora_inicio)/60) AS 'Horas_Trab' FROM SCAN_LOTE L join SCAN_LOTE_HISTORICO H ON H.lote_id=L.id join USUARIO U on H.[usuario_id]=U.id where (h.data_hora_inicio BETWEEN @dataInicio and @dataFim) and (h.data_hora_fim BETWEEN @dataInicio and @dataFim) and (H.usuario_id = @usuario or @usuario = 0) and (L.fase = @fase or @fase = -1) and (L.grupo_trabalho_id = @grupoTrabalho or @grupoTrabalho = 0) AND U.USUARIO_EXTERNO and H.usuario_id = u.id AND H.FINALIZADO = 1 AND L.EXCLUIDO = 0 ) TEMP GROUP BY TEMP.QTD_IMGS TEMP.Data TEMP.Usuário TEMP.Fase TEMP.Grupo ORDER BY TEMP.Data TEMP.Usuário TEMP.Fase

Wellington Jesus · Answer

Select Distinct NoTanqueMedidor From Tanque Where Tanque.NoTanqueMedidor 0 And Tanque.IdPosto = @IdPosto And DatePart(hhGetDate()) >= @NoHora And NoTanqueMedidor Not In (Select Distinct NoTanque From MedicaoDeTanque Where MedicaoDeTanque.IdPosto = @IdPosto And Convert(DateDtMedicaoDeTanque) = Convert(DateGetDate()) And DatePart(hhDtMedicaoDeTanque) >= @NoHora) Order By Tanque.NoTanqueMedidor

Dhara Patel · Answer

var Data = tblRe.Join( tblReg M => M.RID D => D.RID (M D) => new { ID = D.ID Name=D.OName Total=tblve.Count(r=>r.MID==D.ID && Vme!=null) Mile=D.Mil Speed=D.Speed });

Mageshwaran R · Answer

Hi please refer this link: http://www.sqltolinq.com/

Madan Shekar · Answer

var result= (from table1obj in db.table1 join table2obj in db.table2 on table1obj.RID equals table2obj.RID select new { table2objid=table2obj.ID table2objName=table2obj.oname countvalue=db.tblve.where(t=>t.MID==table2obj.ID).Tolist().count }).Tolist(); if it helps mark as answer otherwise ping me with query

Rakesh Dandaragi · Answer

;WITH Numbers AS ( SELECT 1 AS value UNION ALL SELECT value + 1 AS value FROM Numbers WHERE Numbers.value ) SELECT FinalTable.FromDateFinalTable.AddedDaysFinalTable.AdjustedDate FROM ( SELECT Final.*ROW_Number() OVER (ORDER BY (SELECT NULL)) AS AddedDays FROM ( SELECT tbl.FromDateCASE WHEN DATENAME(dwtbl.AdjustedDate) = 'Saturday' THEN 0 WHEN DATENAME(dwtbl.AdjustedDate) = 'Sunday' THEN 0 WHEN tbl.AdjustedDate in (SELECT HolidayDate FROM mHolidayMasterTBL) THEN 0 ELSE 1 END AS LogicNumber tbl.days tbl.AdjustedDate FROM ( SELECT @FromDate AS FromDate DATEADD(DAYnum@FromDate) AS AdjustedDate num AS days FROM ( SELECT ROW_Number() OVER (ORDER BY (SELECT NULL)) AS num FROM Numbers ) t WHERE num ) tbl )Final WHERE LogicNumber = 1 )FinalTable WHERE AddedDays = @NoOfDays