Edit Question - KnowledgeHub

Title Body

I'm messing around with LINQ for the first time, and I'm using EF 4.1 code first. I have entities containing nested Lists of other entities, for example: class Release { int ReleaseID { get; set; } string Title { get; set; } ICollection<OriginalTrack> OriginalTracks { get; set; } } class OriginalTrack { int OriginalTrackID { get; set; } string Title { get; set; } ICollection<Release> Releases { get; set; } ICollection<OriginalArtist> OriginalArtists { get; set; } } class OriginalArtist { int OriginalArtistID { get; set; } string Name { get; set; } ICollection<OriginalTrack> OriginalTracks { get; set; } } I'm wondering what is the quickest way, in one LINQ query, to obtain all the information for where ReleaseID == some value . I've done my homework, but have found solutions that require implicit rebuilding of an object (usually anonymous) with the required data. I want the data out of the database in the exact format that it is held within the database, i.e. pulling a Release object with relevant ReleaseID pulls and populates all the OriginalTrack and OriginalArtist data in the Lists. I know about Include() , but am not sure how to apply it for multiple entities. All help greatly appreciated.

Tags (comma-separated) Cancel