Programming Books C Java PHP Python Learn more Browse Programming Books
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL Paperback – December 5, 2005

Amazon Price New from Used from
"Please retry"
$4.66 $0.01

Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 648 pages
  • Publisher: Wrox; 1 edition (December 5, 2005)
  • Language: English
  • ISBN-10: 0764584375
  • ISBN-13: 978-0764584374
  • Product Dimensions: 9.1 x 7.5 x 1.4 inches
  • Shipping Weight: 2.2 pounds
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #2,654,919 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time—enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book

  • The basics of creating a connection, executing a query, and returning a result
  • Best uses for Oracle in the ADO.NET Framework
  • The many new features that are available for XML
  • How to use the full text search capabilities of Microsoft® SQL Server 2005
  • Methods for retrieving data and presenting it in various ways
  • Why MySQL is a viable option for data storage

Who this book is for

This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Wallace B. McClure graduated from the Georgia Institute of Technology in 1990 with a bachelor of science degree in electrical engineering. He continued his education there, receiving a master’s degree in the same field in 1991. Since that time, he has done consulting and development for such companies as Coca-Cola, Bechtel National, Magnatron, and Lucent Technologies, among others. Products and services have included work with ASP, ADO, XML, and SQL Server, as well as numerous applications in the Microsoft .NET Framework. Wally McClure specializes in building applications that have large numbers of users and large amounts of data. He is a Microsoft MVP and an ASPInsider, and a partner in Scalable Development, Inc. You can read Wally’s blog at

Gregory A. Beamer is a solutions architect specializing in Microsoft Internet technologies. Greg got involved in programming in the early 1990s with Visual Basic 3 and has stayed on the leading edge of Microsoft Internet technologies since the Denali beta (ASP 1.0). Greg first worked with .NET with the PDC 2000 beta and has been on both the SQL Server 2005 and .NET 2.0 betas since spring 2003. When Greg is not working, he spends his time with his wife, Tiffany, and their four daughters, Rebecca, Emily, Annabelle, and Miranda.

John J. Croft IV graduated from the Georgia Institute of Technology in 1991, receiving a bachelor’s degree in mechanical engineering. He then spent five years consulting for large companies, including Coca-Cola, BellSouth, and MCI. Work at these companies primarily involved C and C++ programming and object-oriented systems analysis. His various clients have included both Fortune 100s and small startup companies. Their problems have ranged drastically, from large databases and executive information systems to lithotripter control and satellite telemetry. Croft has completed projects with Java, XML, and, recently, C# and .NET applications. He is a partner in Scalable Development, Inc.

J. Ambrose Little is the editor-in-chief of the ASPAlliance, an ASPInsider, and a Microsoft ASP.NET MVP who currently works as a Web architect for a large credit union in Tampa, Florida. Previously, he worked as a consultant at Verizon, creating XMLWeb Services and middle-tier components, and for BOK Financial’s Web Services department creating ASP.NET applications for their intranet. His pre-.NET programming experience consists mostly of developing Web applications using ASP and VB COM/DCOM for several years. He has a bachelor’s degree in medieval European history, which remains an interest. Apart from developing software, he enjoys movies, reading, writing, foosball, chess, tennis, badminton, and spending time with his wonderful family.

