How do I remove related objects in linq to entity framework

Question

I have 2 tables:

orders 
orderItems

connected to one another threw a relationship(FK orderId in the orderItems table). is there a difference between:

order.orderitems.remove(...)

to just setting the orderId value to null when trying to remove the related entity?

Hw90's answer is wrong. There is no difference between the two things you are doing. — Andrew Barber
– Andrew Barber, Commented Apr 24, 2012 at 17:12

Arthur Vickers · Accepted Answer · 2012-04-25 04:08:56Z

2

Setting the FK property to null and removing the entity from the navugation property both do the same thing. That is, they both sever the relationship between the entities but do not cause either entity to be deleted. It's the same as setting the FK value in the database to NULL.

To delete the entity you must call Remove on the DbSet for the entity. For example

context.OrderItems.Remove(orderitem);
context.SaveChanges();

answered Apr 25, 2012 at 4:08

Arthur Vickers

7,53334 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

How do I remove related objects in linq to entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related