How to handle Foreign Keys with Entity Framework

Question

I have two entities. Groups. Pools. A Group can create many pools.

So I setup my Pool table to have a GroupID foreign key.

My code:

using (entity _db = new entity()) {
    Pool p     = new Pool();
    p.Name     = "test";
    p.Group.ID = "5";
    _db.AddToPool(p);
}

This doesn't work. I get a null reference exception on p.Group.

How do I go about creating a new "Pool" and associating a GroupID?

Ian Mercer · Accepted Answer · 2010-05-20 20:27:34Z

1

You can either load the existing Group object, say group, from your context and then set p.Group = group or with EF4 you can set the GroupID on your pool directly since it can expose the foreign key properties if you specify that in the EDMX.

answered May 20, 2010 at 20:27

Ian Mercer

39.4k8 gold badges104 silver badges139 bronze badges

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

1 Comment

Jack Marchetti Over a year ago

I ended up just using p.Group = group;

Collectives™ on Stack Overflow

How to handle Foreign Keys with Entity Framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related