I have created the xamrin.ios app with sqlserver 2014 database. Used the api method to do the DDL and DML operations. The app is working fine when it is connected via network.
Now the challenge when there is network issue, the app stopped working.
How the app works when it is offline (when network not available)?
Do we need to create the offline database in the app itself, the current app usages the complex stored procs with temporary tables, how do we sync when the app connected to the network?
Do I need to create the all c# methods again to work with local database?
Any ideas how we can handle this.