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 have a Folder table which has a one-to-many association with a Menu. I have generated entities for these tables in the designer. When I run this LINQ query: return UnitOfWorkScope.Current.Folders.Where(f => f.Menu.Name + "-" + f.SerialNumber == reference.Trim()).SingleOrDefault(); I get the following error: Mindscape.LightSpeed.LightSpeedException : Query Error: Could not find field [SerialNumber] on model [Menu] |
|
|
The error message is misleading -- what this is actually trying to tell you is that you can't use attributes from multiple entity types in the same query. Your query combines a Menu (for its Name attribute) and a Folder (for its SerialNumber attribute). (See Help Topics > LINQ Support > Limitations of the LINQ Provider in the user guide, though this is actually a limitation of the LightSpeed core query engine.) |
|