i don't have a good answer for you, but i do know that azure table storage is for non-relational data tables, meaning that if you need to create relational joins between tables, this most likely won't be the route to go.

as for sql data services, there's a codeplex project called phluffyfotos that has a "linq to sds provider" that you might want to check out for inspiration.

phluffyfotos is a web 2.0 picture gallery service where users can upload their pictures from the web or mobile device. this sample is designed to demonstrate how you can develop a multi tenant application using sql server data services (ssds).

the demo utilizes several technologies including: mvc preview 4, linq, windows communication foundation, silverlight, windows powershell, and the .net compact framework 3.5.


you should use sql data services. i guess by now you know this:

for the underlying windows azure platform, we’re adding fastcgi / php support, along with the ability to run full trust .net applications; sql data services goes relational, allowing you to use the full stack, linq to sql, and so on inside a cloud offering;

via tim sneath mix09 post

Related Query

More Query from same tag