Entity Framework 6.1, (Part 3 of 6): Querying and Updating

We’ll start this course by looking at LINQ to Entities, which lets you write SQL-like statements against entity objects using syntax built into C# and Visual Basic. Although you’re likely to use LINQ for every day application development with Entity Framework, you can also use Entity SQL, which is a powerful SQL-like querying language built into Entity Framework. Then, we’ll take a brief look at querying using the EntityClient API, which is a low-level option that lets you access raw data streams but requires you to materialize your own objects to receive the results. Next you’ll learn how to update existing entities, insert new entities, and delete entities, as well as get object state information.

Lesson 1:

• Entity Framework Query Options
• Architecture
• Building & Testing Queries
• Demo: LINQPad Setup
• Demo: LINQPad Queries & Expressions.

Lesson 2:

• Demo: Navigation References
• Demo: Simple Query
• Demo: Debugging
• Demo: var keyword
• Demo: View Classes Diagram
• Demo: Exploring the Code.

Lesson 3:

• A LINQ Primer
• LINQ Query Expressions & Methods
• Demo: Expressions & Methods
• Demo: Methods (cont.)
• Which Syntax to Use?.

Lesson 4:

• Projections
• Demo: Projections
• Demo: Anonymous Type
• Demo: Properties.

Lesson 5:

• Demo: Navigation References
• Demo: Navigation Collections
• Demo: Nav. Collections (cont.).

Lesson 6:

• Demo: Aggregates
• Demo: Grouping
• Demo: Grouping (cont.).

Lesson 7:

• Querying with Entity SQL
• Demo: Basic Entity SQL
• Basic Entity SQL Syntax
• VALUE Keyword
• Demo: Parameterized Query
• Canonical Functions
• Categories of Canonical Functs.

Lesson 8:

• Directly Querying EntityClient
• Demo: Direct Query
• Demo: A Little Tricky.

Lesson 9:

• Updating Entities & Saving Data
• Demo: Updating Entities
• Demo: Using SQL Profiler
• Inserting New Entities
• Demo: Inserting New Entities
• Demo: Inserting New (cont.)
• Deleting Entities
• Demo: Deleting Entities.