I am developing an app in pcl.What database should I use? But please tired of the answer SQLite.
I want global Database which will be accessed by internet like any dynamic website.
Please use Azure SQL database and develop a RESTful API for communication with database and your pcl app.
Follow my tutorials for creating database in azure portal and creating RESTful API with Add, Update, Delete methods. But I have a wroking example for consuming these RESTful API's in Xamarin Android. you can also use in pcl project.
Thank you @Ahsan_Siddique
I would also point out that while you don't want to hear "SWLite" that it is the de-facto database for the mobile devices - and it is that for a reason.
My biggest concern in your question is that you seem to think the data you send will be limited by the database. IE: If you have SQLite in the device that you have to have SQLite at the server. That just isn't the case. If you want to have SQLite on the device and talk to an MSSQL server that's fine.
The data you sent won't be a "database" or a "table". What you use on the device doesn't affect what you use on the server. Your REST calls will be sending objects, most likely serialized to JSON or XML. You will be serializing your data before sending, then de-serializing on the server when it is received. Once it is received it can then be stored in any database you like.
If this is new information for you then I urge you to add an experienced network/REST/database person to your team. Its not something you want to try to learn and figure out on the fly as you build your app.
Xamarin Inc., as a wholly-owned Microsoft subsidiary acting as a separate legal entity, adheres to the Microsoft Privacy Statement: Privacy & cookies