1Have you tried Linqer http://www.sqltolinq.com
2
3An SQL-> LINQ converter..
4
5Or LINQPad http://www.linqpad.net/
1SELECT * FROM FLDR.FormInstance WHERE FolderVersionID IN (9224) AND FormDesignVersionID = 2593 AND AnchorDocumentID IN (SELECT DISTINCT AnchorDocumentID FROM FLDR.FormInstance WHERE FolderVersionID IN (9224))
1declare @filterdate
2select * from employeemaster where empresignationdate is null or cast(emptesignationdate as date )>=@filterdate)
1select c.*,s1.BPServicerNameDisplay,s2.BPServicerNameDisplay,s3.BPServicerNameDisplay,s4.BPServicerNameDisplay
2from Clients c
3left join ServicerClientRoles scr1 on c.ClientUID=scr1.clientuid and scr1.ServicerRoleID = 1
4left join servicers s1 on scr1.ServicerUID=s1.ServicerUID
5left join ServicerClientRoles scr2 on c.ClientUID=scr2.clientuid and scr2.ServicerRoleID = 2
6left join servicers s2 on scr2.ServicerUID=s2.ServicerUID
7left join ServicerClientRoles scr3 on c.ClientUID=scr3.clientuid and scr3.ServicerRoleID = 3
8left join servicers s3 on scr3.ServicerUID=s3.ServicerUID
9left join ServicerClientRoles scr4 on c.ClientUID=scr4.clientuid and scr4.ServicerRoleID = 4
10left join servicers s4 on scr4.ServicerUID=s4.ServicerUID
11where c.ClientUID='189A30C0-6AEA-EB11-B838-0050569E34FB'