Re:SQL databases come up with algorithms you’d never have dr...
by miguelrochefort on Saturday April 06, 2019 @08:23AM
(#19590397)
In C#, the LINQ operators on IEnumerable and IObservable are named after the SQL causes (Select, Where, GroupBy, OrderBy, Join, Union, etc).
[ Parent
| on HN ]
Re:SQL databases come up with algorithms you’d never have dr...
by Falell on Saturday April 06, 2019 @09:15AM
(#19590555)
More than that, as part of LINQ they built a whole "expression" engine into the language to make LINQ to SQL more powerful than simple method chains could be. What looks like function calls is actually converted into expression tree at the language level before conversion to SQL statements when communicating with a DB backend.
The method-chains-vs-expression-tree semantics don't matter much when doing typical in-memory map/filter/reduce on lists but make LINQ to SQL and other more complex use cases much more powerful.