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 have a database with 70+ tables that I am migrating to use LightSpeed. I need to turn on Track Create Time, Track Update Time, Soft Delete and Optimistic Concurrency Checking options for all the tables. I figured that using Concrete Table Inheritance to do this would be a good idea. It would not only save me the trouble of setting the options on all 70 tables (either from Designer or even hand editing the .lsmodel) but also be a good design practice. So I created an Entity in the designer, and set its inheritance property to be Abstract. I create fields for UpdatedOn, LockVersion etc on this Entity. I also created the corresponding columns on all my tables. I then set this class as the base class for all my Entity objects (in the .cs file). However, it seems to me that when doing Update Database, or Update from Source the designer is not picking up inherited columns from the abstract base class. Am I doing something wrong here, or is it a known bug? Ta - Imtiaz |
|
|
No this sounds fine and the designer should be picking up these details when you perform a sync. Are you able to recreate this with a simple model scenario? e.g. Create a new model, add a base class entity and a derived entity onto the surface, set the base class as Inheritance: Abstract and toggle on Track Create Time and Track Update Time and then add a entity property. Wire up an inheritance relationship from the derived class specifying Concrete Table Inheritance. The result for me is that a table will be created as per the derived class naming which includes the properties specified on the base class. Can you confirm you still have an issue using that basic approach? If not can you send us through a copy of your model and we can have a look at what might be occurring here.
|
|