Beginning ASP.Net 3.5 Data Access with Linq, C# 2008, and ADO.NET

This book is a comprehensive introduction to building websites that use multiple data sources--not just databases. You'll learn how to build a relational database, use SQL or XML to communicate with it, and take full advantage of Microsoft's new LINQ (Language Integrated Query). You'll also learn about the latest ADO.NET and ASP.NET features in .NET 3.5. The author devotes plenty of space to mission-critical issues such as design, transactions, concurrency, exception handling, and optimization. He explains in detail how to work with SQL Server Express, Oracle Express, and MySQL Community Server, and highlights the differences between them. This comprehensive resource is packed with information about .NET 3.5 improvements and techniques for building database-driven websites. Every new idea is illustrated by practical code examples, with a real-world case study to tie everything together and bring it into focus. Learn to program databases in ASP.NET 3.5 and C# 2008, with detailed code examples throughout. Choose your preferred database: SQL Server Express, Oracle Express, or MySQL Community Server. Master LINQ, XML, concurrency, transactions, stored procedures, tiered architecture, and a host of other valuable topics. What you'll learn Building fully-featured, database-driven websites with ASP.NET 3.5 and C# 2008. How to manipulate data structures using C# classes -- real code -- instead of HTML pages. Storing, modifying, querying, and retrieving data in SQL or XML format. Using LINQ to handle in-memory collections, relational databases and XML data -- including queries that join SQL and XML. How to model and generate LINQ classes with the DLINQ Designer. Creating powerful, robust websites using professional techniques such as concurrency, tiered architecture, exception handling, transactions, and stored procedures. Who is this book for? This book is ideal for any C# developer who wants to learn about database programming with ASP.NET -- the most powerful, efficient, and flexible way of building data-driven websites on Windows.