ADO.NET in a Nutshell ❮PDF / Epub❯ ☉ ADO.NET in a Nutshell ✩ Author Matthew MacDonald – Written by experts on the Microsoft programming platform, ADO in a Nutshell delivers everything programmers will need to get a jump start on ADO technology or to sharpen their skills even further In t Written by experts on the Microsoft programming platform, ADO in a Nutshell delivers everything programmers will need to get a jump start on ADO technology or to sharpen their skills even further In the tradition of O Reilly s In a Nutshell Series, ADO in a Nutshell is the most complete and concise source of ADO.NET in PDF/EPUB or ADO information availableO is the suite of data access technologies in the Framework that developers use to build applications services accessing relational data and XML Connecting to databases is a fundamental part of most applications, whether they are web, Windows, distributed, client server, XML Web Services, or something entirely different But ADO is substantially different from Microsoft s previous data access technologies including the previous version of ADO so even experienced developers need to understand the basics of the new disconnected model before they start programming with itCurrent with the Framework , ADO in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO namespaces and object model In addition to being a valuable reference, this book provides a concise foundation for programming with ADO and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access Using C , this book presents real world, practical examples that will help you put ADO to work immediatelyTopics covered in the book include An Introduction to ADOConnections, Commands and DataReadersDisconnected DataAdvanced DataSetsTransactionsDataViews and Data BindingXML and the DataSetIncluded with the book is a Visual Studio add in that integrates the entire reference directly into your help files When combining ADO in a Nutshell with other books from O Reilly s In a Nutshell series, you ll have a comprehensive, detailed and independent reference collection that will help you become productive.

6 thoughts on “ADO.NET in a Nutshell

  1. ueberhund ueberhund says:

    I have always been a fan of the O Reilly Nutshell series, and this book lives up to the tradition of its predecessors However, this book actually goes one step further all the content in the book is provided on an accompanying CD, which integrates an electronic version of the book directly into Visual Studio.NET This means that like the regular MSDN documentation , the O Reilly documentation becomes a part of your context sensitive help Now that s pretty cool The book is current with the 1.1 version of the Framework, which is a big deal, since there were some pretty significant changes to XML in this release which is integral to ADO.NET Like all the other Nutshell books, this one begins out with a quick introduction to all of the popular classes in ADO.NET through explanation and examples of use I personally enjoyed the section on DataTables, as there is a lot of discussion on things I don t normally do in conjunction with DataTables, like computing aggregate calculations and merging data sets.Even though this is an ADO.NET book, the authors realize that you can t talk about just ADO.NET, you really need some discussion on implementing the data in a GUI like using a DataGrid The authors actually spend some time discussing various issues in data binding and various methods for retrieving and displaying data via this mechanism.Finally, there is considerable discussion for a Nutshell book on the relationship between a DataSet and XML This discussion also includes the basics of using an XSLT to transform XML.

  2. Jack D. Herrington Jack D. Herrington says:

    This book is classic O Reilly It s separated into three sections The first being a thorough but brief introduction to all aspects of the API The second section is an API reference And the third a quick reference This third section is included on the CD that comes with the book and will integrate into Visual Studio.Don t expect the first section of the book, which is an introduction to ADO.NET to give you a gentle introduction to the subject That s not the Nutshell form If you don t know ADO at all you will want to buy both this book and an introductory book If you know related APIs, or you know ADO.NET and you need a refresher or have weak spots you will find some new things in the first section For me it was the support for disconnect access and also the integration with the XML features of SQL Server 2000.Although this book stays true to the Nutshell form it is a little longer in the introduction than the usual The introductory section is seventeen chapters and is almost half of the length of the book So if you are an intermediate or advanced engineer I think you could probably learn enough ADO directly from this book without any other introductory book.

  3. William Ryan William Ryan says:

    Not too long ago, I thought I didn t like O Reilly titles I ve since done a 180 and have really grown to like them This book is one of the reason s why I m a big fan of the Authors and bought it just because I try to read every ADO.NET title that I can get my hands on, and try to buy everything MacDonald writes.The book is concise and too the point. It s not a definitive reference to ADO.NET If you haven t bought David Sceppa s book or Bill Vaughn s buy those two and this one but it s a very practical how to guide for a lot of common tasks If you are familiar with Matt s stuff, it s very typical of his style I think he s one of the interesting writers out there and this book keeps your attention I m an ADO.NET nut, so I m highly opininated on such literature, but this book really lived up to my expectations.Basically, if you are looking for a concise and very to the point book on ADO.NET, particularly if you have a decent understanding of the technology, you ll be glad you bought this book I have bought and loved every title MacDonald has written, and this book is a great example of why.

  4. Clive Sinclair Clive Sinclair says:

    The first third of the book discusses, with code samples, how the component parts connections, data providers, data readers, data sets etc fit together This is interesting.The next third analyses the classes themselves but can be seen as a help rehash altho this is a little harsh since it does go into detail than the standard help.And the last third lays out the namespaces themselves and shows the classes within them, tabulating their members without further comment Not useful.In the end, I still didn t feel confident enough to develop even a simple application except with the data grid, as in many samples Why would I want to merge two data sets, and why do I get duplicates in the data set but not the underlying data base What exactly happens when I Update, or EndEdit When I do a Fill on a dataset, am I really sucking the entire data into memory Is this efficient, what is Best Practice on this ADO.NET puts a large, complex, flexible abstraction between the developer and the database itself, and what is needed is someone to show the correct way to use all these bits in real world programs.

  5. Keith Keith says:

    I ve owned this book for 3 days and cannot put it down I have not been a big fan of O Reilly over the years, but this book is incredible It goes into the detail that most books seem to omit and it s those details that we developers desperately need.I would recommend this book to ANY and ALL.NET developers who are writing code that hits against a database There are topics covered in this book that Microsoft s own MSDN and VS.NET help system seem to fail at properly explaining It s because of this that I ve found myself all too often going to and google groups to get answers to ADO.NET questions that this book actually covers.My hat goes off to authors Matthew MacDonald and Bill Hamilton on a job well done.Coming from a Visual Basic background and now working in VB.NET and C.NET, this book should satisfy both the VB.NET and C developer.

  6. Carlos Salvatierra Carlos Salvatierra says:

    I bought the paperback in 2005 and used it heavily Somehow I lost the paperback and now bought it again in kindle Very well written reference manual and the best I have seen on the topic.

Leave a Reply

Your email address will not be published. Required fields are marked *