Information générale
Catégorie:
The Mere Mortals .NET Framework
Hi,
Is there a way to join a table with all its lookup value tables without using a Join statement in the business object?
Our datamodel has a lot of lookup tables (read: extremely normalised) and I need a good solution for how these are handeled. For example if an Order has and OrderType lookup as well as OrderItems child table, how would you organise the Order and OrderType tables into business object(s).
At the moment the idea is to use SQL Join to join a business object's main table (Order)to all its lookup tables (OrderType) but the sql statements would be huge since there are a lot of these lookup tables and I am afraid that it would become unmanageable.
Thank you in advance,
Andrew
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement