I’m really struggling to convert the following SQL to a LINQ query. Can anyone help?
select invoice, date, amount, Name from payments where invoice in
(
select invoice
from payments
where invoicelike 'EVENT%' and status = 3 and date >= '2023-11-01 00:00'
group by invoice
having count(*) > 1
)
order by invoice, date desc