Linq 2 Sql / ADO.Net

[GeorgeB]

Hi,

This is not really a technical question but more of a "whats out there"...

Do you guys see lots of companies preferring to use Linq 2 SQL over standard ADO.Net these days?

If companies do prefer L2S, do they still use stored procedures? Personally, 99% of the stuff I do currently is ADO.Net talking to stored procs.

I'm trying to guage if its worth me bothering getting my Linq skills toned up or not.

cheers.
George.

[woohoo]

My last couple of contracts have involved Linq in someway, however I've mostly been using Linq with Entity Framework rather than Linq 2 Sql.

If you go down the Linq route, Ive found LinqPad to be really helpful, so you can easily view the sql your linq statement generates.

[eek]

I would think its all linqs to entity frameworks nowadays I'm sure linq to Sql has been given the heave-ho.

Personally everything in my world is now nosql with custom translation routines to datatables as required.

[GeorgeB]

Thanks guys. This will help me plan my self training to get up to date with all the cool toys

[PAH]

Getting clued up on database optimisation may be a nice niche for when all those companies using Linq2Whatever, Entity Framework, etc find the performance isn't good enough, as they don't have sufficient control over indexes, execution plans, or optimised queries.

Currently a mixture of new data access methods alongside more traditional stored procs and database views are often seen as the best way of building an efficient solution.

There are also some things you can't easily do with Linq that is piss easy with older methods, so that may be another area worth investigating.

[GeorgeB]

Yeah, I'm fairly confident with the "old" method of ado.net, sql class sprocs etc.

I think being a permy in the same company for a while now has left me in need of the new skills which every company seems to be asking for... namely MVC and Linq.

However, MVC and Linq do seem really cool - I just need to get a bit of experience under my belt for these clients companies. I'm missing out on so many opportunities without these on my CV

Cheers,