Murach’s ADO.NET 4 Database Programming with C# 2010, 4th Edition

Now in its 4th Edition, this book shows C# developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You’ll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications…the route the professionals take for flexibility and control
• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
• work with XML-specific features of ADO.NET to read, write, and manipulate XML data in your applications
• use Visual Studio’s Report Designer and ReportViewer control to create and display reports in both Windows and web applications
• use LINQ to SQL instead of standard SQL so you can query databases using C# constructs
• create Entity Data Models so you can use LINQ to Entities to work with business objects, like invoices, while the Entity Framework handles the database details

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach’s distinctive “paired-pages” format…where each skill is presented with examples and advice in a single 2-page spread…is great for both targeted learning and reference.

Table of Contents

Section 1. An introduction to ADO.NET programming
Chapter 1. An introduction to database programming
Chapter 2. An introduction to ADO.NET 4

Section 2: How to use data sources and datasets for Rapid Application Development
Chapter 3. How to work with data sources and datasets
Chapter 4. How to work with bound controls and parameterized queries
Chapter 5. How to use the Dataset Designer

Section 3: Three-layer Windows Forms applications
Chapter 6. How to work with connections, commands, and data readers
Chapter 7. How to work with parameters and stored procedures
Chapter 8. How to work with transactions
Chapter 9. How to work with object data sources
Chapter 10. A complete Payable Entry application

Section 4: How to use ADO.NET with web applications
Chapter 11. How to use SQL data sources
Chapter 12. How to use the GridView control
Chapter 13. How to use the DetailsView control
Chapter 14. How to use object data sources

Section 5: Advanced database programming skills
Chapter 15. How to work with XML data
Chapter 16. How to use the reporting features of Visual Studio
Chapter 17. How to use LINQ
Chapter 18. How to use the Entity Framework