By Tech Ed 2008, it will be almost two years since this posting appeared on LINQ in Action blog, so it wins today's LINQ links. It's interesting to take another look at some of the projected values to developers and architects back in mid 2006...
http://linqinaction.net/blogs/main/archive/2006/07/28/why-linq-will-succeed.aspx
- LINQ syntax beats SQL syntax. SQL is flawed in that queries become exponentially difficult to write as their complexity grows. LINQ scales much better in this regard. Once you get used to it, it's hard to go back.
- Database queries are easily composable. You can conditionally add an ORDER BY or WHERE predicate without discovering at run-time that a certain string combination generates a syntax error.
- More bugs are picked up at compile-time.
- Parameterization is automatic and type-safe.
- LINQ queries can directly populate an object hierarchy.
- LINQ to SQL provides a model for provider independence that might really work.
- LINQ significantly cuts plumbing code and clutter. Without sweeping stuff under the carpet, like Workflow or Datasets. This is a credit to the design team.
- C# hasn't suffered in the process (in fact, it's gained).
Out of 8 projections, dotNET Connections would give this forecast a 5/8. Not bad considering how inaccurate these predictions tend to be. Before dotNETConnections publishes what we value-adds we think won out, lets hear your thoughts. Comment below!