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
|
The Entity Framework supports various ways to map conceptual models to relational data. In particualar the Entity splitting is a nice feature where a single entity in the conceptual model is mapped to columns in two or more underlying tables. I would love to know if this is possible with LightSpeed? Please don't say make a view in the database. Cheers |
|
|
No, in accordance with its "convention over configuration" philosophy, LightSpeed assumes a fairly close alignment between the conceptual and storage models. Although some mapping is possible at the naming and data type level, there is a one-to-one mapping between entities and tables (ignoring views and stored procedures, and leaving out inheritance mapping which is a different kettle of fish), and between fields and columns. You can of course build higher-level objects that aggregate or adapt entities -- for example, an aggregate object that contains two entities in a one-to-one relationship and surfaces their properties on a single object -- but these are outside the scope of LightSpeed, and we've not explored the design issues involved. |
|