Normally OpenAccess should generate two classes in this case - InventoryMaster and InventoryImage. As the InventoryImages.inventoryid column is a foreign key, this means that the two tables are in 1:n relation and the generated InventoryMaster class will have a collection of InventoryImage objects (IList<InventoryImage>). On the other hand, the InventoryImage class will have a reference to its parent object - InventoryMaster.
You can use both the collection and the reference to navigate from one object to another.
If you want to combine data from both tables (do a projection) in a single object, you can use a linq query which returns instances of an anonymous class:
var result = (from i
where i.primaryimage ==
FullImagePath = i.fullimagepath,
InventoryMaster = i.InventoryMaster
I hope that helps. Please let me know if you need more details or this is not what you are looking for.
All the best,
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items