Database Programming with Visual Basic .NET / Edition 2
by Carsten ThomsenISBN-10: 1590590325
ISBN-13: 9781590590324
Pub. Date: 10/15/2002
Publisher: Apress
Overview
Database Programming with Visual Basic .NET, Second Edition can be used as a reference book, because of the many listing and tables in the appendices, but it's also a book intended for reading cover-to-cover. It will take you through all the data access aspects of Visual Studio .NET with example code in VB .NET, including how to create databases, tables, constraints, database projects, stored procedures, views, triggers, typed datasets, and more.
Carsten Thomsen does this from within the VS .NET IDE and programmatically where possible. Readers will also build upon the same example code from the beginning of the book until it wraps up in the very last chapter. The example application is a complete user management system that includes SQL Server, Active Directory, and Message Queuing.
Using the example code, readers can connect to SQL Server using any of the three .NET Data Providers: SQL Server .NET Data Provider, OLE DB .NET Data Provider, or ODBC .NET Data Provider. The example code also includes how to connect to and manipulate data in MySQL 3.23.49 or later, Oracle 9i or later, Microsoft Access 2000 or later, and SQL Server. For connecting to SQL Server 2000, readers will also find coverage of the SQLXML 3.0 plug-in for manipulating SQL Server data using XML from managed code or using HTTP. Exchange Server 2000 connection and data manipulation is also covered.
Author Bio:
Carsten Thomsen is a Microsoft MVP, recognition he received in August 1999. He lives in his native Denmark and currently holds the MCSE and MCSD certifications. Carsten has been programming in Visual Basic for almost 10 years, with a specialization in data access. However, with the advent of Visual Basic .NET and, more important, Visual Studio .NET, he has concentrated on two programming languages, C# and Visual Basic .NET-staying focused with regard to data access from these two programming languages.
Product Details
- ISBN-13:
- 9781590590324
- Publisher:
- Apress
- Publication date:
- 10/15/2002
- Series:
- .NET Developer Series
- Edition description:
- 2nd ed. 2003
- Pages:
- 984
- Product dimensions:
- 7.50(w) x 9.25(h) x 2.10(d)
Table of Contents
A table of contents is not available for this title.Customer Reviews
Average Review:
Most Helpful Customer Reviews
 |
|
|
I was searching for a DB book with VB .NET example code and there are lots of them. A friend recommended this one and I'm glad she did. There's so much information in this book; it's unbelievable. I skipped chapter 1, but chapter 2 was an excellent refresher, as the author states, and I can certainly use this chapter for later reference. I'm an experienced DB developer and I DO know about normal forms, but like many people I forget things here now and then, so this chapter is a very quick reference. Part II and III are excellent introductions to the two ADO.NET layers and after reading through them, I really understand the concepts of ADO.NET and especially the way it works with disconnected data access. These two parts with apendixes C and D are excellent as reference guides and I can recommend the book just for these chapters/appendixes. Wait, there's more: Stored Procedures, Views, Triggers, exception handling and much more. Truly a book for any serious VB/DB developer.
|
|
Okay the title is somewhat buyest as I happen to have been speeking with the author, and I find he´s a very nice guy. However, I don´t feel that I base my rating on my personal view of him, I simply like this book very much. The organization with ADO.NET split into (mostly) simple chapters in the first few parts, really makes it easy to learn from scratch, but even non-beginners should be able to pick something from this book as it gradually adds new material to the stuff you learn in the beginning. The reference appendixes are perfect, much better than the help that comes with VS .NET and I find myself using them frequently. Even the more special topics like SQLXML, Exchange server, and concurrency are very well explained starting at beginners level and the gradually adding more knowledge to the stack. This is a very good book!
|
|
I've been through a dozen of database books for VB .NET and no other book covers so much material and in such a detailed way. I really think this book with its reference appendixes stands out from the rest. I thoroughly enjoyed the database design refresher in chapter 2.
|
|
I skimmed through the first edition of this book and decided not to buy. This second edition however, is so much more and I am really pleased I bought it. I've read most chapters and I now find myself using it as a reference. Chapter 2 is an excellent intro into database design and chapters 5-12 (part 2 and 3) really explains the classes of ADO.NET in great detail. It's excellent. I think most chapters are of very good quality, but Chapter 22 is by far the best. Noweher else can you find such detailed coverage of SQLXML 3.0. Buy the book! The publisher most have mixed the TOC from the first edition with the second edition it seems as there are now 26 chapters and some appendixes.
|