Short description This book is designed for college students who take the database programming course in the Visual Studio.NET environment and want to learn both fundamental knowledge and practical techniques in designing and building commercial and industrial applications in Visual C#.NET. The book provides a detailed description about the practical considerations and applications in database programming with Visual C#.NET 2008 with authentic examples and detailed explanations. More importantly, a new writing style, combined with real examples, provides readers with a clear picture as how to handle the database programming issues in Visual C#.NET 2008 environment.
From the contents Preface.
Acknowledgment.
1 Introduction.
Outstanding Features of the Book.
Target Audience.
Topics Covered.
Organization of the Book and How to Use It.
How to Use the Source Code and Sample Databases.
Instructor and Customer Support.
Homework Solutions.
2 Introduction to Databases.
2.1 What Are Databases and Database Programs?
2.2 Develop a Database.
2.3 Sample Database.
2.4 Identifying Keys.
2.5 Defi ne Relationships.
2.6 ER Notation.
2.7 Data Normalization.
2.8 Database Components in Some Popular Databases.
2.9 Create Microsoft Access Sample Database.
2.10 Create Microsoft SQL Server 2005 Sample Database.
2.11 Create Oracle 10g XE Sample Database.
2.12 Chapter Summary.
Homework.
3 Introduction to ADO.NET.
3.1 ADO and ADO.NET.
3.2 Overview of ADO.NET 2.0.
3.3 Architecture of ADO.NET 2.0.
3.4 Components of ADO.NET 2.0.
3.5 Chapter Summary.
Homework.
4 Introduction to Language-Integrated Query (LINQ).
4.1 Overview of Language-Integrated Query.
4.2 Introduction to LINQ Query.
4.3 Architecture and Components of LINQ.
4.4 LINQ to Objects.
4.5 LINQ to DataSet.
4.6 LINQ to SQL.
4.7 LINQ to Entities.
4.8 LINQ to XML.
4.9 C# 3.0 Language Enhancement for LINQ.
4.10 Chapter Summary.
Homework.
5 Data Selection Query with Visual C#.NET.
PART I Data Query with Visual Studio Design Tools and Wizards.
