Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional) [Paperback]

Damien Foggon (Author)

Book Description

Publication Date: March 28, 2006 | ISBN-10: 1590595777 | ISBN-13: 978-1590595770 | Edition: 2nd ed.

This book picks up where Beginning ASP.NET 2.0: From Novice to Professional leaves off, focusing on database programming with ASP.NET. Since ASP.NET developers need to access databases quickly and efficiently, this book teaches the best practices and methods to help developers achieve professional ASP.NET and database solutions.

Beginning ASP.NET 2.0 Databases: From Novice to Professional is a comprehensive introduction on how you can connect a Web site to many different data sources — not just databases — and use the data to create dynamic page content. They also show how to build a relational database, use SQL to communicate with it, and understand how they differ from each other. You’ll also learn about the new features of ADO.NET and ASP.NET in .NET 2.0

The authors cover mission-critical issues, such as design, transactions, error handling, optimization, and scalability. They write about SQL Server, Jet, and MySQL databases, highlighting their differences. Finally, they concluded with a handy case study that brings together all of the things you’ve learned.

Editorial Reviews

About the Author

Damien Foggon is technical director and lead developer for Thing-E Ltd., a company specializing in the development of dynamic web solutions for the education sector. He was responsible for the development of several ASP and ColdFusion websites, and he's now in the process of moving most of them to ASP.NET. Before coauthoring .NET XML Web Services, Damien was a regular technical reviewer for numerous .NET books. After several false starts, he's busy assembling his personal site.

Dan Maharry is a writer and developer based in Birmingham, United Kingdom, where he lives with his fiancée, Jane. He has worked on more than forty technical books since 1997 and co-written ten books including Beginning ASP.NET 1.1 with Visual C# .NET 2003 ( Wrox ,ISBN: 0-76455-708-4) and Beginning ASP.NET Databases 1.1 : From Novice to Professional ( Apress, ISBN: 1-59059-369-3) When not writing, he works as a developer and manager for the .Coop Domain Registry. Outside of work, Dan is an avid filmmaker, and recently blew up a car in the name of cinema. He'd like to do it again

Product Details

• Paperback: 656 pages
• Publisher: Apress; 2nd ed. edition (March 28, 2006)
• Language: English
• ISBN-10: 1590595777
• ISBN-13: 978-1590595770
• Product Dimensions: 9.2 x 7.3 x 1.6 inches
• Shipping Weight: 2.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #382,669 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

36 of 39 people found the following review helpful:

5.0 out of 5 stars Become an ASP.NET Database Guru, June 21, 2006

By 

S2 - Candle Trader (Portland, OR) - See all my reviews

This review is from: Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional) (Paperback)

Almost every book with ASP.NET 2.0 in the title will tell you something about the Grid View, Detail View, Form View, SQLDatasource and the SQL 'Select' statement; this one will too. While the other books provide a rudimentary overview of these topics then move on, "Begining ASP.NET 2.0 Databases: From Novice to Professional" takes you way beyond the SQLDatasource and the 'Select' statement, delving deep into ADO.NET.

Just as bread & butter go together ASP.NET and databases go together; and there is a lot more to the database side of the equation than is brought out in most ASP.NET books, which tend to limit themselves to the use of the controls, getting into databases only enough to have something to show in the controls. with this book it is the other way around; the reason for the controls is to display and maninpulate data in a database, and there are several ways to access and manipulate databases with ADO.NET besides the SQLDatasource. Along the way you will learn to use the controls with all the different data access formats and how to use the controls and their events to manipulate the data, which is what it's really all about.

If DataReader, Command Object, DataSet, OLEDBDatasource and ODBCDatasource are not familiar terms to you, and you want to develop ASP.NET web sites you need this book. If you don't know when not to use the SQLDatasource (there are some definite situations when it won't work), or don't know how to create a server side data cache and why you would want to, you need this book.

The book is easy to read and has numerous small exercises titled "Try It Out", after each exercise is a "How It Works" section where the code in the previous exercise is explained, line by line in most cases. Not only does Damien take you through DataReader, Datasets and Commands he also covers stored procedures, which you will want to use rather than queries in code shown in most of the other books.

While the book primarily uses SQL Server 2005, MYSQL 5.0 is also covered at the same time, everything from installing and configuring to using with stored procedures, parameters and transactions.

If you want to build ASP.NET web sites you will work with databases, if you are not intimately familiar with ADO.NET this book should be on your bookshelf readily available.

6 of 7 people found the following review helpful:

4.0 out of 5 stars Good database coverage, April 28, 2008

By 

CESA Klages (Eau Claire, Wisconsin United States) - See all my reviews
(REAL NAME)   

This review is from: Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional) (Paperback)

This book does a good job explaining how to work with databases. The one thing I didn't realize is the only language used for examples is C#. It would be nice if VB examples were also included.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Best book for ASP.Net Databases, November 25, 2009

By 

Dean Lee (Seattle, WA) - See all my reviews

Amazon Verified Purchase

This review is from: Beginning ASP.NET 2.0 Databases: From Novice to Professional (Beginning: From Novice to Professional) (Paperback)

I bought a few ASP.Net books (all rated 4+ stars by the reviewers) for my recent ASP.Net project. This one is the best. The book has comprehensive but coherent coverage of ASP.Net. You not only learn different ways to access databases and retrieve data, but also learn how to use controls and different ways to bind them to the data sources. Most importanly, you learn which way to go in different circumstances. I highly appreciate the combination of "Try It Out" and "How It Works", which makes the book easy to read and easy to understand. I enjoyed reading the book and learned much more than I expected. It helped me a lot in my ASP.Net project.