LINQ scares the heck outta me!

Some integration efforts are great ideas, but others are not sure bets. Such as the inventor who wanted to make carbonated vegetable drinks.  Sure, the idea integrates the great nutrients of vegetable juices and the effervescence of sodas.  But, in this case, 1 + 1 = 0.

I’m wondering if Microsoft’s newest language development idea, called LINQ (for the .Net Language Integrated Query), is a sure bet or not.  LINQ was announced at Microsoft PDC (Professional Developer’s Conference) yesterday and was created by .Net grandfather, Anders Hejlesberg.  LINQ is intended to solve the problem of how to integrate various sources of data into applications built with object-oriented programming models.

LINQ does this by adding new data-query capability to .Net languages.  Now, this is not just relational databases, this applies to all forms of data such as XML documents from the VB.NET and C# code.  You will then use the LINQ syntax for querying data rather than using SQL (the Structured Query Language).

Am I in favor of this direction?  Well, there are two sides to this coin.  Developers are going to love not having to learn new languages, and the additional debugging, troubleshooting, and performance tuning techniques for a whole new language.  On the other hand, as an enterprise DBA, I don’t like it. 

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

Every enterprise IT shop I visit these days has multiple database platforms in place.  As a database professional, you’ll need to be able to move between these platforms.  You won’t need to move smoothly, but you should be able to at least write a decent SELECT statement on each of your major databases.  Will LINQ enable you to do this – almost definitely not – unless the database platforms of your enterprise IT shop consist solely of Microsoft SQL Server.

 

The silver lining in this cloud on the horizon is that it is far, far off on the horizon.  LINQ probably won’t be here for a long time.  It requires new work in both Visual Studio and SQL Server, and we all know how long the last iteration of those products took.  Still, it’s something to think about and keep in mind.

 

For more details, see http://www.infoworld.com/article/05/09/14/HNfuturewithlinq_1.html?source=rss&url=http://www.infoworld.com/article/05/09/14/HNfuturewithlinq_1.html.

 

Let me know what you think.  Is LINQ more bark than bite?

 

Cheers,

 

-Kevin

Please or Register to post comments.

Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More
synchronize key on computer keyboard
Sep 5, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 4: Synchronizing Server-Level Details

When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in these scenarios is the availability group (or the group of user-defined databases)....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×