#Microsoft access database for android how to

Public override SQLiteDatabase WritableDatabase Public override void OnUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) Public override void OnCreate(SQLiteDatabase _database) #region implemented abstract members of SQLiteOpenHelper Public SQLiteUtil(Context _context) : base(_context, DATABASE_FILE_NAME, null, VERSION) Private static string DATABASE_FILE_NAME = 'Spotlight.sqlite' Private static string DATABASE_DIRECTORY = Environment.GetFolderPath() Public class SQLiteUtil : SQLiteOpenHelper

#Microsoft access database for android how to

I couldn't find the Logical Name among the properties of the file in the Solution Explorer though, so I don't really know where to find it.ĭo you have any suggestions on how to find the Logical Name of the database in Xamarin studio? I'm suspecting it might be because Xamarin Studio might modify the Logical Name of the database, like adding a prefix or something like that that but I'm not sure. Using (var destination = System.IO.File.Create (destinationPath))īut when I Debug it I get a NullReferenceException. Using (Stream source = ().GetManifestResourceStream('test3.db3')) I'm trying to do it like this: var destinationPath = Path.Combine ((),'test3.db3') I'm having problems copying it into the personal folder though. Jonp: Thank you for the tip about storing it as an EmbeddedResource, since I'm hoping to make a cross-platform application that's great advice. StevenTheEven: That's a great example of how to use SQLiteOpenHelper, thanks.