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
|
Hello, I'm having problem with many to many association. Can someone point me direction where I should look for solution? There are three tables (I've only mentioned PKs): WebsiteProducts: WebsiteProductsCategories WebsiteProducts and WebsiteCategories are connected to each other using WebsiteProductsCategories table which makes many to many association. My Lightspeed version is 3.1.1891.14711 I'm getting this error: System.Reflection.TargetInvocationException: Property accessor 'WebsiteProductsCategories' on object 'MYPROJECT.WebsiteCategory' threw the following exception:'Invalid column name 'IdCategoryId'. when I'm tryign to databind radtreeview: producteditcategoryradTreeView.DisplayMember = "CategoryName"; Thank you |
|
|
The easiest solution is to give the through table an Id column of its own rather than using a composite key, but if that's not an option, then see: http://www.mindscape.co.nz/blog/index.php/2010/06/17/many-to-many-associations-and-composite-keys-in-lightspeed/
|
|