Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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 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

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: 380 | Views in the last 30 days: 1
Related Articles


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


Podcast Announcements

Podcast Feeds


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...


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, ...


Feature (In)Complete

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


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones