Using SQLite with WinRT

Question

I am developing a metro ui application and I would like to use SQLite for some internal data instead of JET in order to take advantage of some already-written code.

Howerver when I try to use sqlite3_open for opening a data base, it does not work. I get an error saying a cannot open the data base.

I believe some APIs used by the SQLite cannot be used on metro style application.

Can someone help me on this? At least say me how to identify what apis should be ported?

Answer 1

This code should work:

auto localAppDataParh = Windows::Storage::ApplicationData::Current->LocalFolder->Path;
std::wstring path( localAppDataParh->Data() );
path += L"\\sample.db";
sqlite3* db;
int rc = sqlite3_open16( path.c_str(), &db);

I believe some APIs used by the SQLite cannot be used on metro style application.

might work(at least on Preview Release), but not permitted. Windows App Cert Kit says:

   Error: This application failed the supported API check.
   API CreateFileA in kernel32.dll is not supported for this application type. 
   API CreateFileW in kernel32.dll is not supported for this application type. 
   API DeleteFileA in kernel32.dll is not supported for this application type. 
    :
    :