[barrydahlberg]

.NETs Entity Framework lets you do this using the fantastic LINQ syntax. Commonly you will say which objects to select, then give a projection into a new anonymous type with only the columns you want.

[wtetzner]

It would be much nicer to use if C# had structural typing for the anonymous types, so you could usefully return them.