McCullough & Associates | Training | Consulting

(972) 712-7103

Introduction to Entity Framework 4.0

Take this class

Click here to request this course on a different date.

This class introduces Microsoft’s core ORM technology, Entity Framework. Participants will not only learn how to use Entity Framework, but also how to get the most from model oriented design and programming. This course utilizes Language Integrated Query (LINQ) and Entity SQL and provides the student with a comprehensive view of both. This course utilizes guided hands-on labs so that students can reinforce concepts with real world labs.

Audience

Students should be proficient in C#. Visual Studio 2010 and SQLServer or SQLExpress is required for labs.

Length: 3 Days

Outline

  • Introduction
  • Overview of EF
    • Providers
    • Features
      • Data model
      • Design tools
      • Relationships
      • Context
    • Datasets
    • API
  • The Entity Data Model
    • Conceptual Schema (CDSL)
    • Store Schema (SSDL)
    • Mappings (MSL)
    • Code Generation
  • Queries
    • LINQ to Entities
    • Entity SQL
    • Method based Queries
    • Projections
    • Navigation
    • Joins, nesting, grouping
    • Loading schemes
      • Deferred
      • Eager
  • Modifying data
    • The object context
    • Inserting
    • Deleting
    • Changing
  • Stored Procedures
  • Databinding (GUI)
  • Entity Classes
    • Partial classes
    • Event handlers
    • Customizing Data Models
    • POCO
  • More on Relationships
  • Performance
    • Connections
    • Transactions
    • Tuning
  • Security
  • Exceptions