About the Technical Reviewer
by Larry Tenny, Zeeshan Hirani, Rob Vettor, Nitin Gupta, Brian Driscoll
Entity Framework 6 Recipes, Second Edition
- Title Page
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Preface
- CHAPTER 1: Getting Started with Entity Framework
- CHAPTER 2: Entity Data Modeling Fundamentals
- 2-1. Creating a Simple Model
- 2-2. Creating a Model from an Existing Database
- 2-3. Modeling a Many-to-Many Relationship with No Payload
- 2-4. Modeling a Many-to-Many Relationship with a Payload
- 2-5. Modeling a Self-Referencing Relationship with a Code-First Approach
- 2-6. Splitting an Entity Among Multiple Tables
- 2-7. Splitting a Table Among Multiple Entities
- 2-8. Modeling Table per Type Inheritance
- 2-9. Using Conditions to Filter an ObjectSet
- 2-10. Modeling Table per Hierarchy Inheritance
- 2-11. Modeling Is-a and Has-a Relationships Between Two Entities
- 2-12. Creating, Modifying, and Mapping Complex Types
- CHAPTER 3: Querying an Entity Data Model
- 3-1. Querying Asynchronously
- 3-2. Updating with Native SQL Statements
- 3-3. Fetching Objects with Native SQL Statements
- 3-4. Querying a Model with Entity SQL
- 3-5. Finding a Master That Has Detail in a Master-Detail Relationship
- 3-6. Setting Default Values in a Query
- 3-7. Returning Multiple Result Sets from a Stored Procedure
- 3-8. Comparing Against a List of Values
- 3-9. Filtering Related Entities
- 3-10. Applying a Left-Outer Join
- 3-11. Ordering by Derived Types
- 3-12. Paging and Filtering
- 3-13. Grouping by Date
- 3-14. Flattening Query Results
- 3-15. Grouping by Multiple Properties
- 3-16. Using Bitwise Operators in a Filter
- 3-17. Joining on Multiple Columns
- CHAPTER 4: Using Entity Framework in ASP.NET MVC
- CHAPTER 5: Loading Entities and Navigation Properties
- 5-1. Lazy Loading Related Entities
- 5-2. Eager Loading Related Entities
- 5-3. Finding Single Entities Quickly
- 5-4. Querying In-Memory Entities
- 5-5. Loading a Complete Object Graph
- 5-6. Loading Navigation Properties on Derived Types
- 5-7. Using Include( ) with Other LINQ Query Operators
- 5-8. Deferred Loading of Related Entities
- 5-9. Filtering and Ordering Related Entities
- 5-10. Executing Aggregate Operations on Related Entities
- 5-11. Testing Whether an Entity Reference or Entity Collection Is Loaded
- 5-12. Loading Related Entities Explicitly
- 5-13. Filtering an Eagerly Loaded Entity Collection
- 5-14. Modifying Foreign Key Associations
- CHAPTER 6: Beyond the Basics with Modeling and Inheritance
- 6-1. Retrieving the Link Table in a Many-to-Many Association
- 6-2. Exposing a Link Table as an Entity
- 6-3. Modeling a Many-to-Many, Self-Referencing Relationship
- 6-4. Modeling a Self-Referencing Relationship Using Table per Hierarchy Inheritance
- 6-5. Modeling a Self-Referencing Relationship and Retrieving a Complete Hierarchy
- 6-6. Mapping Null Conditions in Derived Entities
- 6-7. Modeling Table per Type Inheritance Using a Nonprimary Key Column
- 6-8. Modeling Nested Table per Hierarchy Inheritance
- 6-9. Applying Conditions in Table per Type Inheritance
- 6-10. Creating a Filter on Multiple Criteria
- 6-11. Using Complex Conditions with Table per Hierarchy Inheritance
- 6-12. Modeling Table per Concrete Type Inheritance
- 6-13. Applying Conditions on a Base Entity
- 6-14. Creating Independent and Foreign Key Associations
- 6-15. Changing an Independent Association into a Foreign Key Association
- CHAPTER 7: Working with Object Services
- 7-1. Dynamically Building a Connection String
- 7-2. Reading a Model from a Database
- 7-3. Deploying a Model
- 7-4. Using the Pluralization Service
- 7-5. Retrieving Entities from the Change Tracker
- 7-6. Generating a Model from the Command Line
- 7-7. Working with Dependent Entities in an Identifying Relationship
- 7-8. Inserting Entities Using a Database Context
- 7-9. Querying and Saving Asynchronously
- CHAPTER 8: Plain Old CLR Objects
- 8-1. Using POCO
- 8-2. Loading Related Entities with POCO
- 8-3. Lazy Loading with POCO
- 8-4. POCO with Complex Type Properties
- 8-5. Notifying Entity Framework About Object Changes
- 8-6. Retrieving the Original (POCO) Object
- 8-7. Manually Synchronizing the Object Graph and the Change Tracker
- 8-8. Testing Domain Objects
- 8-9. Testing a Repository Against a Database
- CHAPTER 9: Using the Entity Framework in N-Tier Applications
- 9-1. Updating Single Disconnected Entities with the Web API
- 9-2. Updating Disconnected Entities with WCF
- 9-3. Finding Out What Has Changed with Web API
- 9-4. Implementing Client-Side Change Tracking with Web API
- 9-5. Deleting an Entity When Disconnected
- 9-6. Managing Concurrency When Disconnected
- 9-7. Serializing Proxies in a WCF Service
- CHAPTER 10: Stored Procedures
- 10-1. Returning an Entity Collection with Code Second
- 10-2. Returning Output Parameters
- 10-3. Returning a Scalar Value Result Set
- 10-4. Returning a Complex Type from a Stored Procedure
- 10-5. Defining a Custom Function in the Storage Model
- 10-6. Populating Entities in a Table per Type Inheritance Model
- 10-7. Populating Entities in a Table per Hierarchy Inheritance Model
- 10-8. Mapping the Insert, Update, and Delete Actions to Stored Procedures
- 10-9. Using Stored Procedures for the Insert and Delete Actions in a Many-to-Many Association
- 10-10. Mapping the Insert, Update, and Delete Actions to Stored Procedures for Table per Hierarchy Inheritance
- CHAPTER 11: Functions
- 11-1. Returning a Scalar Value from a Model-Defined Function
- 11-2. Filtering an Entity Collection Using a Model-Defined Function
- 11-3. Returning a Computed Column from a Model-Defined Function
- 11-4. Calling a Model-Defined Function from a Model-Defined Function
- 11-5. Returning an Anonymous Type from a Model-Defined Function
- 11-6. Returning a Complex Type from a Model-Defined Function
- 11-7. Returning a Collection of Entity References from a Model-Defined Function
- 11-8. Using Canonical Functions in eSQL
- 11-9. Using Canonical Functions in LINQ
- 11-10. Calling Database Functions in eSQL
- 11-11. Calling Database Functions in LINQ
- 11-12. Defining Built-in Functions
- CHAPTER 12: Customizing Entity Framework Objects
- 12-1. Executing Code When SaveChanges( ) Is Called
- 12-2. Validating Property Changes
- 12-3. Logging Database Connections
- 12-4. Recalculating a Property Value When an Entity Collection Changes
- 12-5. Automatically Deleting Related Entities
- 12-6. Deleting All Related Entities
- 12-7. Assigning Default Values
- 12-8. Retrieving the Original Value of a Property
- 12-9. Retrieving the Original Association for Independent Associations
- 12-10. Retrieving XML
- 12-11. Applying Server-Generated Values to Properties
- 12-12. Validating Entities on Saving Changes
- CHAPTER 13: Improving Performance
- 13-1. Optimizing Queries in a Table per Type Inheritance Model
- 13-2. Retrieving a Single Entity Using an Entity Key
- 13-3. Retrieving Entities for Read-Only Access
- 13-4. Efficiently Building a Search Query
- 13-5. Making Change Tracking with POCO Faster
- 13-6. Auto-Compiling LINQ Queries
- 13-7. Returning Partially Filled Entities
- 13-8. Moving an Expensive Property to Another Entity
- 13-9. Avoiding Include
- 13-10. Generating Proxies Explicitly
- CHAPTER 14: Concurrency
- 14-1. Applying Optimistic Concurrency
- 14-2. Managing Concurrency When Using Stored Procedures
- 14-3. Reading Uncommitted Data
- 14-4. Implementing the “Last Record Wins” Strategy
- 14-5. Getting Affected Rows from a Stored Procedure
- 14-6. Optimistic Concurrency with Table Per Type Inheritance
- 14-7. Generating a Timestamp Column with Model First
- Index
About the Technical Reviewer
Sergey Barskiy is an architect with Tyler Technologies. He is a Microsoft MVP and holds the following certifications: MCPD, MCTS, MCSD for .NET, MCAD for .NET, MCDBA, and MCP. He has been working with Microsoft technologies for over 15 years, and he is a frequent speaker at various regional and national conferences, such as VS Live, DevLink, CodeStock, and Atlanta Code Camp, as well as at local user groups. He is one of the organizers of Atlanta Code Camp and the Atlanta Windows Apps users group. He is also the INETA membership mentor for the state of Georgia.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.