Guide to Entity Framework with

Data paging using E-SQL 
130
Working with the ADO.NET Entity Client 
131
Let's get into action 
133
Building the connection string 
133
Creating an entity connection 
134
Opening the connection 
134
Executing queries using the entity command 
135
Closing the connection 
136
Other operations with E-SQL 
138
Inserting a record using E-SQL 
138
Inserting a record with a foreign key constraint 
139
Retrieving native SQL from EntityCommand 
139
Transaction management in E-SQL 
140

---

Table of Contents
[
 iv 
]
Deferred, eager, and lazy loading 
142
Summary 143
Chapter 6: Working with LINQ to Entities 
145
Introducing LINQ 
146
Why LINQ? 
146
Understanding the LINQ architecture 
147
LINQ to XML 
148
LINQ to SQL 
148
LINQ to Objects 
149
LINQ to Entities 
150
Querying data using LINQ to Entities 
151
LINQ to Entities and Entity Framework 
151
Differences between LINQ to Entities and LINQ to SQL 
152
Parallel LINQ 
153
Operators in LINQ 
153
Aggregation 
154
Projections 
155
Ordering 
155
Quantifiers 
156
Restriction 
156
Conversion 
157
Element 
157
Set 
158
Querying data using LINQ 
158
Expressions in LINQ to Entities 
161
Constant expressions 
162
Comparison expressions 
162
Initialization expressions 
164
Null comparisons 
165
Navigation properties 
165
Immediate and deferred query execution 
166
Retrieving entity data from the Security database 
168