First Look at ADO.NET and System Xml v 2.0

Alex Homer is managing director of Stonebroom, Ltd., a software-development, consulting, and training organization. He was formerly lead technical author and reviewer for Wrox Press, specializing in Microsoft Web and database technologies Dave Sussman speaks frequently at Microsoft development conferences and has been writing about ASP since its earliest releases. Mark Fussell is a lead program manager at Microsoft, working on XML and Web service technologies. He designed the XML APIs in version 1.0 release of System.Xml in the .NET Framework and worked on the design of version 2.0 until the end of 2004. In this role, he helped define the future direction of XML and data access in the .NET Framework and within SQL Server 2005. Mark is now the program manager for the Web Services Enhancements (WSE) product, which enables developers to build advanced, secure, service-oriented applications within Visual Studio, based around the WS-* specifications. Fortunately, this still allows him to work with developers and the XML APIs in .NET, and to remain passionate about current and emerging XML technologies to integrate data across platforms--XML came, it saw, it integrated.Mark speaks regularly at conferences and can be contacted via his blog at http://blogs. msdn.com/mfussell.

User review
Very Good First Look
This book attempts to look at the evolving technology of ADO .NET version 2.0 that will ship with SQL Server 2005 and Visual Studio .NET 2005. It does a very good job of looking at the major technologies and the uses of each of them.

I am looking forward to the ability to use asynchronous database connections and Multiple Active Result Sets (MARS). I can already see where it would make my current applications more performant.

I am also looking forward to the ability to store XML in SQL Server 2005 and use the XPath query engine to be able to select out the parts of the XML that I need. With the XML capabilities built into ADO .NET 2.0 and SQL Server 2005 it will be much easier to work with XML data.

I have recommended this book to serveral people. I think it is a must read for consultants and others who need to stay on the leading edge of technology.

User review
Addison-Wesley does it again
With all of my rave reviews of this series, I probably sound like I work in their PR department, but seriously, I don't. Every single book in this series that I've read is just plain great. This book, as well as their ASP.NET 2.0 title are just more examples of the same killer material they are publishing.

The book splits itself about 60/40 ADO.NET 2.0 Per se and the XML. However, if you're familiar with ADO.NET, you'll know they are interdependent technologies in .NET (no, I'm not saying you can't use XML without ADO.NET but XML and ADO.NET are so intertwined in .NET,it's hard to talk about ADO without XML).

Anyway, there's little in the way of review for the way ADO.NET used to work, and Amen to that. This book is short and too the point and you don't need to undestand pervious versions of ADO.NET to understand what's going on. With that in mind, a long discussion of previous version would be a waste of space. Now, there's no doubt that this book emphasizes Yukon and SqlServer features of ADO.NET 2.0, but it's not in any way limited to that. The subject of Batch updates is very cool (I know I can't wait for 2.0 to be released) but it doesn't take a lot of explaining. MARS and ObjectSpaces get a lot more coverage, but those are the two coolest features that I've seen. Well, that's not entirely true, the bulk loading features and paging are pretty darnded cool too.

Then the book discusses Yukon and the only complaint I have here is that I can't get a copy of it! You'll need Whidbey to compile the examples, but I've found getting a copy of Yukon to be quite elusive so that is somewhat limiting. However, that's not the author's fault in any way. (However, if they want to include a copy of it with the next release of the book, it'd certainly be a nice touch).

After that it moves into the XML realm and it's very very cool. No, it doesn't walk you through creating an XML document. The focus is heavy on data extraction with XML, XPath, XQuery, XmlReader, XmlAdapter taking up the focus of the discussion. Trust me, you'll be dying to play with this stuff by the time you get through the first discussion on it.

All in all, it looks like ADO.NET 2.0 is a larger evolution from previous versions than ADO.NET was to ADO (although ADO.NET is a totally different technology than ADO). If you want to take advantage of these features, you're going to have some learning to do. However, all of the books examples are complete, concise and clear and most importantly, they all work. There's nothing worse than typos and broken code, but it's a lot worse when you are dealing with a technology this young.

Once again, another first rate job by A-W.

User review
Merging SQL Server and XML under .NET
At the simplest level, this book has two parts. The part on ADO.NET refers to further enhancements to accessing MS SQL Server on the .NET platform, as well as sundry bug fixes.

The other part concerns how .NET handles XML data management. Here Microsoft has put in a ton of work to handle the latest XML standards, including XML Schema, XPath and XQuery. The entire XML field has been growing rapidly and this book shows how Microsoft is keeping pace. Very reassuring.

Also, as one might expect, Microsoft has added custom enhancements to XML. There are two standard XML parsers, DOM and SAX, each with its well known advantages and disadvantages. With the SAX parser, you essentially add one of your routines to it as a listener for events you specify. Then you run SAX on an XML object. Via the listener, it pushes instances of those events to you. GUI building follows this approach. But some developers find this very awkward and unnatural. To answer this, Microsoft has come up with an `XMLReader` that reads XML objects and pull data into your code in a more intuitive way. Interesting, and this may be useful to some who are new to XML.

The book is more than just two disjoint halves. Basically, Microsoft is weaving the SQL access of ADO every more closely with XML, where the latter can be used as a data viewing language into the SQL. What about the impedance mismatch? Considerable effort has been expended to subsume this into low level details that more developers can ignore.

So for all these reasons, if you are already using .NET and SQL Server, you may want to check out these details more fully.