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
|
We using Lightspeed 3.11 and getting the following error message in one of the queries The method 'Concat' is not supported. The query expression is built dynamically in the application and executed on a view. Before the expression is executed, it looks like the following {Query(MyViewABC).Where( => (((1 = 1) && ((null != Convert(.MyFieldABC)) && (.MyFieldABC.ToString().ToUpper().Contains("10000") || ((.MyFieldXYZ != null) && Concat(Convert(.MyFieldXYZ.Value.ToString()), Convert("-R")).Contains("10000"))))) && (.IsVoid = False))).Take(10000)} Where MyViewABC is a SQL Server 2008 view, MyFieldABC and MyFieldXYX are two columns returned by the view. Code that generates the error var results = uow.MyViewABC.Where(condition, true).Take(numberOfRowsInViews).ToList(); Is this a known limitation of this version of LightSpeed or my query needs to change in some way ?
|
|
|
|
|
It *looks* from your query as though this is String.Concat, not the LINQ Concat operator. Is that correct? If so, no, we do not directly support String.Concat, but the string addition operator is equivalent -- use that instead. |
|
|
|
|
Thanks. Will try to use replace String.Concat with string addition. |
|
|
|
|
Thanks. Will try to replace String.Concat with string addition. |
|
|
|
