Ebook: Mastering C# Database Programming

Enter a New World of Database ProgrammingC# and ADO.NET facilitate the development of a new generation of database applications, including remote applications that run on the Web. Mastering C# Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes:Accessing a database using C# and ADO.NETUsing SQL to access a databaseUsing Visual Studio .NET to build applicationsCreating and modifying database tablesUnderstanding ADO.NET classesDesigning, building, and deploying Web applications that access a databaseDesigning, building, and deploying effective Web servicesUsing SQL Server's built-in XML capabilitiesWorking with a database in a disconnected mannerUsing advanced transaction controlsUsing Transact-SQL to create stored procedures and functions in a SQL Server database