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
|
Hi, I'm having a problem with SingleTableInheritance. The sql generated tries to insert the base record and the entity separately. For example: Pet -> (SingleTableInheritance) Dog In my unit of work I'm trying to save a Dog. But this generates: Insert Into Pet ( Name ) Values ("Rufus"); INSERT Into Dog (BarkType) Values ("Loud") I expected this to generate one insert: Insert Into Pet ( Name,BarkType ) Values ("Rufus","Loud") Apologies for the abstract example, I can send through more detailed info via PM if required. Is there anything you can suggest checking? using v5, VS2012 |
|
|
|
|
Check that you have not defined the inheritance relationship as Class Table Inheritance, the SQL statements would suggest that is how LightSpeed is treating it. If you think this is correct could you please send us through a copy of your model so we can investigate this.
|
|
|
|
|
Hi Jeremy I suspected/was pointed to Class Table Inheritance, but it looks to be SingleTableInheritance. Is there an address I can PM the model to? Or is the "attach file" private? Thanks Dan |
|
|
|
|
You can email this through to us at support at mindscape.co.nz - the file attach is public :)
|
|
|
|
