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
|
We're currently looking at converting a rather large model from L2S to LightSpeed and using split models to keep things more organized (it's currently a mess with over 50 tables in the database). The ability to split the model seems very nice. However, when working with it I quickly ran into usability issues. Scenario 1: Database has a Companies table and a Users table with a foreign-key to Companies (Company.Id -> Users.CompanyId). Model 1 contains the Company entity. Model 2 contains the User entity. What I did was drag the Companies table onto model 1, and dragged the Users table onto model 2. So far so good. Now I copied the Company entity from model 1 (ctrl+c) onto model 2 as a link. The result was a 'Is Linked' Company entity on model 2, but LightSpeed did not correctly link Company to User (even though the link should be present). Ok, so I then link the LinkedCompany to the User entity. Now I Right-Click in my model and do "Check Links" and it'll tell me "No matchin association found for association between Company and User in file Model2.lsmodel". But no way to 'quick fix' that problem. Scenario 2: Database has a Companies table, but no Users table yet. Model 1 contains the Company entity. Model 2 contains the 'Linked' Company entity. I add a new entity to model 2 named "Temp" and I update the database. E.g. a table gets added called Temp with only the Id-field. I now link Company -> Temp using a one-to-many association. I update the database again and LightSpeed says "The selected entities are up to date". But they aren't. However, if I then go to model 1 and past a linked "Temp" entity and put the link there and I update the database from that model, it will actually add the foreign key (and field) to the database. This seems reversed to me, as the field gets added to the table present in model 2, not to any table present in model 1. If you combine Scenario 1 and 2, then split models (imho) become a bit of a pain. It would be nice if you could right click on an entity in a model and then easily add linked entities. It would also be nice if you weren't forced to have the links present in both models, I mean it's nice to know that Users is linked to Companies in Model 1 but it's not required. I haven't tested it, but I'm not even sure what would happen if I where to give links different names in the two models. This was all tested with the latest nightly build of LightSpeed 4 Professional. |
|