Using LINQ to SQL
One of the great things about LINQ to SQL is that the syntax is identical to LINQ to Objects. LINQ to SQL is a powerful demonstration of one of the core concepts of functional programming: the separation of declaration and mechanism. What does that mean? In LINQ, you describe how the desired result is related to the input data using operators. While these operators have a consistent definition of how they will act on data, what they don't do is specify how they do the work. Since operators are not tied to a specific implementation, frameworks are free to implement operators in different ways.
In this case, LINQ to SQL will actually take our query and transform it into an internal optimized representation that it will send directly ...
Get Programming Reactive Extensions and LINQ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.