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, I seem to be getting a lot of exceptions when I try many Linq functions. Do you have a list of compatible Linq functions that can be used with Simpledb so I can see whats available to query with? Many thanks |
|
|
|
|
The SimpleDB query language is extremely limited and does not support many functions. You should be okay with Where, Select, OrderBy, Take and Count. In a Where clause you should be able to use the ==, !=, <, <=, > and >= operators and the && and || logical operators. You should not expect to be able to use arithmetic operators (+, -, *, /, %) or CLR properties or methods (String.Length, DateTime.Year, String.Substring, etc.). However, you can use CLR string methods in a Where clause that translate to LIKE queries (e.g. String.StartsWith, String.Contains). You will not be able to use any operators, properties or methods in a Select or OrderBy clause. Skip is implemented, but is not efficient for large skips (because SimpleDB doesn't provide an offset operator so we need to manually skip over the required number of entries). The Amazon docs at http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/UsingSelect.html may be useful in getting an idea of what SimpleDB supports and what it doesn't. Note that the spec changes from time to time and LightSpeed may not have been updated to the most recent spec -- if you see something that you think should be translatable to SimpleDB and isn't, let us know. |
|
|
|
