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
|
I am working with mysql and was looking for an ORM with linq support due to my microsoft sql linq2sql background. Lightspeed seemed promising in the beginning, but i seemed to be completely stuck now. I have a table called groups. The table has two columns - ID and GrName. I have two foreign keys for two other tables (products and recipes) where each of the table has a GroupId column that references the ID column of the groups table. Lightspeed designer seems to be thrown completely off balance with this - it creates me IdId columns in the CLR objects and MySql then complains that it has no clue what these columns are. How can i go about this? |
|
|
|
|
Ok, this seems to pull something out of the db now that i clicked on the relationship arrow in the designer and populated the Key Property Reference to be Id for BOTH my relationships. Seems rather weird that the designer can't pick up on that on its own. |
|
|
|
|
Yes the designer cannot infer this so you do need to set up this mapping yourself - see http://www.mindscapehq.com/documentation/lightspeed/Working-with-Legacy-Databases/Using-Composite-Keys for more detail about how we handle composite keys.
|
|
|
|
