c# - Map same table to two different lists -

is possible have 1 table maps 2 different lists?

for example 1 list might hold active orders , other list might hold submitted orders.

in database orders in 1 table different state.

i assuming can use clause on bag collections? have issues when persisting data?

i don't think should handle on mapping level. either query filtered data in service, or add methods entity, getactiveorders() , getsubmittedorders() filter (mapped) list of orders.

btw, think clause on collection mappings work.