Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Table Level Access

By Steve Jones,

I've been discussing LINQ with some people and someone brought up a very interesting point. With LINQ->SQL you need to grant table-level access for developers to use the interesting features of LINQ, at least the time-saving ones from what I've seen.

Or do you?

Is there enough of a benefit from LINQ and the associated but different Entity Framework? Personally I'm not sure because I'm not a deep developer, though I did get to talk to a few of the LINQ guys at Microsoft.

From their perspective, developers spend a good portion of their time writing queries and processing result sets when they could be building more of the features in their application. LINQ -> SQL is supposed to greatly reduce that time, saving developers a tremendous amount of time. I'm not sure how much time the average developer spends on writing queries and mapping the object to relational, but I'd be curious to know what some of you in the real world think.

You can still build views to encapsulate some security, and table-valued functions might be the other way to integrate with LINQ and still keep some control over what developers can do, security-wise. I'm not convinced that LINQ is a step forwards, but I am leaning that way. It's certainly being pushed and I'm not sure we'll see that stop anytime soon. I've been told a lot of engineering work went into ensuring that LINQ -> SQL doesn't allow any SQL Injection vulnerabilities, which would potentially be a very large reason to consider LINQ.

In any case, I would really be interested in hearing what some of the developers out there think about it's benefits, especially in terms of how much more productive it makes you.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

 
Total article views: 383 | Views in the last 30 days: 2
 
Related Articles
BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

ARTICLE

Podcast Announcements

Podcast Feeds

BLOG

Chroma Key - Podcasting Tips

I've been wanting to play with the Chroma Key features of my video editing, but I haven't really spe...

BLOG

Talking TypeScript on the .NET Rocks! Podcast

I appeared on the .NET Rocks podcast show #1149 this week.  I had a blast talking about TypeScript, ...

ARTICLE

Feature (In)Complete

A look at some of the interesting database news from the previous week (March 24, 2008).

Tags
editorial    
 
Contribute