This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have the following table Implement. Implement has a FK to ImplementType (1 to 1). ImplementType table is associated with a link table called MachineToImplementCompatibility. MachineToImplementCompatibility has a pk and the two FK's, one back to ImplementType this is how it is associated. I'm trying to retrieve the Impments where the ImplementType.MachineToImplementCompatability.MachineTypeID(the other FK Pointing differnt direction) = machineTypeID; My issue is that the MachineToImplementCompatability tabes is a collection of many and and I dont know how to query it using your methods... Any Help would be appriciated, Dan
|
|
|
If you're doing this in LINQ, the trick is to begin your query from an entity that enables you to follow only to-one links: from c in uow.MachineToImplementCompatibility If you're using the LightSpeed Query API, you can just use collections as part of the Entity.Attribute statement: Entity.Attribute("ImplementType.MachineToImplementCompatibilities.MachineTypeID") and LightSpeed will figure out that it's a collection and needs to be handled as such. |
|