- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
Other titles in the Programmer to Programmer series:
Beginning C# 2005 Databasesby Karli Watson
Synopses & Reviews
Beginning C# 2005 Databases teaches C# developers the concepts and skills necessary to write C# database applications. This book covers how to make use of databases with C#. It covers the basics of databases, database design, and SQL programming, and it shows programmers how to use C# and ADO.NET to manipulate data in databases. It looks at both visual techniques and data binding and programmatic data access. This is a beginning title, so the Visual Studio 2005 Express Edition tools will be used for both C# development and database hosting. This book is a supplementary text to Beginning Visual C# 2005 and Professional C# 2005, and assumes some knowledge of C# programming.
Readers learn how to how to use queries, views and stored procedures to efficiently access and manipulate data from their applications. The author provides examples, tips, real world scenarios, and instruction on accessing data from Windows applications, ASP.Net applications as well as Web Services. ADO.Net will be covered thoroughly so that the reader may get a firm grasp on this important data access technology in .Net. Hands on examples and try it out exercises will be used to help the reader put the topics they read about into practice. This book will not be used so much as a reference but as a teaching tool on building database applications using C#.
Specific Topics Covered:
Database and the Internet
Views and Stored Procedures
Custom Data Binding
Transactions and Concurrency
Working with Disconnected Data
Data Binding Quick Ref
Book News Annotation:
This guide uses a tutorial format to teach beginning C# 2005 developers how to create C# applications that can access databases. Coverage includes both visual techniques and data binding as well as programmatic database access. In addition to demonstrating key techniques, many of the numerous examples provide tips and tricks that may be adapted for other applications. It is assumed that the reader has a basic understanding of .NET development with C#. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)
Offering readers the solid fundamentals of database concepts and data manipulation with C#, this book explains database management system (DBMS) types and features and covers SQL, ASP.NET applications, web services, and transaction management techniques, including how to deal with concurrency issues.
Serving as an ideal teaching tool on building database applications using C#, the book also looks at both visual techniques and data binding and programmatic data access. Real-world examples, new database techniques, and try-it-out exercises all contribute to helping you put your reading about database applications into practice.
What you will learn from this book
Who this book is for
This book is for beginning C# 2005 developers who already have some experience with C# 2005 developing Windows® and ASP.NET applications.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
About the Author
Karli Watson is a freelance writer, developer, and editor and also the technical director of 3form Ltd. (www.3form.net). He started out with the intention of becoming a world-famous nanotechnologist, so perhaps one day you might recognize his name as he receives a Nobel Prize. For now, however, Karli’s main academic interest is the .NET Framework and all the boxes of tricks it contains. Karli is also a snowboarding enthusiast, loves cooking, spends far too much time playing Anarchy Online, and wishes he had a cat. As yet, nobody has seen fit to publish Karli’s first novel, but the rejection letters make an attractive pile. If he ever puts anything up there, you can visit Karli online at www.karliwatson.com.
Table of Contents
Chapter 1: Database Fundamentals.
What Is a Database?
Additional Features of RDBMSes.
What RDBMSes Are Available?
How Do You Use a Database?
Chapter 2: Databases and C#.
Database Access in C#.
Chapter 3: Viewing Data.
Creating Data Sources.
Binding to Data Sources.
Chapter 4: Modifying Data.
Data Modification Prerequisites.
How to Avoid Data Being Overwritten.
Modifying Data from Data-Bound Controls.
Chapter 5: Databases and the Internet.
Web versus Windows Applications.
Data Binding in ASP.NET.
ASP.NET Data Connections.
ASP.NET Data Source Controls.
ASP.NET Data Display Control Summary.
An Introduction to Templates.
Viewing and Editing Data in List Views.
Viewing and Editing Data in Detail Views.
Chapter 6: Accessing Databases Programmatically.
Data Reader Objects.
Data Adapter Objects.
Chapter 7: Views and Stored Procedures.
Chapter 8: Custom Data Objects.
Custom Data Objects.
Chapter 9: Transactions and Concurrency.
Chapter 10: Working with Disconnected Data.
Exposing Web Service Data.
Consuming Web Service Data.
Caching Web Service Data.
Chapter 11: SQL Server CLR Integration.
Overview of CLR Integration.
Common Features of CLR Integrated Code.
Managed Functions and Stored Procedures.
Appendix A: Installation.
Appendix B: Database Installation.
Appendix C: Answers to Exercises.
What Our Readers Are Saying
Average customer rating based on 2 comments: