Guide to Entity Framework with

Implementing our first application using the Entity Framework 
46
Summary 54
Chapter 3: 
Entities, Relationships, and the Entity Data Model 
55
Entities, entity types, and relationships in the EDM 
56
What is an entity? 
56
Defining entity sets in the EDM 
57
Extending the existing entity types to create derived entity types 
61
Association sets, associations, containment, and multiplicity 
63
What are entity containers? 
65
Exploring the Security EDM 
67
The Mapping Details window 
68
The Entity Model browser 
70
The EDM layers 
72
The CSDL schema 
72
The SSDL schema 
79
The MSL schema 
81
Entity classes 
85
Summary 88
Chapter 4: Working with Stored Procedures in the
Entity Data Model 
89
Creating a database using model-first development 
90
Creating stored procedures 
105

---

Table of Contents
[
 iii 
]
Mapping stored procedures to functions in the EDM 
108
Mapping the create, update, and delete functions to entities in the EDM 111
Mapping stored procedures with no entity set 
113
Executing stored procedures using the EDM 
113
Mapping stored procedures that return custom entity types 
114
Summary 116
Chapter 5: Working with Entity Client and Entity SQL 
117
An overview of the E-SQL language 
118
From T-SQL to E-SQL 
118
Why E-SQL when I already have LINQ to Entities? 
119
Features of E-SQL 
120
Operators in E-SQL 
121
Arithmetic operators 
121
Comparison operators 
122
Logical operators 
122
Reference operators 
122
Type operators 
123
Set operators 
123
Operator precedence 
124
Expressions in E-SQL 
124
Query expressions in E-SQL 
124
Identifiers, variables, parameters, and types in E-SQL 
125
Row 
126
Collections 
126
Reference 
127
Canonical functions in E-SQL 
128
Mathematical functions 
128
Aggregate functions 
128
String functions 
129
Bitwise functions 
129
D
ate and time functions 
130