Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VS 2008 Ling vs ado.net vs daab 1

Status
Not open for further replies.

Badgers

Programmer
Nov 20, 2001
187
US
Hi

Does anyone have any opinions regarding the three methods of data access, I am wondering whether linq is another load of crap like the dataset designer in vs 2005 and will end up being slow and inflexible?

Or have they got it right this time ?
 
Personally, I think LINQ is over-hyped. It can be useful, but I don't think it brings something to the table that we desperately need or have been missing.

I much prefer having complete control over the queries that are running against the database rather than some objects creating dynamic sql for me (that's assuming you were referring to LINQ accessing a database). It is possible to use LINQ with stored procedures, so that goes some way to keeping a fairly good level of control but then there won't actually be that many places where this comes in useful (or not may that I can think of anyway).

Unfortunatly, LINQ will become one of the new buzzwords and people will at least what you to understand it and in some circumstances, use it.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]
 
Also, I should add that as long as you have a seperated data access layer then at least you are starting in the right direction.

The DAAB will simplify the amount of code you write over traditional ADO.NET code and it will allow you to change database types easier, so in that respect it's a better option.

LINQ show go some way to doing something similar, I'm just not as convinced as to it's necessity when dealing directly with a typical database (when you are dealing with other types of data access, then it may bring some useful methods).


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]
 
Thats my kind of opinion as well. I havenot looked at linq but figure its a glorified dataset designer.

I think the rules of stored procedures, data readers and hand coded ado.net or daab is fairly reliable and quick.

Thanks for your comments

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top