Bill Ryan currently works as a senior software developer for TiBA Solutions in Greenville, SC. He is also a Windows Embedded MVP, has served on Macromedia’s Flash Advisory Board, and helps run two popular .NET Focused Web sites ( and and his blog After earning his master’s degree in business administration, Bill began work as a statistical analyst, but quickly realized that his true love was programming. He has worked in multiple industries, including financial services/securities, manufacturing, health care, pharmaceuticals, and, currently, consulting. Bill is a frequent speaker at user’s group meetings, has spoken at multiple Microsoft Code Camps, and has hosted multiple MSDN Webcasts. Although technologically related things consume most of his time, Bill’s other interests include cult films, economics, Freemasonry, cuckoo clocks, and, most important, his girlfriend, Kim, and her daughter, Sarah.

Phil Winstanley is a Web applications developer working for Portfolio Europe, located in Manchester, England. He has been involved with ASP.NET since its inception, and has developed a deep understanding of the platform. As a Microsoft MVP (Most Valuable Professional), member of the ASPInsiders, co-owner of Microsoft Web Developers UK, and the North West England Regional Director for the .NET Exchange, Phil is deeply embedded in the development community and works closely with the Web Platforms team at Microsoft, regularly visiting the developers in Redmond, Washington.

David Yack is the president of Colorado Technology Consultants, Inc. He is a hands-on technology consultant with solid management experience in privately held and Fortune 500 companies and has over 15 years of experience in the IT industry. David is currently responsible for leading Colorado Technology Consultants’ focus on Microsoft .NET technologies. David is an active participant in the Microsoft development community, ranging from the Denver .NET user group to Microsoft’s Public Communities, such as and David is the leader of the South Colorado .NET user group. David is recognized by Microsoft as a .NET MVP (Most Valuable Professional).

Jeremy Zongker is a software development manager who works primarily on data-driven ASP.NET applications with Microsoft SQL Server databases. He is a Microsoft Certified Solutions Developer for .NET and a 2004 MVP for ASP.NET. Jeremy is the founder and senior developer for Trilitech, LLC, a Broken Arrow, Oklahoma, software development company.

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.4 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

7 of 8 people found the following review helpful By D. Nicholson on January 16, 2007
Format: Paperback
I have 16 years experience as an adjunct instructor at a community college. I have a BS in Engineering and I'm 3 credits away from my Master's in Comp Sci.

I'm taking time from my class prep to write this review...

I have been assigned to teach a Visual Basic programming class with this book. Had I been given the opportunity to read the text beforehand, I would have fought hard to use some other book. The example code is formatted so poorly that I am embarassed to use it in class. Some of the example code in the book doesn't even match what's available for download on the WROX web site. The QC staff at WROX should be reassigned. I've QC'd many programming textbooks myself and I can see that this stinker was rushed to print without enough editing.

Don't be fooled by the title. The majority of the examples are SQL Server-specific. OK, Visual Studio has a SQL Server bent, given that both are Microsoft Products. That's no secret. However, if the title of the book references Oracle and MySQL, then all the examples should also. If a particular paradigm can only be implemented in SQL Server, then the authors have a responsibility to provide work-arounds for the other DBMS's that are listed on the cover of the book. Arrrgh.

Chapter 1 covers the History of Data Access. That doesn't fit with the remainder of the book. Part of chapter 2 covers normalization, also not a good fit with the remainder of the book. The authors even admit that the book is aimed at software developers who have prior knowledge of ADO .Net and SQL Server. That implies prior knowledge of normalization and database design.

Recently I was at the bookstore with my 11 year-old. I was agonizing over which ASP .
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 8 people found the following review helpful By August Wind on February 3, 2006
Format: Paperback
I was really looking forward to this book, for both ASP.Net and WinForms development, since I really thought that's what the book was really about. Boy was I surprised. if that was all it had, I'd probably be very happy. However - that was just the tip of the iceberg! It has quite a wide focus, so, in some cases, it was kind of dificult to know where the book is going.

However, The reader is somewhat warned right off the bat, that the book focuses mainly on the new features of ADO.Net 2.0, so prior knowledge of ADO.Net is expected, but I believe there is still a lot of text that covers a lot of the basics - just without a hand-held experience.

For those so inclined, there's quite a bit of information concerning subjects like usinc CLR objects, TSQL Enhancements, Notification Services, Service Broker and Reporting Services, though it's definitely not JUST about SQL Server. There is quite a bit on the popular open source databases like MySQL and PostgreSQL, along with a chapter on Oracle, just for good measure.

Many times, on different forums, I find questions concerning how to create a Database/table/etc, in code. Professional ADO.Net 2 has this plus a whole lot more about SQL Server server-side programming

Going into the book, I knew there were quite a few new features of ADO.Net, but I really had no idea concerning the extent of new features. This book contains 584 pages of great information. Though what I'd consider a bit wordy, at times, I'll definitely keep this book around.

If all you do is ASP.Net web page development, maybe this isn't the book for you - but if you do a lot more and really like 'nuts and bolts', and widening your experience, I think it's a go!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
If you are like me, you struggle every time Microsoft changes ADO. We have to rely on "experts" and their books to help us through the ADO direction of year. Unfortunately, I would not use "ADO.Net 2 - Programming with SQL Server 2005, Oracle and MySQL" as one of them. After a slow start with database fundamentals not related to .Net, the book seems to start in the right direction and then quickly derails. The authors make a serious point about how ADO.Net 2 is suppose to help us develop against any database system, but then spends the rest of the pages bypassing this ability without informing the reader. So not surprising, the examples are confusing; not database agnostic, disconnected, abstracted and difficult to follow. Nearly all the example code only works for SQL Server 2005. The book attempts to recover with specific chapters for Oracle and MySQL, but is thin and short on examples.

I found something interesting from each chapter, but I personally would rather have just one reference book on each subject. With this book, you might end up needed additional references.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
Its explains ADO.NET for those of us versed a little bit with ADO.NET already.
If I were a beginner completely of ADO.NET, I wouldn't get this book.

But it was exactly what I was looking for, a more exhaustive reference of ADO.NET and a lot of learning thrown in.
The only issue I have is that it is written for VB.NET and I use C#, but even with that, because I have been looking for so long for the right ADO.NET book, I'm giving it a 5!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images