book

Entity Framework 6 Recipes, Second Edition

Name: Entity Framework 6 Recipes, Second Edition
ISBN: 9781430257882

by Brian Driscoll, Nitin Gupta, Rob Vettor, Zeeshan Hirani, Larry Tenny

October 2013

Beginner to intermediate

548 pages

13h 48m

English

Apress

Read now

Unlock full access

Title Page
Dedication
Contents at a Glance
Contents
About the Authors
About the Technical Reviewer
Preface
CHAPTER 1: Getting Started with Entity Framework
1-1. A Brief Tour of the Entity Framework World1-2. Using Entity Framework
CHAPTER 2: Entity Data Modeling Fundamentals
2-1. Creating a Simple Model2-2. Creating a Model from an Existing Database2-3. Modeling a Many-to-Many Relationship with No Payload2-4. Modeling a Many-to-Many Relationship with a Payload2-5. Modeling a Self-Referencing Relationship with a Code-First Approach2-6. Splitting an Entity Among Multiple Tables2-7. Splitting a Table Among Multiple Entities2-8. Modeling Table per Type Inheritance2-9. Using Conditions to Filter an ObjectSet2-10. Modeling Table per Hierarchy Inheritance2-11. Modeling Is-a and Has-a Relationships Between Two Entities2-12. Creating, Modifying, and Mapping Complex Types
CHAPTER 3: Querying an Entity Data Model
3-1. Querying Asynchronously3-2. Updating with Native SQL Statements3-3. Fetching Objects with Native SQL Statements3-4. Querying a Model with Entity SQL3-5. Finding a Master That Has Detail in a Master-Detail Relationship3-6. Setting Default Values in a Query3-7. Returning Multiple Result Sets from a Stored Procedure3-8. Comparing Against a List of Values3-9. Filtering Related Entities3-10. Applying a Left-Outer Join 3-11. Ordering by Derived Types3-12. Paging and Filtering3-13. Grouping by Date3-14. Flattening Query Results3-15. Grouping by Multiple Properties3-16. Using Bitwise Operators in a Filter3-17. Joining on Multiple Columns

