Use azure mobile service and multi-table query for Android

I don’t know if this is supported, but to create a view and access it through mobile services, you first need to create a table as a table from the Azure portal, and then use sp_rename in the database to rename your table [servicename].[tablename] Go to [servicename].[tablename2], and finally create a view named [servicename].[tablename]. I tested it and it seems to work. This is how to change the ToDoItem table to the view of the sample program provided by Microsoft: < p>

sp_rename [enzotest.todoitem],[todoitem2]

Create view enzotest.todoitem
with plan
such as
SELECT id,[text], Complete FROM enzotest.todoitem2

You don’t need to use SCHEMABINDING, but it helps to manage objects from the portal. Now that you have a view, you should be able to join other tables easily.

I am using an Android app to test the Azure Mobile Services tool. For single-table CRUD operations, it works very well, but I cannot find any documentation or examples in multi-table queries. Does anyone Seeing anything in this regard-whether it’s doing server-side (such as creating a view) or on an Android device?

Thank you

Anton

I don’t know if this is supported, but I want to create one View and access it through mobile services, first you need to create a table from the Azure portal as a table, then use sp_rename in the database to rename your table [servicename].[tablename] to [servicename].[tablename2], and finally create one The view named [servicename].[tablename]. I tested it and it seems to work. This is how to change the ToDoItem table to the view of the sample program provided by Microsoft:

sp_rename [enzotest .todoitem],[todoitem2]

Create view enzotest.todoitem
and plan
such as
SELECT id,[text], complete FROM enzotest.todoitem2

You don’t need to use SCHEMABINDING, but it helps to manage objects from the portal. Now that you have a view, you should be able to join other tables easily.