posted 20 years ago
Hi All,
I want to discuss something for better design of my application. I have different Value Objects(VOs) for different entities. Like i have CustomerVO,UserVO etc. These VOs are mapped to the Database entities. My Question is that if i have multiple rows to effect suppose i have the query "update users set ...... where customer_id=?" (1-N relationship), which will effect more than 1 row at a time. So for these kind of queries what should be the good design? i mean where should i run these types of queries? It will not be a good design to run these types of queries in any VO because this type of query could be related to multiple tables. So please assist me in designing my Application Best. Thanks
