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 coud not find a way to connect to Amazon Simple DB using VS2010 and LightSpeed. Do you support entity modeling for SimpleDB? Also, I have not found any complete example code for SimpleDB (or any other). I found some in your getting started video. I am trying to do simple tasks, like how I could insert, update, delete, link different tables in a query, etc. Your help is appreciated.
EK
|
|
|
Yes. If you install SimpleDB Management Tools, then you can display your SimpleDB domains in Server Explorer and from there you can drag them into a LightSpeed model. Regarding how to insert, update, delete etc. this is done in exactly the same way as for any other database (see e.g. Help Topics > LightSpeed > Basic CRUD in the help file). You just need to specify the AmazonSimpleDB provider (instead of SqlServer2005 or whatever), and to provide a connection string in the format described in the help file (Help Topics > Databases > Amazon SimpleDB). You will probably want to set the identity type to Guid as this is the easiest to work with in SimpleDB (you can also use String but this forces you to use natural keys which is a pain), and hence the LightSpeedContext.IdentityMethod should also be Guid. You cannot link different domains in a query on SimpleDB, as SimpleDB does not support joins. |
|
|
Thanks for your reply. |
|
|
I quick sample app (console project) with working code would be really helpful. We are in the process of evaluating different NoSQL solutions and associated persistence frameworks built around them, including ORM wrapper and Linq provider. I know I could probably do the tutorials for a standard database and get to a working example that way, but it would be more straightforward just to work only with SimpleDB. Do you have any samples that your team uses internally to test? Thank you and it looks so far like a very professional product. -Tommy |
|
|
Our unit tests aren't really suitable for evaluation, so I've created a simple console application that demonstrates basic mapping, loading and associations. (You will need to replace the access keys in the connection strings in the model and app.config files.) Zip file attached, plus screenshots showing the SimpleDB domains it uses. Let us know if you need any more info. |
|