Re:The SQL filter clause: selective aggregates
by MichaelGG on Monday May 30, 2016 @04:23PM
(#11802965)
LINQ to SQL ends up creating an expression on IQueryable. You can build this expression up any way you want, including in bits and pieces. You can tack on Wheres and Selects any time you like. It's more composable than pain text SQL since the parts can go in any order.
It's only after you force it to materialize (I.e. call ToList) that you can't further "compose" it.
If you have an example of .NET based query composition to share I'd like to see it; last I checked there was no such functionality available.