locked
should I learn ado.net or LinQ RRS feed

  • Question

  • Hi I was talking to my former today. I asked him if he could recommend a good ado.net book and he mention that I should just learn LinQ since its going to replace ado.net.

     

    I am wondering how you guys feel about that? Like maybe I should learn the LinQ and if I need to go back one day and learn ado.net I can learn it then. I don't have much time since I still go to school full time so I can't say I could learn both right now and I have a huge list of other stuff I want to learn(javascrip,ajax,improve c# and asp skills).

    My second questions is what ado.net or LinQ book do you recommend for a noob. All examples should be in c# too.

     

    Thanks

    P.S I did not know if this is the right place to be asking?

    Thursday, January 3, 2008 10:47 PM

Answers

  • Not sure if I would class it as a beginner book. I would say it requires understanding of C# and programming so maybe a beg/int and goes dive deep into certain areas. Of course - you can skip of those bits....

     

    You can download a free Intro to Linq ebook which might be a bit more of a gentle introduction.

     

    http://www.microsoft.com/learning/vstudio/2008/default.mspx#EBOOK

     

    Ben
    Friday, January 4, 2008 12:23 AM

All replies

  • You can actually user Linq along with ADO.net along with objects, sql etc.

     

    Linq to Sql has been viewed as a possible replacement for Ado.Net, Datasets, Datatables etc. but they both have their strengths and weaknesses.  If you've never used ADO.net before you might not miss the items that Linq to Sql is missing, but I would definitely learn linq because it can be used throughout your application not just for handling application data.

    Thursday, January 3, 2008 11:00 PM
  • Hi,

     

    Yes, this is the correct place to be asking questions Smile

     

    I would recommend learning both.  They have different but have simarlies so understanding the core concepts of both would be benefitcal - as you say, both have strengths and weaknesses so having a good core understanding will allow you to pickup anything in addition much easier.

     

    As for book recommendations

     

    Linq I would say Linq in Action - http://www.amazon.co.uk/LINQ-Action-Fabrice-Marguerie/dp/1933988169

     

    C# - I read the 2.0 version of Pro C# which was very good - http://www.amazon.co.uk/Pro-2008-NET-Platform-Fourth/dp/1590598849/ref=pd_sim_dbs_b_title_1 .  This has been updated for 3.5 which is nice to see. This should cover ADO.net but you might want to check.

     

    Also heard very good things about Practical C# - http://www.amazon.co.uk/Practical-Net2-Platform-Lanaguage-Framework/dp/0976613220/ref=sr_1_12?ie=UTF8&s=books&qid=1199401943&sr=1-12

     

    Hope this helps.

     

    Ben

    Thursday, January 3, 2008 11:13 PM
  •  ben2004uk wrote:

    Hi,

     

    Yes, this is the correct place to be asking questions

     

    I would recommend learning both.  They have different but have simarlies so understanding the core concepts of both would be benefitcal - as you say, both have strengths and weaknesses so having a good core understanding will allow you to pickup anything in addition much easier.

     

    As for book recommendations

     

    Linq I would say Linq in Action - http://www.amazon.co.uk/LINQ-Action-Fabrice-Marguerie/dp/1933988169

     

    C# - I read the 2.0 version of Pro C# which was very good - http://www.amazon.co.uk/Pro-2008-NET-Platform-Fourth/dp/1590598849/ref=pd_sim_dbs_b_title_1 .  This has been updated for 3.5 which is nice to see. This should cover ADO.net but you might want to check.

     

    Also heard very good things about Practical C# - http://www.amazon.co.uk/Practical-Net2-Platform-Lanaguage-Framework/dp/0976613220/ref=sr_1_12?ie=UTF8&s=books&qid=1199401943&sr=1-12

     

    Hope this helps.

     

    Ben



    So when would you use ado.net over linQ and vies versa? And if you had time to just learn 1 of them which one would you learn first?
    Thursday, January 3, 2008 11:24 PM
  • Hi,

     

    Not sure when I would use ADO.net over Linq.  I think for almost all the applications I write from now on I will use Linq to SQL.  Of course, if I had to use .Net 2.0 I would use ADO.net.

     

    If I had to learn just one, I would say Linq.

     

    I forgot to mention you can get the ebook of linq in action now - http://www.manning.com/marguerie/

     

    Ben

    Thursday, January 3, 2008 11:29 PM
  •  ben2004uk wrote:

    Hi,

     

    Not sure when I would use ADO.net over Linq.  I think for almost all the applications I write from now on I will use Linq to SQL.  Of course, if I had to use .Net 2.0 I would use ADO.net.

     

    If I had to learn just one, I would say Linq.

     

    I forgot to mention you can get the ebook of linq in action now - http://www.manning.com/marguerie/

     

    Ben



    Hmm of cousre I would love to hear more feedback from other people but I think I might go with LinQ and learn ado.net when I need it after everything else. I have the new visual studios 2008(got free from my school). So its not like I am restricted to .net 2.0 and if this is the new thing that many people are using maybe I should make use of it too.

    What I been able to find is one thing that you could use ado.net for is if your using a non ms sql database since you can't use LinQ with out it.
    Otherwise then that I am not sure what else you could use ado.net over LinQ since I don't know very much about either.

    When you use like the datasource controls and gridview stuff thats using ado.net right?
    Thursday, January 3, 2008 11:46 PM
  • Hi,

     

    For other databases, there is the Entity Framework due out soon (http://msdn2.microsoft.com/en-us/library/aa697427(VS.80).aspx),

     

    As for the data controls, there is a LinqDataSource in 3.5 so you shouldn't have any problems with that.....

     

    Ben

     

    Thursday, January 3, 2008 11:59 PM
  • One caveat is that Linq to Sql entities don't support databinding as well as Ado.net so when you add new items to a collection that you have bound to a Linq to Sql entity you want automatically see the UI updated but there are workarounds for that.

    Friday, January 4, 2008 12:17 AM
  • With the book LinQ in Action thats a beginner book right?  and it covers using linQ with Sql server 2005 right?
    Friday, January 4, 2008 12:20 AM
  • Not sure if I would class it as a beginner book. I would say it requires understanding of C# and programming so maybe a beg/int and goes dive deep into certain areas. Of course - you can skip of those bits....

     

    You can download a free Intro to Linq ebook which might be a bit more of a gentle introduction.

     

    http://www.microsoft.com/learning/vstudio/2008/default.mspx#EBOOK

     

    Ben
    Friday, January 4, 2008 12:23 AM