How to have all the no deleted entities?

With Northwind, if you do this:

context.Categories


you will get all the categories which are in DB. It means that you won’t have context added categories and you will have deleted entities.

Now, if you do this:

context.ObjectStateManager.GetObjectStateEntries(EntityState.Added | EntityState.Modified | EntityState.Unchanged).Select(ose => ose.Entity).OfType<Category>()

you will have only the entities already loaded into the context.


To have all the entities without deleted one, you can do this:


context.Categories.AsEnumerable().Where(c => c.EntityState != EntityState.Deleted).Union(context.ObjectStateManager.GetObjectStateEntries(EntityState.Added).Select(ose => ose.Entity).OfType<Category>())

This entry was posted in 7671, 7674. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>