Synopses & Reviews
Designed in the highly regarded O'Reilly Cookbook format, ADO.NET Cookbook is strikingly different from other books on the subject. It isn't bogged down with pages of didactic theory. The ADO.NET Cookbook focuses exclusively on providing developers with easy-to-find coding solutions to real problems.
ADO.NET Cookbook is a comprehensive collection of over 150 solutions and best practices for everyday dilemmas. For each problem addressed in the book, there's a solution--a short, focused piece of code that programmers can insert directly into their applications.
And ADO.NET Cookbook is more than just a handy compilation of cut-and-paste C# and VB.NET code. ADO.NET Cookbook offers clear explanations of how and why the code works, warns of potential pitfalls, and directs you to sources of additional information, so you can learn to adapt the problem-solving techniques to different situations. This is a painless way for developers who prefer to learn by doing to expand their skills and productivity, while solving the pressing problems they face every day.
These time-saving recipes include vital topics like connecting to data, retrieving and managing data, transforming and analyzing data, modifying data, binding data to .NET user interfaces, optimizing .NET data access, enumerating and maintaining database objects, and maintaining database integrity.
The diverse solutions presented here will prove invaluable over and over again, for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated.
Teach yourself how to use ADO.NET 4, the data access technology that helps you create data-focused software faster and easier. With STEP BY STEP, you set the pace -- building and practicing the skills you need, just when you need them!
Gain a firm understanding of the fundamental concepts and tools provided with ADO.NET 4.0, one feature at a time. With clear discussions and hands-on examples written in Visual Basic and C#, you'll move step-by-step through the learning process.
- Manage data and information in a database-like fashion -- without access to a database
- Connect to external data sources, including databases and other standard data formats
- Use Entity Framework to interact with underlying data stores
- Learn why LINQ is a popular tool for analyzing information retrieved by ADO.NET
- Drive information to end users by binding data directly to Windows Forms and Web Forms
- Go beyond the core functionality of ADO.NET to manipulate data in advanced ways
Your online learning resources include:
- Files for building skills and practicing the book's lessons
- Examples and code in both the Visual Basic and C# languages
- Fully searchable eBook
Teach yourself the fundamentals of ADO.NET 4 -- one step at a time. With this practical, learn-by-doing tutorial, you get the clear guidance and hands-on examples you need to start creating datacentric applications for Windows and the Web.
Discover how to:
- Connect to external data sources, including databases and other data formats
- Use ADO.NET Entity Framework to interact with underlying data stores
- Build Entity Framework models with graphical design tools in Microsoft Visual Studio 2010
- Analyze information stored in ADO.NET with various LINQ providers
- Bind data directly to Windows Forms and Web Forms to drive information to users
- Manage disconnected or standalone data and information
- Go beyond the core functionality of ADO.NET to manipulate data in more advanced ways
Your step by step digital content includes:
- Practice exercises
- Fully searchable online edition of this book -- with unlimited access on the Web
Extend your expertise as you move beyond the basics -- and delve into the essential topics of programming with ADO.NET 4. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C#® and Visual Basic® to help advance your mastery of developing database applications for Windows® and the Web.
Discover how to:
- Connect to databases directly from your application to retrieve and manipulate data
- Use ADO.NET 4 to retrieve server-generated values
- Interact with an applications UI with data binding
- Model and interact with data using ADO.NET Entity Framework
- Query Microsoft SQL Server® databases with LINQ to SQL
- Manage datasets from a variety of databases with LINQ to DataSet
- Use ADO.NET as an offline data cache for your application
About the Author
Bill Hamilton is a software architect specializing in designing, developing and implementing distributed applications using .NET and J2EE technologies. Over the last ten years, he has provided consulting services in B2B, B2C, B2E, data integration, and portal initiatives for banking, retail, accounting, manufacturing, and financial services. An early technology adopter, he frequently evaluates, recommends, and helps his clients use new technologies effectively. Bill has designed and helped build several award winning software packages. Bill is the co-author of O'Reilly's ADO.NET in a Nutshell and author of ADO.NET Cookbook.
Table of Contents
Acknowledgments; Introduction; Who Is This Book For?; Organization of This Book; Conventions and Features in This Book; System Requirements; Code Samples; Errata and Book Support; We Want to Hear from You; Stay in Touch; Part I: Getting to Know ADO.NET; Chapter 1: Introducing ADO.NET 4; 1.1 What Is ADO.NET?; 1.2 Why ADO.NET?; 1.3 Major Components of ADO.NET; 1.4 Extensions to ADO.NET; 1.5 Connecting to External Data; 1.6 Summary; 1.7 Chapter 1 Quick Reference; Chapter 2: Building Tables of Data; 2.1 Implementing Tables; 2.2 Adding Data Columns; 2.3 Dataset Designer; 2.4 Summary; 2.5 Chapter 2 Quick Reference; Chapter 3: Storing Data in Memory; 3.1 Adding Data; 3.2 Examining and Changing Data; 3.3 Removing Data; 3.4 Batch Processing; 3.5 Validating Changes; 3.6 Summary; 3.7 Chapter 3 Quick Reference; Chapter 4: Accessing the Right Data Values; 4.1 Querying and Sorting Data; 4.2 Using Expression Columns; 4.3 Summary; 4.4 Chapter 4 Quick Reference; Chapter 5: Bringing Related Data Together; 5.1 Collecting Tables into Sets; 5.2 Establishing Relationships Between Tables; 5.3 Defining Table Constraints; 5.4 Summary; 5.5 Chapter 5 Quick Reference; Chapter 6: Turning Data into Information; 6.1 Aggregating Data; 6.2 Setting Up Indexed Views; 6.3 Summary; 6.4 Chapter 6 Quick Reference; Chapter 7: Saving and Restoring Data; 7.1 Serializing DataSet and DataTable Objects; 7.2 Guiding XML Generation; 7.3 Summary; 7.4 Chapter 7 Quick Reference; Part II: Connecting to External Data Sources; Chapter 8: Establishing External Connections; 8.1 Using Connection Strings; 8.2 Understanding Data Providers; 8.3 Connecting to SQL Server via a Data Provider; 8.4 Summary; 8.5 Chapter 8 Quick Reference; Chapter 9: Querying Databases; 9.1 Processing SQL Queries; 9.2 Returning Query Results; 9.3 Summary; 9.4 Chapter 9 Quick Reference; Chapter 10: Adding Standards to Queries; 10.1 Developing Parameterized Queries; 10.2 Using Parameters in Stored Procedures; 10.3 Summary; 10.4 Chapter 10 Quick Reference; Chapter 11: Making External Data Available Locally; 11.1 Understanding Data Adapters; 11.2 Moving Data from Source to Memory; 11.3 Moving Data from Memory to Source; 11.4 Table and Column Mapping; 11.5 Summary; 11.6 Chapter 11 Quick Reference; Chapter 12: Guaranteeing Data Integrity; 12.1 Transactions and Concurrency; 12.2 Using Local Transactions; 12.3 Using Distributed Transactions; 12.4 Summary; 12.5 Chapter 12 Quick Reference; Part III: Entity Framework; Chapter 13: Introducing the Entity Framework; 13.1 Understanding the Entity Framework; 13.2 Understanding the Entity Frameworks Layers; 13.3 Using the Entity Framework; 13.4 Summary; 13.5 Chapter 13 Quick Reference; Chapter 14: Visualizing Data Models; 14.1 Designing an Entity Framework Model; 14.2 Managing the Object Layer; 14.3 Summary; 14.4 Chapter 14 Quick Reference; Chapter 15: Querying Data in the Framework; 15.1 Getting to Know Entity SQL; 15.2 Running Entity SQL Queries; 15.3 Summary; 15.4 Chapter 15 Quick Reference; Chapter 16: Understanding Entities Through Objects; 16.1 Managing Entity Data Through Objects; 16.2 Using Query Builder Methods; 16.3 Summary; 16.4 Chapter 16 Quick Reference; Part IV: LINQ; Chapter 17: Introducing LINQ; 17.1 Getting to Know LINQ; 17.2 Using LINQ with .NET Objects; 17.3 Summary; 17.4 Chapter 17 Quick Reference; Chapter 18: Using LINQ to DataSet; 18.1 Understanding the LINQ to DataSet Provider; 18.2 Writing Queries with LINQ to DataSet; 18.3 Summary; 18.4 Chapter 18 Quick Reference; Chapter 19: Using LINQ to Entities; 19.1 Understanding the LINQ to Entities Provider; 19.2 Writing Queries with LINQ to Entities; 19.3 Summary; 19.4 Chapter 19 Quick Reference; Chapter 20: Using LINQ to SQL; 20.1 Understanding the LINQ to SQL Provider; 20.2 Using the Object Relational Designer; 20.3 Using Custom Database Functions in Queries; 20.4 Summary; 20.5 Chapter 20 Quick Reference; Part V: Presenting Data to the World; Chapter 21: Binding Data with ADO.NET; 21.1 Binding Data in Windows Forms; 21.2 Binding Data in WPF; 21.3 Binding Data in ASP.NET; 21.4 Summary; 21.5 Chapter 21 Quick Reference; Chapter 22: Providing RESTful Services with WCF Data Services; 22.1 Getting to Know the Service Layers; 22.2 Setting Up a Data Service; 22.3 Accessing a Data Service using REST; 22.4 Summary; 22.5 Chapter 22 Quick Reference;