SQL to LINQ converter

select * from (select * from sregUHSP 
              where SUHSPsavpid = :1 AND SUHSPInitialDate <= :2
              AND nvl(SUHSPLastDateActive, 'N') = 'N'
			  AND ((suhspnextdate is null) OR (suhspnextdate <= :3))
              union select * from sregUHSP
              where SUHSPsavpid = :4 AND SUHSPInititalDate <= :5 
				AND  nvl(SUHSPLastDateActive, 'N') = 'Y'
			  AND ((suhspnextdate is null) OR (suhspnextdate <= :7))
              order by 1,2,3) u
left join sreghref href on href.shrefissuerid = u.SUHSPIssuerId
AND href.shrefnumb = u.SUHSPNumb 
AND href.shrefhsubtype = u.SUHSPSubType
join sregmbal m on m.smbalissuerid = u.suhspissuerid
AND m.smbalnumb = u.suhspnumb
AND m.smbalclass = u.suhspclass
left join (select b.investorreferenceid, b.reference BondPolicy,
          f.paidinfull from bondfuneraldata f
          join bond b on b.id = f.bondid) contract
on contract.investorreferenceid = href.shrefreferenceid
AND trim(u.suhspcert) = trim(contract.BondPolicy)
where m.smbalunits > 0

SQL to LINQ converter

select top 10 p.Nombre, p.Apellidos, (SELECT COUNT(*) FROM Personas ps WHERE PS.ParentCode LIKE '%' + CONVERT(VARCHAR, p.id) + '-%'   ) Total  
from personas p
ORDER BY Total desc

Sql to c# linq converter online

Have you tried Linqer http://www.sqltolinq.com

An SQL-> LINQ converter..

Or LINQPad http://www.linqpad.net/

-1

Similar codes

1 vote326 views6 answers
In sql
SQL
0 vote348 views1 answer
Sparql if bound query
SQL
0 vote336 views1 answer
Luu ckeditor vao mysql
SQL
9 votes381 views3 answers
Import DB through mysql console
SQL
9 votes321 views6 answers
Sql insert into
SQL
0 vote387 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote382 views1 answer
Combine 2 columns search query mysql
SQL
0 vote383 views1 answer
Sql int vs integer
SQL
0 vote343 views1 answer
How to access to mysql without root
SQL
1 vote341 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL