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
|
Hi guys - MVC project, VS 2012 SP3, SQL Server 2008 R2, LightSpeed 5 running nightly build from 5/20/2013. I'm having a bit of trouble getting this query to work, and getting a fairly generic exception back doesn't help much. Here's the offending function:
The error I get back is "Specified method is not supported" and the guide says my query is too complex to translate to SQL when I get this error. What I'm trying to do is get a list of all items "in stock" with a count of how many of that particular item we have on hand. 2 questions: 1> Why is this not working? 2> Do you have a better way of doing this short of moving all the interesting logic to a SQL view? Thanks, Dave |
|
|
Hi Dave, I believe this will be being caused by the use of:
Any reason you have this here? We dont support grouping by an entity (only properties) but in practice this would just return one group per entity anyway.
|
|
|
This syntax was pulled off Stack Overflow and does work in some cases - it's part of the magic that makes the query work, supposedly. I guess if I can't explain how it is supposed to work I shouldn't be using it anyway. I'll write the query in SQL and save it as a view and be done with it. Thanks! Dave |
|