Beginning C# 2005 Databases

by Karli Watson

• ISBN13: 9780470044063
• ISBN10: 0470044063
• Format: Paperback
• Copyright: 2006-10-01
• Publisher: Wrox

Summary

Providing beginners with the basics of databases, database design, and SQL programming, this book shows novice programmers how to use C# and ADO.NET to manipulate data in databases Includes hands-on examples, helpful tips, and real-world scenarios on accessing data from Windows applications, ASP.NET applications, and Web Services The SQL provider for accessing SQL Server databases, ADO.NET, and the new .NET 2.0 features Covers the fundamentals of accessing and manipulating data while giving a solid understanding of relational database design Topics covered include modifying data, custom data binding, working with disconnected data, and much more

Author Biography

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

Acknowledgements	xi
Introduction	xix
Database Fundamentals	1	(34)
What Is a Database?	2	(6)
Relational Database Management Systems	3	(5)
Object Oriented Database Management Systems	8	(1)
Additional Features of RDBMSes	8	(7)
Joins	9	(1)
Functions	9	(1)
Views	9	(1)
Stored Procedures	10	(1)
Triggers	10	(1)
E-mail	10	(1)
Indexes	11	(1)
Security	11	(1)
Concurrency Control	12	(1)
Transactions	13	(1)
Remote Access	13	(1)
Backups	14	(1)
Mirroring and Partitioning	14	(1)
Management Tools	14	(1)
What RDBMSes Are Available?	15	(2)
MySQL and PostgreSQL	15	(1)
DB2, Oracle, and SQL Server	16	(1)
SQL Server 2005 Express Edition	16	(1)
How Do You Use a Database?	17	(16)
A SQL Primer	18	(12)
XML	30	(3)
Summary	33	(1)
Exercises	34	(1)
Databases and C#	35	(34)
Database Access in C#	36	(11)
ADO.NET	36	(10)
Data Binding	46	(1)
Visual Tools	47	(4)
Express Products	47	(3)
SQL Server Management Studio Express	50	(1)
Examples	51	(14)
Case Study Introduction	65	(2)
Summary	67	(1)
Exercises	68	(1)
Viewing Data	69	(44)
Creating Data Sources	70	(20)
Automatic Data Source Configuration	70	(5)
Manual Data Source Configuration	75	(12)
Advanced Data Source Configuration	87	(3)
Binding to Data Sources	90	(20)
The BindingSource Control	91	(3)
Binding to List Controls	94	(1)
Binding to DataGridView Controls	95	(7)
The BindingNavigator Control	102	(1)
Adding a Navigable DataGridView in a Single Step	103	(1)
Binding to Detail Views	104	(3)
Filtering Data	107	(3)
Summary	110	(1)
Exercises	111	(2)
Modifying Data	113	(36)
Data Modification Prerequisites	113	(4)
Database Security	114	(1)
Database Views	115	(1)
Application Data Sources	116	(1)
How to Avoid Data Being Overwritten	117	(2)
Modifying Data from Data-Bound Controls	119	(27)
Adding Rows with GUID Primary Keys	125	(1)
How BindingNavigator Saves Data	125	(1)
Canceling Updates	125	(1)
Updating Data from Detail Views	126	(4)
Updating Multiple Tables	130	(11)
Updating Long Text Data for DataGridView Displays	141	(4)
Saving Data When the Application Closes	145	(1)
Summary	146	(1)
Exercises	147	(2)
Databases and the Internet	149	(44)
Web versus Windows Applications	150	(1)
Data Binding in ASP.NET	151	(1)
ASP.NET Data Connections	152	(5)
Local Database File Connections	153	(1)
Remote Connections	153	(4)
ASP.NET Data Source Controls	157	(6)
Data Source Configuration	158	(5)
Additional Data Source Control Functionality	163	(1)
ASP.NET Data Display Control Summary	163	(4)
GridView	164	(1)
DataList	164	(1)
Repeater	165	(1)
FormView	166	(1)
DetailsView	166	(1)
An Introduction to Templates	167	(3)
Viewing and Editing Data in List Views	170	(14)
Viewing Data	170	(4)
Additional Configuration	174	(2)
Editing Data	176	(8)
Viewing and Editing Data in Detail Views	184	(3)
Master/Detail Views	187	(3)
Summary	190	(1)
Exercises	191	(2)
Accessing Databases Programmatically	193	(48)
Database Connections	194	(3)
Creating Connections	194	(2)
Connection State	196	(1)
Connection Pooling	197	(1)
Database Commands	197	(8)
Creating Commands	197	(1)
Command Types	198	(1)
Command Execution Methods	198	(2)
Parameterized Commands	200	(1)
Protecting Against SQL Injection	201	(4)
Data Reader Objects	205	(7)
Creating Data Reader Objects	205	(1)
Reading Data	206	(4)
Connections for Data Reader Objects	210	(2)
Data Adapter Objects	212	(14)
Configuring Data Adapters	213	(5)
Extracting Database Data	218	(1)
Modifying Database Data	219	(1)
Customizing Data Adapter Behavior	220	(6)
DataSet Objects	226	(13)
Populating DataSet objects	226	(2)
Defining and Using Table Relationships	228	(4)
Typed DataSet Classes	232	(7)
Summary	239	(1)
Exercises	240	(1)
Views and Stored Procedures	241	(50)
Database Views	242	(14)
Creating Views	243	(11)
Updating Data Through Views	254	(2)
Stored Procedures	256	(33)
Creating Stored Procedures	258	(6)
Using Stored Procedures	264	(7)
Updating Data Through Stored Procedures	271	(1)
Conditional Logic and Looping	272	(4)
Cursors	276	(13)
Summary	289	(1)
Exercises	290	(1)
Custom Data Objects	291	(44)
Custom Data Objects	291	(29)
n-Tier Application Design Primer	293	(1)
Passing Data Reader Objects	294	(4)
Using Existing .NET Classes	298	(5)
Basic Data-Aware Class Design	303	(1)
DataAwareObjects Class Library	304	(16)
Binding to Object Data	320	(12)
Windows Applications	320	(3)
Web Applications	323	(9)
Summary	332	(1)
Exercises	333	(2)
Transactions and Concurrency	335	(40)
Concurrency	336	(22)
Last in Wins	336	(3)
Optimistic Concurrency Management in ADO.NET	339	(7)
Concurrency Violations in Client Applications	346	(7)
Resolving Concurrency Violations	353	(5)
Transactions	358	(15)
SQL Transactions	359	(4)
.NET Transactions	363	(10)
Summary	373	(1)
Exercises	374	(1)
Working with Disconnected Data	375	(42)
Exposing Web Service Data	376	(11)
Web Service Primer	376	(7)
Exposing Database Data	383	(4)
Consuming Web Service Data	387	(13)
Caching Web Service Data	400	(14)
Web Method Output Caching	401	(1)
Caching Data in Application State	402	(2)
Caching Data in the Application Cache	404	(10)
Summary	414	(1)
Exercises	415	(2)
SQL Server CLR Integration	417	(40)
Overview of CLR Integration	418	(4)
Enabling CLR Integration	419	(1)
Adding Assemblies to SQL Server	420	(2)
Requirements of CLR Integration Code	422	(1)
Registering CLR Code	422	(1)
Common Features of CLR Integrated Code	422	(4)
Code Structure	423	(1)
Data Access	423	(1)
Call Context	424	(1)
SqlPipe	424	(2)
Managed Functions and Stored Procedures	426	(29)
Scalar Functions	426	(6)
Table-Valued Functions	432	(5)
Aggregate Functions	437	(8)
Stored Procedures	445	(10)
Summary	455	(1)
Exercises	456	(1)
Appendix A: Installation	457	(10)
Appendix B: Database Installation	467	(6)
Appendix C: Answers to Exercises	473	(10)
Index	483