Feeds

Mind your languages with Microsoft LINQ

Data-access sticking plaster?

Build a business case: developing custom apps

The application developer-centric approach is to make the database - or any source of data - look like a data structure in an application, which is how LINQ addresses the problem. The database-centric approach has always been that the application developer has to learn SQL.

Given that Hejlsberg has mainly worked on the application language side, it is not surprising that he favors the former approach and, given his experience, these views are well worth very taking seriously.

It just isn't that simple, though. For a start, it can be argued that LINQ is a solution to a problem that shouldn't exist. For example, Hejlsberg has argued that application developers currently: "Have to learn database languages such as SQL and what comes with it, such as stored procedures and data types, while also mastering programming languages such as C#, VisualBasic or even Java."

In a well-designed database it is possible to use features like stored procedures to completely shield the application developer from the tables and therefore the need to write SQL.

To try to forestall comments pointing out that most databases are not well designed and that a knowledge of SQL is essential in order to reach the data therein, I'd like to say: "I know - I agree". But that doesn't stop people arguing that LINQ is treating the symptom, not the disease. Instead of applying the LINQ plaster to the gaping wound, we should be making it easier to create an abstraction layer in the database. Application programmers could then write against that layer rather than the actual tables.

This would also address another criticism leveled at LINQ, which is that whilst it isn't SQL, it still writes directly to the tables. As soon as the table structure is altered, the application breaks.

The bottom line is that it is impossible to know as yet whether LINQ will succeed or fail; ultimately that will depend on whether application developers use it or not. The fact that Microsoft is behind LINQ will encourage some and discourage others. The support of Hejlsberg will influence yet others, myself included, to at least give it a go.®

5 things you didn’t know about cloud backup

More from The Register

next story
PEAK LANDFILL: Why tablet gloom is good news for Windows users
Sinofsky's hybrid strategy looks dafter than ever
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
POW! Apple smites Macbook Air EFI firmware update borkage
Fruity firm provides digital balm for furious fanbois
Call off the firing squad: HP grants stay of execution to OpenVMS
Startup to take over support for today's Itaniums and beyond
Fiendishly complex password app extension ships for iOS 8
Just slip it in, won't hurt a bit, 1Password makers urge devs
Mozilla keeps its Beard, hopes anti-gay marriage troubles are now over
Plenty on new CEO's todo list – starting with Firefox's slipping grasp
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
prev story

Whitepapers

7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
Solving today's distributed Big Data backup challenges
Enable IT efficiency and allow a firm to access and reuse corporate information for competitive advantage, ultimately changing business outcomes.
A new approach to endpoint data protection
What is the best way to ensure comprehensive visibility, management, and control of information on both company-owned and employee-owned devices?