Efcore: Soft Delete

[ghost]

Hello.

Any suggestions on how to implement a soft delete at Entity Framework 7 ?

Any help is much appreciated.

Regards.

[rowanmiller]

We're putting this one on the backlog as a feature we would like to have at some point.

In the meantime, you probably could do this by overriding some of the low level components... but that is going to be fairly complex to do. If you decide to try... then you will probably make things less painful if you have your soft delete flag mapped as a shadow state property. For SaveChanges, you could look at a custom implementation of ICommandBatchPreparer.BatchCommands to generate updates rather than deletes for state entries that are marked as deleted.

cc @anpete in case he can give you a pointer of where to look for query.

[anpete]

Enabled in b1379b10f

[seriouz]

I think we definitely need an opt-out operator like: .NotFiltered()

[smitpatel]

@seriouz - The opt-out operator is named IgnoreQueryFilters
Ref: https://github.com/aspnet/EntityFramework/blob/dev/src/EFCore/EntityFrameworkQueryableExtensions.cs#L2462

[smitpatel]

@anpete - Is this issue fully resolved? If yes then we should close the issue and set the milestone.

cc: @divega

[anpete]

Unless we want to track a specific high-level Soft Delete feature.

[ajcvickers]

I think we do want to track that feature. Specifically, I should be able to delete objects normally in my graph or with .Remove, and then have it automatically soft delete those entities.

[divega]

Agreed. Query filters only solves a part of what we need.

[ajcvickers]

Note to implementer: remember to make cascade delete (of tracked entities) work.