Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Entity from multiple tables
Hi,
Using MM.NET 4.0, classic entities (not Entity Framework).
Here is the problem I'm trying to solve... I want a lookup list for some objects in a child table, but I want a field from the parent table to display in the list. The best example I can think of is a customer with invoices. (That's not what I'm really working with but this simple example will do.)
Imagine a customer table (custPK, custName, blah, blah, blah)
And an invoice table (invPK, custFK, item, Qty, Amt)
I want an entity list of invoices (for look up purposes only) that contains:
( invPK, custName, Item, Qty, Amt )
Note the custName field comes from another table other than the primary entity.
I have been using mmBindingList for creating lookups and lists of single-table entities and this has worked well.
But how do I grab a field from another table? I tried to use the BLG to create a new entity for this purpose but unless I'm missing something, it can only create custom entities from a single table.
Any ideas?
Thanks,
Guy
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