LINQ to SQL to Azure Table Storage or SQL Data Service

Question

I have a Silverlight application in which I use LINQ to SQL to store my data. Now I have added this application to the Azure cloud and I want to use the Azure method to store my data. But I do not know whether to use "Azure Table Storage" or "SQL Data Service" and how I can use it.

Answer 1

You should use SQL Data Services. You probably know this now:

Support for FastCGI / PHP was added for the base Windows Azure platform, as well as the ability to run applications with full .NET trust; SQL Data Services relational, allowing you to use the full stack of ADO.NET, LINQ to SQL, etc. Inside the cloud offer;

via post Tim Sneath mix09

Answer 2

I don’t have a good answer for you, but I know that Azure Table Storage is for non-relational data tables, which means that if you need to create relational joins between tables, it most likely will not be a route to go.

As for SQL Data Services, there is a CodePlex project called PhluffyFotos , which has a “LINQ to SDS provider” that you might need to check your inspiration.

PhluffyFotos is a Web 2.0 Gallery service website where users can download their photos from the Internet or mobile phone device. This sample is intended to demonstrate how you can develop a multi-tenant application using SQL Server Data Services (SSDS).

The demo uses several technologies including: ASP.NET MVC Preview 4, LINQ, Windows Foundation communications, Silverlight, Windows PowerShell, and the .NET Compact Framework 3.5.