How to sync the latest added data in the database table?

Question

Hi,

am developing a windows store 8.1 app using C# and xaml

I am using SQL Azure Database and Mobile services to get the data into my app.

I created the Mobile Service  using JavaScript backend.

Initially i have added some data into my DB table lets say 100 records and i have downloaded the 100 records into my app.

Then later i have added 20 more records into the table now the total records are 120.

When again i pull the data from the DB i need to get the newly added 20 records rather  than getting the whole 120 records.

How can i achieve this?

Answer 1

Hi,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue.

Regards,

Mekh.

Answer 2

Hi,

Please have a check on the below link and check if it helps.

http://azure.microsoft.com/en-us/documentation/articles/mobile-services-windows-store-dotnet-get-started-data/

Regards,

Mekh.

Answer 3

Hi Mekh..

Thanks for your reply.

Answer 4

Hi Santhosh Kumar,

If I understood correctly, if your mobile service is a custom type, you need to handle that in your Mobile Service. Set some flag like lastUpdatedDate date or something,  and return the updated data, instead of returning full list. 

---

Vishnu VG