How do I properly load Object References with ADO.net Entity Framework

Question

What I'm doing works, but it's just wrong, I know it.

    public Profile GetProfile(int id)
    {
        Profile profile = (
            from u in en.User where u.UserID == id 
                select u.Profile.FirstOrDefault()
            ).First();

        if (profile.UserReference.Value == null)
            profile.UserReference.Load();

        return profile;
    }

Profile.UserID is a FK tied to User.UserID. Thus, Profile.UserID is not included in the Entity Model by the Entity Framework, which is why my linq query looks up the User object first and then selects the related Profile object (which feels very dirty to me).

Can anyone offer a better solution to:

Lookup the Profile object via User.UserID.
Load the User object reference in the returned Profile object.

Thanks in advance!

bendewey · Accepted Answer · 2009-03-27 17:37:54Z

4

Try using the Include method

public Profile GetProfile(int id)
{
  return (from p in db.Profiles.Include("User")
          where p.User.UserId == id
          select p).FirstOrDefault();
}

This method returns the profile object, with the User reference loaded already.

edited Mar 27, 2009 at 17:37

answered Mar 27, 2009 at 17:26

bendewey

40.4k13 gold badges105 silver badges127 bronze badges

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

2 Comments

Kappers Over a year ago

Backwards from what I wanted returned, but using the Include method and a similar syntax I was able to resolve my issue. Thanks bendewey!

Kappers Over a year ago

Yes, that's exactly what I changed it too.

Collectives™ on Stack Overflow

How do I properly load Object References with ADO.net Entity Framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related