entity framework adding record to join table

Question

Given 3 database tables: Businesses, Markets, BusinessesMarkets

I want to add a new business and I want the business to be in a particular market. How do I add to the join table in EntityFramework speak?

For example, the user wants to create a new business called ABC Co and add it to the Southern region market.

Paul · Accepted Answer · 2011-09-18 02:50:11Z

8

This is making some assumptions about your domain model:

var southernRegion = db.Markets().Find(the_id);
var abcCo = new Business();

southernRegion.Businesses.Add(abcCo);

db.SaveChanges();

EF will handle the join table for you!

edited Sep 18, 2011 at 2:50

answered Sep 18, 2011 at 2:13

Paul

12.4k4 gold badges52 silver badges58 bronze badges

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

2 Comments

Rod Over a year ago

Very cool! one thing: southernGroup.Markets.Add(abcCo), I didn't have .Markets in intellisense. I had southernGroup.Businesses? The tooltip showed "Market.Businesses"

Rod Over a year ago

I just wanted to say, "thanks!" again. This was an epiphany for me. Can't believe this was 4 years ago! I was reminded of this because I was hopefully able to help someone today with this knowledge.

Collectives™ on Stack Overflow

entity framework adding record to join table

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