Programming Entity Framework

Foreword; Preface; Who This Book Is For; How This Book Is Organized; What You Need to Use This Book; This Book???s Website; Conventions Used in This Book; Using Code Examples; Safari?? Books Online; Comments and Questions; Acknowledgments; Chapter 1: Introducing the ADO.NET Entity Framework; 1.1 Programming Against a Model, Not Against the Database; 1.2 The Entity Data Model: A Client-Side Data Model; 1.3 The Entity in ???Entity Framework???; 1.4 Choosing Your Backend; 1.5 Entity Framework Features; 1.6 The Entity Framework in Web Services; 1.7 What About ADO.NET DataSets and LINQ to SQL?; 1.8 Entity Framework Pain Points; 1.9 Programming the Entity Framework; Chapter 2: Exploring the Entity Data Model; 2.1 Why Use an Entity Data Model?; 2.2 The EDM Within the Entity Framework; 2.3 Your First EDM; 2.4 The EDM in the Designer Window; 2.5 Entity Properties; 2.6 The Naked Model: Inspecting the Model???s XML; 2.7 A Less Daunting Model View; 2.8 The Three Parts of the Model; 2.9 CSDL: The Conceptual Schema; 2.10 SSDL: The Store Schema; 2.11 MSL: The Mappings; 2.12 Database Views in the EDM; 2.13 Code Generation from EDM to Classes; 2.14 Summary; Chapter 3: Querying Entity Data Models; 3.1 Query the Model, Not the Database; 3.2 Your First EDM Query; 3.3 LINQ to Entities Queries; 3.4 Entity SQL Queries That Return Objects; 3.5 Method-Based Syntax Queries for LINQ and Entity SQL; 3.6 The Shortest Query; 3.7 EntityClient: The Lowest-Level Method for Returning Streamed Data Through EDM Queries; 3.8 Translation to Database Queries; 3.9 Avoid Inadvertent Query Execution; 3.10 Summary; Chapter 4: Exploring EDM Queries in Greater Depth; 4.1 Same Model, Friendlier Name; 4.2 Projections in Queries; 4.3 Projections in Entity SQL; 4.4 Querying Across Associations; 4.5 Joins and Nested Queries; 4.6 Grouping; 4.7 Shaped Data Returned by Queries; 4.8 Deferred Loading and Eager Loading Queries; 4.9 Retrieving a Single Entity; 4.10 Retrieving a Single Entity with GetObjectByKey; 4.11 Entity SQL???s Wrapped and Unwrapped Results; 4.12 Summary; Chapter 5: Modifying Entities and Saving Changes; 5.1 How ObjectContext Manages Entities; 5.2 The SaveChanges Method; 5.3 Adding New Entities; 5.4 Inserting New Parents and Children; 5.5 Deleting Entities; 5.6 Summary; Chapter 6: Using Stored Procedures with the EDM; 6.1 Adding the Stored Procedures into the Model; 6.2 Working with Functions; 6.3 Implementing Functions; 6.4 The EDM Designer???s Model Browser; 6.5 Mapping the Last of the Four Functions: CustomersbyState; 6.6 More About the Update Model Wizard; 6.7 Summary; Chapter 7: Tuning Up a Model; 7.1 The BreakAway Geek Adventures Business Model; 7.2 Creating a Class Library Project to Host an EDM; 7.3 Inspecting and Cleaning Up a New Model; 7.4 Cleaning Up Navigation Property Names; 7.5 Mapping a Few Stored Procedures; 7.6 Working with Many-to-Many Relationships; 7.7 Building the BreakAwayModel Project; 7.8 Summary; Chapter 8: Data Binding with Windows Forms and WPF Applications; 8.1 Data Binding with Windows Forms Applications; 8.2 Data Binding with WPF Applications; 8.3 Summary; Chapter 9: Working with Object Services; 9.1 Where Does Object Services Fit into the Framework?; 9.2 Query Processing; 9.3 Object Materialization; 9.4 The ObjectContext; 9.5 State Management and ObjectStateEntry; 9.6 Relationship Management; 9.7 Sending Changes Back to the Database; 9.8 Additional Features; 9.9 Summary; Chapter 10: Customizing Entities; 10.1 Partial Classes; 10.2 Customizable Methods; 10.3 Customizable Event Handlers; 10.4 Other Opportunities for Customization; 10.5 Summary; Chapter 11: Using the ASP.NET EntityDataSource Control; 11.1 Getting to First Base with the EntityDataSource Control and Flat Data; 11.2 Understanding How the EntityDataSource Is Able to Retrieve and Update Your Data; 11.3 Working with Related EntityReference Data; 11.4 Working with Hierarchical Data in a Master/Detail Form; 11.5 Browsing Through the EntityDataSource Events; 11.6 Summary; Chapter 12: Customizing Entity Data Models; 12.1 Designer Support for Mappings; 12.2 Mapping Table per Type Inheritance for Tables That Describe Derived Types; 12.3 Using Entity Splitting to Map a Single Entity to More Than One Table; 12.4 Using Conditional Mapping to Filter Entity Mappings; 12.5 Implementing Table per Hierarchy Inheritance for Tables That Contain Multiple Types; 12.6 Implementing Customizations That Are Not Supported by the EDM Designer; 12.7 Mapping Table per Concrete (TPC) Type Inheritance for Tables with Overlapping Fields; 12.8 Creating Complex Types to Encapsulate Sets of Properties; 12.9 Using QueryView to Create Read-Only Entities and Other Specialized Mappings; 12.10 Additional Customization Options; 12.11 Summary; Chapter 13: Working with Stored Procedures Whennnnnn Function Mapping Won???t Do; 13.1 Does the Procedure Line Up with an Entity?; 13.2 Overview of Procedures, UDFs, and TVFs in the EDM; 13.3 Composing Queries Against Functions; 13.4 Mapping and Executing Query Stored Procedures; 13.5 Adding Native Queries to the Model; 13.6 Adding Native Views to the Model; 13.7 Using Commands That Affect the Persisted Database; 13.8 Defining Insert, Update, and Delete Stored Procedures Directly in the Model; 13.9 Mapping Insert/Update/Delete to Types Within an Inheritance Structure; 13.10 Implementing and Querying with User-Defined Functions (UDFs); 13.11 Summary; Chapter 14: Using Entities with Web and WCF Services; 14.1 Building a Client That Is Ignorant of the Entity Framework; 14.2 Using the Entity Framework with ASMX Web Services; 14.3 Using the Entity Framework with WCF Services; 14.4 Summary; Chapter 15: Working with Relationships and Associations; 15.1 Deconstructing Relationships in the Entity Data Model; 15.2 Deconstructing Relationships Between Instantiated EntityObjects; 15.3 Defining Relationships Between Entities; 15.4 Learning a Few Last Tricks to Make You a Relationship Pro; 15.5 Summary; Chapter 16: Making It Real: Connections, Transactions, Performance, and More; 16.1 EntityConnection and Database Connections in the Entity Framework; 16.2 The Entity Framework and Transactions; 16.3 The Entity Framework and Security; 16.4 The Entity Framework and Performance; 16.5 Entities in Multithreaded Applications; 16.6 Summary; Chapter 17: Controlling Objects with ObjectStateManager and MetadataWorkspace; 17.1 Managing ObjectStateEntry Objects with ObjectStateManager; 17.2 Getting an ObjectStateManager and Its Entries; 17.3 CurrentValues and OriginalValues; 17.4 Building the ObjectStateEntry Visualizer; 17.5 ObjectStateManager and SavingChanges; 17.6 The MetadataWorkspace API; 17.7 Creating EntityObjects Without Entity Classes; 17.8 Creating Entities and Graphs Dynamically; 17.9 Summary; Chapter 18: Handling Entity Framework Exceptions; 18.1 Preparing for Exceptions in Entity Framework Code; 18.2 EntityConnectionString Exceptions; 18.3 Query Compilation Exceptions; 18.4 Creating a Common Wrapper to Handle Query Execution Exceptions; 18.5 SaveChanges Command Execution Exceptions; 18.6 ObjectStateEntries Returned by Object Services Exceptions; 18.7 InvalidOperationExceptions; 18.8 Exceptions When Multiple Parties Edit Data Concurrently; 18.9 Understanding Optimistic Concurrency Options in the Entity Framework; 18.10 Implementing Optimistic Concurrency with the Entity Framework; 18.11 Handling OptimisticConcurrencyExceptions; 18.12 Handling Concurrency Exceptions at a Lower Level; 18.13 Handling Exceptions When Transactions Are Your Own; 18.14 Summary; Chapter 19: Using Your Own Custom Classes; 19.1 Mapping Classes to the Entity Data Model; 19.2 Implementing the IPOCO Interfaces; 19.3 Custom Class Assemblies and Entity Data Model Files; 19.4 Summary; Chapter 20: Using the Entity Framework in n-Tier Client-Side Applications; 20.1 Thinking in Layers; 20.2 Finding Your Motivation: A Master/Detail Data Entry Form That Will Use the DataBridge Class; 20.3 Preventing Non-UI Logic from Leaking into the UI; 20.4 Implementing Logic That Fits Best in the Entity Partial Classes; 20.5 Building the CommandExecutor Class; 20.6 Building the DataBridge Class; 20.7 Using the DataBridge Class for Data Binding in a Master/Detail Form; 20.8 Allowing Users to Roll Back Their Edits; 20.9 Helping the User Who Forgets to Save Changes; 20.10 Summary; Chapter 21: Using the Entity Framework in n-Tier ASP.NET Applications; 21.1 Understanding How an ObjectContext Fits into the Web Page Life Cycle; 21.2 Introducing ASP.NET???s ObjectDataSource Control; 21.3 Designing Object Provider Classes to Be Used with an ObjectDataSource; 21.4 Wiring Up the Provider Classes to ObjectDataSource Controls; 21.5 Understanding Why We Didn???t Use Object Graphs in This Business Layer; 21.6 Summary; Chapter 22: Implementing a Smarter WCF Service for Working with Entities; 22.1 Will Your Client Agree to Your Data Contract?; 22.2 Shipping DTOs, Not EntityObjects; 22.3 Creating EntityState Properties That Do Not Rely on ObjectContext; 22.4 Designing the Service Interface; 22.5 Implementing the Service Operations; 22.6 Implementing the Client That Will Use the WCF Service; 22.7 Testing It All with a Simple Console Application; 22.8 Summary; Chapter 23: The Entity Framework, Today and Tomorrow; 23.1 What About Building Reports with the Entity Framework?; 23.2 Extensions, Samples, and Solutions from Microsoft; 23.3 Entity Framework v.Next; 23.4 Blogs, Forums, and Other Resources; Entity Framework Assemblies and Namespaces; Unpacking the Entity Framework Files; Exploring the Namespaces; Colophon;