Most efficient LINQ to SQL query for objects and children?

Question

In straight SQL, I'd probably wrap some logic over a simple join, but how would I do this efficiently in LINQ to SQL? Imagine I have two tables:

Parent

ID

Child

ParentID
ID
Name

Ideally I'd like a graph of Parent objects with a "Childs" property that is actually a Dictionary<int, string>.

Suggestions?

Andreas Grech · Accepted Answer · 2009-07-17 06:15:12Z

2

//set up dataloadoptions

DataLoadOptions options = new DataLoadOptions();

options.LoadWith<Parent>(item => item.Child);

context.LoadOptions = options;

var children = context.Parent.First().Child;

edited Jul 17, 2009 at 6:15

Andreas Grech

108k102 gold badges303 silver badges362 bronze badges

answered Jul 17, 2009 at 5:58

ravi

1,01812 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andreas Grech · Accepted Answer · 2009-07-17 06:30:22Z

0

Something along the lines of this:

MyDataContext.Parents
    .Select(p => 
        new { p.ID, 
             Childs = p.Children.ToDictionary(c => c.ID, c => c.Name)
        }
     );

The above will project an anonymous type with two properties: An ID ( being the Parent's) and a Dictionary containing the childrens' ID and Name.

answered Jul 17, 2009 at 6:30

Andreas Grech

108k102 gold badges303 silver badges362 bronze badges

Collectives™ on Stack Overflow

Most efficient LINQ to SQL query for objects and children?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related