- ISBN13: 9780764584374
- Condition: NEW
- Notes:
Product Description
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(r) 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.
MySQL Cookbook, Paul DuBois, New Book | US $68.85 End Date: Tuesday Feb-28-2012 21:26:18 PST Buy It Now for only: US $68.85 Buy it now | Add to watch list |
I had hoped that working through this book would bring extra insight and new techniques. After all, I have been a database consultant for 15 years and designed, programed and implemented many large solutions.
I found that the book left much unsaid and detailed instructions non existant. I had problems with the download code. It appears to be tied up with VS team system, so if you are a home or small business who is unfamiliar with tem system then you may have problems.
I contacted Wiley Customer Support, but they just told me the code works and provided nothing helpful.
I will not be buying any more Wrox / Wiley books.
Amazon User Rating: 1 / 5
There are a number of great things about this book, from my perspective. For me, perhaps the best chapter was the one on the custom ADO.NET provider. Even if you do not want to create a custom provider (and honestly, I do not think I will), reading through that chapter helps explain how the various standard interfaces work.
In addition to covering ADO.NET 2.0 proper, the book covers specifically how you can use ADO.NET in very practical ways, interacting with SQL Server, as well as doing server side programming in SQL Server. Unlike one other reviewer, I appreciate the book covering these other areas. While the chapters on topics such as SQL Server server-side programming obviously do not cover all that a dedicated SQL Server book will, it covers most of what you need.
I do understand how the term “Professional” in the title might lead a reader to expect one thing or another, but before I buy a book, I tend to read through it and determine if the publisher’s idea of “Professional” matches my expectations.
Amazon User Rating: 5 / 5
This book has a lot of good information. I found myself skimming forward just a little but there was still lots of good info to make me want to keep reading. I wish there was sometimes more explanation of why the author feels a certain way but all and all this is book worth owning.
Amazon User Rating: 4 / 5
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.
Amazon User Rating: 2 / 5
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!
Amazon User Rating: 4 / 5