SQL Compact doesn't work in Windows Azure
-
I've got an ASP.NET Web Pages site that draws fractals, it uses a SQL Compact database and works fine locally. But now I want to publish it to the Azure Cloud and I get an error in the Database.cshtml that it doesn't work. Is it true that SQL Compact doesn't work in the Azure Cloud? The URL is: http://aljo-fractals.azurewebsites.net Error: Failed to find or load the registered .Net Framework Data Provider. I use WebMatrix 3 I guess I need to add the framework to use the database, where do I get that? This must be easy to fix, but how...
-
I've got an ASP.NET Web Pages site that draws fractals, it uses a SQL Compact database and works fine locally. But now I want to publish it to the Azure Cloud and I get an error in the Database.cshtml that it doesn't work. Is it true that SQL Compact doesn't work in the Azure Cloud? The URL is: http://aljo-fractals.azurewebsites.net Error: Failed to find or load the registered .Net Framework Data Provider. I use WebMatrix 3 I guess I need to add the framework to use the database, where do I get that? This must be easy to fix, but how...
-
dusty_dex wrote:
Use the regular Desktop frameworks
Do I need to use NuGet? What is the exact name of the framework I need? The point is, it works fine locally in Webmatrix. Does it have to do with a connectionstring in de configuration file?
Well shouldn't any/all frameworks for developing Azure solutions be in the Azure SDK? ASP.Net Azure getting started
-
Well shouldn't any/all frameworks for developing Azure solutions be in the Azure SDK? ASP.Net Azure getting started
-
SQL Compact cannot be used in Windows Azure. You need Windows Azure SQL Database for this.
-
I read this just now, I would have reacted immediately otherwise. Compact SQL works just fine on Azure. You just need to deploy the proper DLLs. I have a site (test) working fine with it. Now, another question would be, beside "working", to ask if SQl Compact is "adapted" to Azure, and the answer would be NO! Simply because, beside working, you need to be able to follow easily the main feature of Azure, which is scaling (up or down) by creating instances of your site. Compact being purely local, you would end up having as many DBs as Instances, which is not great.....
-
I read this just now, I would have reacted immediately otherwise. Compact SQL works just fine on Azure. You just need to deploy the proper DLLs. I have a site (test) working fine with it. Now, another question would be, beside "working", to ask if SQl Compact is "adapted" to Azure, and the answer would be NO! Simply because, beside working, you need to be able to follow easily the main feature of Azure, which is scaling (up or down) by creating instances of your site. Compact being purely local, you would end up having as many DBs as Instances, which is not great.....