Why does C# compiler create private DisplayClass when using LINQ method Any() and how can I avoid it?

To understand the “display class” you have to understand closures. The lambda you pass here is a closure, a special type of method that magically drags in state from the scope of the method it’s in and “closes around” it. …except of course that there’s no such thing as magic. All that state has to … Read more

PostgreSQL – IN vs ANY

No, in these variants are same: You can see – the execution plans are same too: postgres=# explain select * from foo1 where id in (select id from foo2); ┌──────────────────────────────────────────────────────────────────┐ │ QUERY PLAN │ ╞══════════════════════════════════════════════════════════════════╡ │ Hash Semi Join (cost=3.25..21.99 rows=100 width=4) │ │ Hash Cond: (foo1.id = foo2.id) │ │ -> Seq Scan on … Read more