C# programmers of every level need to learn about LINQ (Language-Integrated Query), Microsofts breakthrough technology for simplifying and unifying data access from any data source. With LINQ you can write more elegant and flexible code, not just to access databases and files, but also to manipulate data structures and XML.
LINQ for Visual C# 2005 is a short yet comprehensive guide to the major features of LINQ. It thoroughly covers LINQ to Objects, LINQ to SQL, LINQ to DataSet, and LINQ to XML. It also details significant enhancements to the next versions of C#, .NET, and ADO.NET. The book also includes plenty of working examples to demonstrate LINQ in action. There is no better source than this book for getting a head start on the future of these technologies.
Over the past 20 years object-oriented programming languages have evolved to become the premier tools for enterprise application development. They've been augmented by frameworks, APIs, and rapid application-development tools. Yet what's been missing is a way to intimately tie object-oriented programs to relational databases (and other data that doesn't exist as objects). The object paradigm is conceptually different from the relational one and this creates significant impedance between the objects programs use and the tables where data resides. ADO.NET provides a convenient interface to relational data, but not an objectoriented one.