List of Listings

Chapter 1. Data access reloaded: Entity Framework

Listing 1.1. Displaying a list of orders

Listing 1.2. Displaying data for a single order

Listing 1.3. Creating a list of orders

Listing 1.4. The AddressInfo and Order classes

Chapter 2. Getting started with Entity Framework

Listing 2.1. Displaying orders in a grid

Listing 2.2. Displaying orders placed in the current month

Listing 2.3. Retrieving a single order

Listing 2.4. Inserting a new order

Listing 2.5. Updating an existing order

Listing 2.6. Deleting an existing order in a disconnected way

Listing 2.7. Deleting an existing order in a connected way

Chapter 3. Querying the object model: the basics

Listing 3.1. The Orders property definition in the context class

Listing 3.2. A connection string example

Listing 3.3. Building a connection string

Listing 3.4. Modifying an existing connection string

Listing 3.5. Attaching a handler to the ObjectMaterialized event

Listing 3.6. Setting tracking options

Listing 3.7. Setting tracking via the Execute method

Listing 3.8. Iterating twice over query results, causing double query execution

Listing 3.9. Iterating twice over query results, causing single query execution

Chapter 4. Querying with LINQ to Entities

Listing 4.1. SQL generated by the previous query

Listing 4.2. Retrieving all orders that have sold more than one product

Listing 4.3. Retrieving an order given its ID using First

Listing 4.4. Retrieving an entity by its key using context methods

Listing 4.5. Applying filters dynamically