How to add a ready-made database to the application (android) and work with it?

Question

Android

How to add a ready-made database to the application so that it is permanently stored in the application and you can work with it?
And which is better sqlite or MSSQL (it seems to be supported too).
I’ll clarify just in case, the application for android is written in xamarin in c#.

Answer 1

For android, it is possible to put the database file in assets and copy it and use it at the first start, but there are cases of incorrect work, especially since I don’t know how all this will behave under xmarin. You can simply prepare a file with json / xml data as it is more convenient and fill in the database at the first start