Database Programming with C#

Carsten Thomsen is a Microsoft "Most Valuable Professional," a recognition he received in August 1999. He lives in his native Denmark and currently holds the MCSE, MCAD, and MCSD certifications. Carsten has been programming in Visual Basic for more than 12 years, and he specializes in data access, object-oriented analysis and design, and enterprise development. These days, Carsten is primarily focused on development with Visual Studio .NET, using MSF, UML, Visual Basic .NET, and C#, but he also enjoys working with Microsoft SharePoint Portal Server 2003, Microsoft Content Management Server 2002, and Microsoft BizTalk Server 2004. Carsten now works as a .NET consultant mainly in London and Dublin, but he also does the odd .NET training job.

From the reviews: "Database programming in Microsoft's .Net approach is accomplished via ADO.Net. ... So in this book we might expect to find a detailed description of ADO.Net with C# examples. The author delivers on the expectation, covering ADO.Net in two of the 11 chapters. ... it can be used as a reference text. ... absolute beginners will find an abundance of useful information. ... most of the content will more than satisfy beginners." (Daniel Moth, The Computer Bulletin, November, 2002) "Database Programming with C# by Carsten Thomsen, is for people who have already done database programming in Visual Basic or Java and also know the basics of C# programming. ... The appendix, showing connectivity to SQL Server 2000 using XML, is particularly useful. The coverage of unusual topics such as message queues and hierarchical databases demonstrates Thomsen's mastery over .NET, making this book a must read, particularly for database programmers with basic knowledge of C#." (Alokesh Bhattacharyya, Computer Today, July, 2002)

• One Getting Started.- 1 A Lightning-Quick Introduction to C#.- Two Database Programming.- 2 Using Databases.- 3A Presenting ADO.NET: The Connected Layer.- 3B Presenting ADO.NET: The Disconnected Layer.- 4 Presenting the IDE from a Database Viewpoint.- 5 Exception Handling.- 6 Using Stored Procedures, Views, and Triggers.- 7 Hierarchical Databases.- 8 Message Queues.- 9 Data Wrappers.- 10 Data-Bound Controls.- Three Example Applications.- 11 UserMan.- Appendix A Using XML with SQL Server 2000.- Using SQLXML 2.0.- Summary.