CHAPTER 4: Using Entity Framework in ASP.NET MVC
4-1. Building CRUD Operations in an ASP.NET MVC Page4-2. Building a Search Query 4-3. Filtering with ASP.NET’s URL Routing
CHAPTER 5: Loading Entities and Navigation Properties
5-1. Lazy Loading Related Entities5-2. Eager Loading Related Entities5-3. Finding Single Entities Quickly5-4. Querying In-Memory Entities5-5. Loading a Complete Object Graph5-6. Loading Navigation Properties on Derived Types5-7. Using Include( ) with Other LINQ Query Operators5-8. Deferred Loading of Related Entities5-9. Filtering and Ordering Related Entities 5-10. Executing Aggregate Operations on Related Entities5-11. Testing Whether an Entity Reference or Entity Collection Is Loaded5-12. Loading Related Entities Explicitly5-13. Filtering an Eagerly Loaded Entity Collection5-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 Association6-2. Exposing a Link Table as an Entity6-3. Modeling a Many-to-Many, Self-Referencing Relationship6-4. Modeling a Self-Referencing Relationship Using Table per Hierarchy Inheritance6-5. Modeling a Self-Referencing Relationship and Retrieving a Complete Hierarchy6-6. Mapping Null Conditions in Derived Entities6-7. Modeling Table per Type Inheritance Using a Nonprimary Key Column6-8. Modeling Nested Table per Hierarchy Inheritance6-9. Applying Conditions in Table per Type Inheritance6-10. Creating a Filter on Multiple Criteria6-11. Using Complex Conditions with Table per Hierarchy Inheritance6-12. Modeling Table per Concrete Type Inheritance6-13. Applying Conditions on a Base Entity6-14. Creating Independent and Foreign Key Associations6-15. Changing an Independent Association into a Foreign Key Association
CHAPTER 7: Working with Object Services
7-1. Dynamically Building a Connection String7-2. Reading a Model from a Database7-3. Deploying a Model7-4. Using the Pluralization Service7-5. Retrieving Entities from the Change Tracker7-6. Generating a Model from the Command Line7-7. Working with Dependent Entities in an Identifying Relationship7-8. Inserting Entities Using a Database Context7-9. Querying and Saving Asynchronously
CHAPTER 8: Plain Old CLR Objects
8-1. Using POCO8-2. Loading Related Entities with POCO8-3. Lazy Loading with POCO8-4. POCO with Complex Type Properties8-5. Notifying Entity Framework About Object Changes8-6. Retrieving the Original (POCO) Object8-7. Manually Synchronizing the Object Graph and the Change Tracker8-8. Testing Domain Objects8-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 API9-2. Updating Disconnected Entities with WCF9-3. Finding Out What Has Changed with Web API9-4. Implementing Client-Side Change Tracking with Web API9-5. Deleting an Entity When Disconnected9-6. Managing Concurrency When Disconnected9-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 Procedure10-5. Defining a Custom Function in the Storage Model10-6. Populating Entities in a Table per Type Inheritance Model 10-7. Populating Entities in a Table per Hierarchy Inheritance Model10-8. Mapping the Insert, Update, and Delete Actions to Stored Procedures10-9. Using Stored Procedures for the Insert and Delete Actions in a Many-to-Many Association10-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 Function11-2. Filtering an Entity Collection Using a Model-Defined Function11-3. Returning a Computed Column from a Model-Defined Function11-4. Calling a Model-Defined Function from a Model-Defined Function11-5. Returning an Anonymous Type from a Model-Defined Function11-6. Returning a Complex Type from a Model-Defined Function11-7. Returning a Collection of Entity References from a Model-Defined Function11-8. Using Canonical Functions in eSQL11-9. Using Canonical Functions in LINQ11-10. Calling Database Functions in eSQL11-11. Calling Database Functions in LINQ11-12. Defining Built-in Functions
CHAPTER 12: Customizing Entity Framework Objects
12-1. Executing Code When SaveChanges( ) Is Called12-2. Validating Property Changes12-3. Logging Database Connections12-4. Recalculating a Property Value When an Entity Collection Changes12-5. Automatically Deleting Related Entities12-6. Deleting All Related Entities12-7. Assigning Default Values12-8. Retrieving the Original Value of a Property12-9. Retrieving the Original Association for Independent Associations12-10. Retrieving XML12-11. Applying Server-Generated Values to Properties12-12. Validating Entities on Saving Changes
CHAPTER 13: Improving Performance
13-1. Optimizing Queries in a Table per Type Inheritance Model13-2. Retrieving a Single Entity Using an Entity Key13-3. Retrieving Entities for Read-Only Access13-4. Efficiently Building a Search Query13-5. Making Change Tracking with POCO Faster 13-6. Auto-Compiling LINQ Queries13-7. Returning Partially Filled Entities13-8. Moving an Expensive Property to Another Entity13-9. Avoiding Include13-10. Generating Proxies Explicitly
CHAPTER 14: Concurrency
14-1. Applying Optimistic Concurrency14-2. Managing Concurrency When Using Stored Procedures14-3. Reading Uncommitted Data14-4. Implementing the “Last Record Wins” Strategy14-5. Getting Affected Rows from a Stored Procedure14-6. Optimistic Concurrency with Table Per Type Inheritance14-7. Generating a Timestamp Column with Model First
Index

Content preview from Entity Framework 6 Recipes, Second Edition

About the Authors

Brian Driscoll has been developing business information systems using both Microsoft and traditional open source technologies since 2002. He specializes in providing consultative solutions to small- and mediumsized businesses in industries ranging from healthcare to market research. Brian earned a Master of Software Engineering degree with a concentration in expert systems from Drexel University in 2011.

Nitin Gupta is a Microsoft-certified technology consultant in .NET, and he is a certified PRINCE2 practitioner. He has extensive ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Entity Framework Core Cookbook - Second Edition

Publisher Resources

ISBN: 9781430257882Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Entity Framework 6 Recipes, Second Edition

by Brian Driscoll, Nitin Gupta, Rob Vettor, Zeeshan Hirani, Larry Tenny

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.