The SQLite.WP81 SDK extension installs on VS2013 U2, but cannot reference an assembly in a WP 8.1 project

Question

After installing the SQLite.WP81 extension SDK in Visual Studio 2013 Update 2, the SQLite assembly for Windows Phone does not appear in the list of extensions on the Windows Phone 8.1 tab.

The Visual Studio Gallery discusses the SQLite page for Windows Phone 8.1, where another developer seems to have the same problem. Another developer suggests installing the extension manually, but that doesn’t matter. (And this advice seems suspicious, because it seems that this extension is now installed in the folder C: \ Program Files (x86) \ Microsoft SDK \ WindowsPhoneApp \ v8.1 \ ExtensionSDKs \ SQLite.WP81 \ 3.8.6)

It seems that the extension has not registered as an SDK extension with Visual Studio.

Anyone with ideas on how to fix this?

EDIT: things have progressed a bit

I moved the SQLite.WP81 folder from C: \ Program Files (x86) \ Microsoft SDK \ WindowsPhoneApp \ v8.1 \ ExtensionSDKs \ SQLite.WP81 \ to C: \ Program Files (x86) \ Microsoft SDK \ Windows Phone \ v8.1 \ ExtensionSDKs \ SQLite.WP81 \, updated paths in \ SQLite.WP81 \ 3.8.6 \ extension.vsixmanifest and \ SQLite.WP81 \ 3.8.6 \ DesignTime \ CommonConfiguration \ neutral \ SQLite.WP81.props to display the new location, and a package appeared.

This is weird and cool at the same time. Manually hacking the SDK seems strange. But this is progress.

Now the SQLite.WP81 problem requires some kind of SDK to be called Microsoft.VCLibs, and this does not appear in the resource manager. Searching the Internet so far has been fruitless.

Does anyone know where to find Microsoft.VCLibs?

Answer 1

Something broke between VS2013 U3 and my project. For some reason, after upgrading this project to Windows Phone Silverlight 8.1, VS2013 U3 will not display any SDK extensions for Windows Phone 8.1.

I used the XML editor to include the following links in the .csproj project file.

<ItemGroup> <SDKReference Include="SQLite.WP81, Version=3.8.6"> <Name>SQLite for Windows Phone 8.1</Name> </SDKReference> </ItemGroup> <ItemGroup> <SDKReference Include="Microsoft.VCLibs, Version=12.0"> <Name>Microsoft Visual C++ 2013 Runtime Package for Windows Phone</Name> </SDKReference> </ItemGroup> 

Another problem hindering my project was using different sqlite.winmd files between projects. The application will create and deploy, but the application will crash at runtime. Some Debug log message says that SQLite is not registered. (Sorry, I didn’t record the actual message.) Looking through all my projects, creating identical links to sqlite.winmd, finally I got an application running on WP8.1.

Hope this does not allow others to spend a few days.

Answer 2

Try logging into your drive and use the search bar to find the correct .dll extension to get the latest results date and see if it works.

Answer 3

Ok, here's what I managed to do (but Im still can't even compile)

I installed sqlite version of WP 8.0, which I was able to reference in my WP 8.1 project. I unloaded the project, opened the csproj file, where I changed the WP8.0 link to WP8.1. After that, I get the correct sdk, but VS complains about Microsoft.VCLibs. I was able to solve this by manually editing csproj again and adding this snippet:

  <ItemGroup> <SDKReference Include="Microsoft.VCLibs, Version=12.0"> <Name>VCLibs</Name> </SDKReference> </ItemGroup> 

Right below, where is a similar sqlite fragment. After that, VS no longer complains about VCLib. But when you try to use the sqlite-net shell, it does not recognize the Sqlite namespace, which I think is a bad sign.