Mobile Offline Sync database on Xamarin form

Question

Currently looking at the Enable Offline Sync for Xamarin Form : https://docs.microsoft.com/en-us/azure/app-service-mobile/app-service-mobile-xamarin-forms-get-started-offline-data.

I am having the code running on mobile and the backend run and created ToDoList table with 2 entries. The table created in ToDoList has UpdateAt, Version and Deleted columns create from the controller which extends TableController.

In existing web application currently already using the database with tables, do I have to create all the tables with UpdateAt, Version and Deleted columns. I am unsure how this data generated for those columns in web application so that both mobile and web data can be consistent.

ChampChris ChampChris · Accepted Answer · 2020-02-11T12:49:58

This free online book will go through details of getting the backend setup.

https://adrianhall.github.io/develop-mobile-apps-with-csharp-and-azure/chapter3/dataconcepts/

One of the ways described is to you EF already built in Code-First with migrations, and have a base class that looks like this

public abstract class TableData
    {
        public string Id { get; set; }
        public DateTimeOffset? UpdatedAt { get; set; }
        public byte[] Version { get; set; }
    }

Those are the table properties missing you asked about.

Mobile Offline Sync database on Xamarin form

1 Answers