Skip to content

Instantly share code, notes, and snippets.

@andrew-t-moore

andrew-t-moore/FluentQueryForTestContext.cs

Created September 3, 2012 11:55
Show Gist options
  • Save andrew-t-moore/3608808 to your computer and use it in GitHub Desktop.
Save andrew-t-moore/3608808 to your computer and use it in GitHub Desktop.
Download ZIP
Fluent syntax query
Raw
FluentQueryForTestContext.cs
var query = context.Person
.GroupJoin(context.Pet,
person => person,
pet => pet.Owner,
(person, pets) => new { person, pets = pets.DefaultIfEmpty() })
.SelectMany(group => group.pets,
(row, pet) => new { row.person.FirstName, row.person.LastName, PetName = pet.Name });
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment