C#•4y ago

Query over multiple entities using the same interface [Answered]

I have a EF setup, where ~20 entities implement

IArchivable

IArchivable

IArchivable

IArchivable
This interface has a public

public Guid Id { get; }
public Guid IsArchived { get; set; }

public Guid Id { get; }
public Guid IsArchived { get; set; }

public Guid Id { get; }
public Guid IsArchived { get; set; }

public Guid Id { get; }
public Guid IsArchived { get; set; }

I wish to perform a query to find the entity with a certain id, and then another query to set the

IsArchived

IsArchived

IsArchived

IsArchived property to

false

false

false

false.
Is this possible with EF? (something like

_context.Set<IArchivable>().Where(...)

_context.Set<IArchivable>().Where(...)

_context.Set<IArchivable>().Where(...)

_context.Set<IArchivable>().Where(...) Or should I loop through all types (using reflection) and build an IQueryable for each of them?