Is there a way to remove change tracking mechanism for a single entity?

Question

I have something like this:

var dbTransactions = context.Transactions.Where(t => t.Date >= yesterday).Select(t => t).ToList();

Now, i would like to remove objects from dbTransactions list, but not from the actual database. Later on i am calling context.SaveChanges() and if i would do that, it would erase rows from my db. How can i disable changes tracking for dbTransactions?

http://stackoverflow.com/questions/4168073/entity-framework-code-first-no-detach-method-on-dbcontext — SLaks, Mar 04 '13 at 19:18
Removing objects from a `List` won't mark them as deleted in your `DbContext` — Nick Butler, Mar 04 '13 at 19:18

score 9 · Accepted Answer · answered Mar 04 '13 at 19:21

9

I think you can use AsNoTracking and for Transactions use Detach

Youcontext.YourEntities.AsNoTracking().Where);

or use

Youcontext.Transactions.Detach(obj);

answered Mar 04 '13 at 19:21

1

Is there anything like a `[NoTracking]` attribute to use for POCO entities? How should we mark POCO entities (in our case lookup entities) as no-tracking?! – orad Jun 26 '14 at 01:32

score 0 · Answer 2 · answered Mar 04 '13 at 19:18

0

Remove those entities from the context using Detach():

context.Transactions.Detach(obj);

so clearly you will have to recover that list - but then just iterate through it and detach them.

answered Mar 04 '13 at 19:18

Mike Perrenoud

64,877
28
152
226

Is there a way to remove change tracking mechanism for a single entity?

2 Answers2