Sharing Tables between Azure Mobile Service and Azure Website

Question

I want to create a website and a windows 8 app that share the same database. I followed this tutorial to create the website https://www.windowsazure.com/en-us/develop/net/tutorials/web-site-with-sql-database/ and I used the Azure Management Portal to create my mobile service.

Though each of them work perfectly, I cannot get the tables I publish through the web application to show up in my mobile service. And when I connect in my JS app using

var mobileService = new Microsoft.WindowsAzure.MobileServices.MobileServiceClient(
 "url",
 "secret"
 );

the tables don't exist.

How can I share these tables between the two services?

JuneT JuneT · Accepted Answer · 2013-01-12T05:19:24

the Azure Mobile Services creates its tables under it's own schema (the service name). you have to move your existing tables to this schema and you have to add them in the Azure Mobile Services Portal.

see: Using existing database with Azure Mobile Services

Sharing Tables between Azure Mobile Service and Azure Website

2 Answers