Learn ASP.NET MVC, ASP.NET Core, and Design Patterns through our online training programs. Courses conducted by Bipin Joshi on weekends. Read more details here.

Murach's ADO.NET 2.0 database programming with VB 2005

Book Summary

  • Title: Murach's ADO.NET 2.0 database programming with VB 2005
  • Author: Anne Boehm
  • Level: Beginner to Intermediate
  • Publisher: Murach
  • Pages: 764
  • Rating: 3.5 of 5

 

Review

Many developers earn their bread and butter by writing database driven applications. That is why mastering ADO.NET features is a key skill set for any .NET developer. Murach's ADO.NET 2.0 gives a good start in database programming to any beginner. It will serve as an easy to use collection of "how tos" as well as a reference.

The book consists of twenty chapters spread over five sections. The first section introduces you with the database programming in general and ADO.NET. It consists of five chapters. Chapter 1 and 2 offer basic introduction to database programming concepts and ADO.NET. Chapter 3 talks about creating and consuming data sources. It uses windows forms applications to teach the concepts. It also covers exception handling and DataSet designer. Chapter 4 deals with one of the favorite topic of beginners - data bound controls and parameterized queries. It also develops a simple invoice maintenance system to illustrate the concepts. Chapter 5 contains detailed drill down on DataSet designer and query builder. The invoice entry application is then developed to illustrate the techniques learned.

The second section consists of five chapters and covers 3-layer application development. Chapter 6 covers common ADO.NET objects such as connection, command and data reader. Chapter 7 deals with stored procedures. Chapter 8 covers another important topic - database transactions. A typical payment transfer application shows the concepts in action. Chapter 9 covers object data sources to work with 3 layer systems. A payment entry application embosses the concepts covered in the mind of the reader. The same application is extended further in Chapter 10 giving reader a complete picture of the working of ADO.NET.

Section 3 covers ADO.NET in relation to ASP.NET. Chapter 11 discusses SQL data source control and many of its features. Chapter 12 and 13 cover GridView and DetailsView controls. Finally Chapter 14 dissects object data source control.

Section 4 deals mainly with DataSet features and their use in Windows based applications. Chapter 15 covers typed DataSets and table adapters. Chapter 16 deals with untyped DataSets and data adapters. DataViews and relationships between tables is the topic of Chapter 17.

Section 5 is bonus section and covers several miscellaneous topics. Chapter 18 teaches you to work with XML data and XML features of SQL Server 2005. Chapter 19 focuses on using Server Explorer of Visual Studio and finally Chapter 20 discusses Crystal Reports and Crystal Report Viewer control.

In nutshell, if you are a beginner looking for a good start on ADO.NET 2.0 using VB.NET as the language then this book can certainly help you. After mastering the techniques covered in this book you will get a solid foundation for advanced topics in ADO.NET.




Bipin Joshi is a software consultant, trainer, author and a yogi having 21+ years of experience in software development. He conducts online courses in ASP.NET MVC / Core, jQuery, AngularJS, and Design Patterns. He is a published author and has authored or co-authored books for Apress and Wrox press. Having embraced Yoga way of life he also teaches Ajapa Meditation to interested individuals. To know more about him click here.

Get connected : Twitter  Facebook  Google+  LinkedIn

Posted On : 07 Oct 2007



Tags : ADO.NET Data Access SQL Server VB.NET Visual Studio