Entity Framework and soft deleted records

Question

Hello, All

I'm developing WCF service which is using entity framework as data source. Almost all is ok except problem with deleted records. In our database we're using soft delete (mark record attribute IsDeleted = true). My question how to exclude soft deleted records from entity set?

For example, entity "A" has entity set "Bs" (FK to table "B"). How to make that "Bs" entity set only contains from records which is not deleted?

Thank you

Answer 1

One way would be to use a defining query. But we typically handle this in the Repository, since we actually do want to materialize "soft deleted" entities in rare cases.