Thomsen, Carsten Database Programming with C# (1590590104)
Database Programming with C# can be used as a reference book - thanks to its many listings and tables. It's really intended to be a book that any serious C# programmer who needs to do database programming should read cover-to-cover. It will take you through all the data access aspects of Visual Studio .NET with example code in C#. This includes how to create the various database items, such as databases, tables, constraints, database projects, stored procedures, views, triggers, and more from within the Visual Studio .NET IDE, but also programmatically. Readers will learn to build on the same example code from the beginning of the book until you wrap it up in the very last chapter. The example application is a complete user management system that includes SQL Server, Active Directory, and Message Queuing.