• Provides step-by-step coverage of everything you ever wanted to know about C# development in ADO.NET and classic ADO
• Covers relational databases, Active Directory (LDAP) access, Message Queuing, server-side processing (stored procedures, views, and triggers), and the SQLXML 2.0 SQL Server plug-in
• Discusses all developers need to get started with data access in C#, including the SQL Server .NET Data Provider, the OLE DB .NET Data Provider, and the ODBC .NET Data Provider, as well as older ADO technology

Database Programming with C# takes developers through all the data access aspects of Visual Studio .NET with example code in C#, including how to create the various database details, such as tables, constraints, projects, stored procedures, views, triggers, and more. Carsten Thomsen shows readers how to do this from within the Visual Studio .NET IDE, as well as programmatically where possible. Readers will build on example code from the beginning of the book that will wrap up in the final chapter. The example application is a complete user management system that includes SQL Server, Active Directory, and Message Queuing.

The example code includes how to connect to and manipulate data in MySQL 3.23.45 or later, Oracle 8i or later, Microsoft Access 2000 or later, and SQL Server. Readers connecting to SQL Server 2000 will find information on the SQLXML 2.0 plug-in for manipulating SQL Server data using XML from managed code or using HTTP. Exchange Server 2000 connection and data manipulation are also covered with original working code.

Database Programming with C# is the ultimate resource for developers who need to master database programming in C#.

Contents

• Chapter 1: A Lightning Quick Introduction to C#
• Chapter 2: Using Databases
• Chapter 3: Presenting ADO.NET
• Chapter 4: Presenting the IDE from a Database View Point
• Chapter 5: Exception Handling
• Chapter 6: Using Stored Procedures, Views and Triggers
• Chapter 7: Hierarchical Databases
• Chapter 8: Message Queuing
• Chapter 9: Data Wrappers
• Chapter 10: Data Bound Controls
• Chapter 11: UserMan