Select a course:

Programming Entity Framework - endorsed by Julia Lerman

The Ado.Net Entity Framework is Microsoft's advanced O/R mapper that will be used increasingly in all .net development. Using this technology you can build a conceptual model of your database and then work with it using Linq to Entities, Entity Sql, or Entity Commands. The power comes in the speed and flexibility of development that this solution offers.

This course is aimed at developers and architects who need to understand and leverage this technology to bring productivity gains to the development process, to understand how to construct the conceptual model, embed business logic in generated classes, create Linq to Entity queries and more.

Julia Lerman, best selling author of "Programming Entity Framework" has endorsed this course.  Every delegate gets a free copy of her book.


This course lasts 2 days

Outline

Designing and Creating an Entity Data Model

  • Motivation
  • Best practices
  • Understanding CSDL, SSDL and MSL
  • Querying the EDM XML
  • Code Generation
  • Entity Properties
  • Navigation properties
  • Mapping Stored Procedures
    • Adding to the Model
    • Functions
  • Mapping Views
  • Working with many to many relationships

Querying Entity Data Models

  • Understanding Linq and language features
  • Anonymous Types
  • Object Initializers
  • Implicitly Typed Local Variables
  • Extension methods
  • Lambda Expressions
  • Query Expressions
  • Using Linq to Entities
  • Using Lambdas
  • Using Entity Sql
  • Parameterized ObjectQuery
  • QueryBuilder methods
  • Using the EntityClient, EntityCommand and ExecuteReader

Entity queries in depth

  • Projections
  • Querying Across Associations
  • Joins and Nested Queries
  • Grouping
  • Shaping results
  • Deferred and Eager Loading
  • Getting a Single Entity
  • Wrapping and Unwrapping
  • Querying the EDM Structures with the MetaDataWorkspace API

Editing and Updating Entity Data

  • Object Services & ObjectContext
  • Change Tracking
  • SaveChanges Method
  • Inserting Parents and Children
  • EntityKey and EntityState
  • Transaction Support

Customising Entities

  • Adding business and validation logic through:

    • Partial Classes
    • Customisable methods
    • Customisable Event Handlers
    • Custom Properties

Customising the Data Model

  • Inheritance
  • Table Per Type (TPT)
  • Table Per Hierarchy (TPH)
  • Table Per Concrete Type (TPC)
  • Querying Inherited Types
  • Using Conditional Mapping
  • Customisations not supported in the designer
  • Creating Complex Types
  • Using QueryView
 
 

About bbits training

Professional developers and trainers

All our training courses are delivered by professional developers who are also professional trainers.  We believe that training is a particular skill that needs to be backed up by real-world experience.  

Real-world training

The courses are based around achieving real-world productivity improvements, and providing a structured, encouraging environment that means delegates get the knowledge they need efficiently.

Flexible

Our courses, though they follow a structure, can differ each time they are delivered, because our trainers can focus on the areas of the course that are most important to the delegates.  We assess delegates requirements either with managers prior to the course, or at the start of each course with the delegates, so that we can provide the best possible course.  We can provide, at no extra cost, completely customised courses with different outlines and durations for any that require it - please contact us if you have a particular requirement.

Hands-on involvement

Each delegate will have their own computer and all our course contains a large proportion of "hands-on" work.  Each section is dealt with first by the trainer, who will fully involve the delegates in discussion, and through hand's on work, and be followed by exercises that will back this up, and push the delegates to go further.

Free goodies

At the end of the course, delegates recieve copies of all the examples and exercises to take back with them, together with a certificate, and other course materials on cd or usb stick. Look out for other goodies that we also provide!

Seen our courses elsewhere?

Our courses are often contracted out for other training providers, so you may see the same content elsewhere.  In fact we often deliver the courses for other providers too, so don't be surprised if you see our courses and trainers if you book through someone else.  Of course if you want to customise a course then please contact us directly!