ASP.NET providers and SQL Azure
We have two sets of ASP.NET providers which currently exist; the ASP.NET SQL providers , and the ASP.NET Universal Providers . In VS 2010 the SQL providers were in only providers used for our project templates. In VS 2012 we have switched to using the Universal Providers. One of the drawbacks of the SQL providers is that it leverages DB objects of SQL server which are not available in SQL Azure. In our updated web publish experience we have an Update Database checkbox which can be used to incrementally publish the database to the destination database. In this case if the source connection string is used by the ASP.NET SQL providers and you are publishing to SQL Azure then you will see the following message on the dialog. Note: you may see the
Read More...
Read the complete post at http://blogs.msdn.com/b/webdevtools/archive/2012/06/14/asp-net-providers-and-sql-azure.aspx