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
|
LightSpeed 5.0.2587.0 In a simple inheritance hierarchy (ClassTableInheritance) subclass has a value object property, but during the projected query LightSpeed tries to get it from a base class, failing as a result. For instance, LINQ projection in attached test project (Customer is inherited from Person) produces this SQL:
But there is no Person.AddressStreet, only Customer.AddressStreet. |
|
|
Sorry for the delay in responding. Unfortunately CTI doesnt properly support value objects leading the issues such as the above. Due to the work involved we are not likely to be able to address this so we would suggest not using value objects with CTI. As an extreme workaround if you had a very limited and controllable set of queries you needed to perform in this manner you can still use a direct SQL query (e.g. FindBySql, or via the RawSql query property) to execute the correct query.
|
|