Mobile Offline Sync database on Xamarin form

Question

Currently looking at the Enable Offline Sync for Xamarin Form : https://learn.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 · Accepted Answer · 2020-02-11 12:49:58Z

1

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.

answered Feb 11, 2020 at 12:49

ChampChris

1,6316 gold badges28 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

LittleFunny Over a year ago

Thanks. Yea i know it will create this columns for mean in the database but what if my existing tables used by the web application doesn't have this columns. Do I need to add them manually? coz it can be troublesome coz webapp not considered this scenerio

ChampChris Over a year ago

Yes have to add them manually to the DB or with a migration. Your Webapp should be protected from the entity changes, by projecting to to models in your linq queries. the backend server piece is this article learn.microsoft.com/en-us/azure/app-service-mobile/…

ChampChris Over a year ago

Just found this yesterday azure.microsoft.com/en-us/updates/…

Collectives™ on Stack Overflow

Mobile Offline Sync database on Xamarin form

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related