Hi,

Anyone knows if it's possible to map a class instances as lists for other 2 class instances?

For instance, I have 3 tables - one with jobs(projects), one with workers and one with hours. On each job I may have workers working a number of hours at different pay rates at different moment in times. I'd like to be able to retrieve the list of hours for a job (as a collection) but at the same time I'd like to be able to retrieve the list of hours for an worker. All to be done by mapping and not queries. I was successful in doing the mapping but either only for jobs or only for workers - if I try to map hours twice I get errors (objects of type Hour cannot be added to 2 collections).

Is there a work around ? How can this be done ?

Thanks, Don

You can map one of the mappings as readonly by using the insert="false" and udate="false".