Convert this query int LINQ..possible??
Posted on 2013-11-20
Hello, I would like, if possible, to convert this SQL query into LINQ. Basically is a group query that joins to itself.
select t1.invoiceno from testdups as t1
left join testdups as t2 on t1.InvoiceNo = t2.invoiceno
where t1.IsInvoice <> t2.IsInvoice
group by t1.invoiceno
having count(t1.invoiceno)> 1