I've got an existing SQL Azure database and want to reference that data in my mobile app. That app also is referenced in some web and desktop apps so I want to keep in intact.
I've created a new Azure Mobile Service and said I want to use an existing database and pointed to the Azure database.
It creates a new service but no tables or data appear get created in the Mobile Services tables for me to reference or create classes against. Is this how it works? Do you have to recreate or import? You would think it would copy the
schema or reference the same data tables or populate with some data.
Should I expect that the data is shared? If somebody enters records on the Mobile device should it reflect in my other apps that link to the same data? If I enter records on my desktop app, will it show up on the mobile device?
Lastly, my app uses a MVVM pattern and wondering if I simply populate my "lists" in the ViewModel using async calls? Do I have to do anything special to handle the NotifyProperty changed? Should I just skip the ViewModel and put calls
on my MainPage as the examples show?
>> I've created a new Azure Mobile Service and said I want to use an existing database and pointed to the Azure database.
I'd like to know whether you have chosen the existing database when you create the mobile service. If not, then your mobile service would not know it, please try to create a new one. If you've already chosen to use an existing database, it
is needed to rename the database's schema (or create a new schema) to be the same as your mobile service. Then please create tables in mobile services using the same name as your SQL database tables, only tables are needed to be created, it is not needed
to define columns, at this stage those mobile services tables are linked to database tables, and will work as expect. For instance, you can see your existing data in mobile service portal, and changes in mobile services will reflect in the database.
In addition, please refer to
http://www.strathweb.com/2012/12/using-existing-database-with-azure-mobile-services/ for a tutorial.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.