I have a database with two tables: one for live orders, the other for dormant ones. This is what I want to represent in Entity Framework as the Orders entity. Additionally, I need a mechanism to tell if an order in this collection is active or not, ideally by using the status property of the entity, which should be set in accordance with the table the entity is in. Is it possible to do this with Entity Framework 1? How does Entity Framework 4 compare?
In your database, you may build a view and use that to produce the object.