For simple applications, mapping directly from physical table to logical business entities reduces lots of cost in programming, especially while using code generators. However, no matter in sample or complex applications, besides mapping physical tables, there are few areas which might not be suitable to be mapped directly from databases tables.
To map one-to-many relation from database to logical application model, some design creates a base container class for the business entities, which includes both parent and child business entities as data element. It facilitates complex data containers to be passed through layers simply.
