Could not find SQLite.UWP.2015 SDK when creating UWP application using hosted TFS pool

Question

I created a UWP application using Sqlite. On my local machine, I had to install the following SQLite for the universal Windows platform Visual Studio Extension to force it to build. I used this blog when using sqlite in UWP

Now I'm trying to implement continuous integration with Visual Studio Team Services (was Team Foundation Server Online).

I use the Hosted pool to create my application, but I get the following message:

C: \ Program Files (X86) \ MSBuild \ 14.0 \ Bin \ Microsoft.Common.CurrentVersion.targets (2049.5): Error MSB3774: Could not find SDK "SQLite.UWP.2015, Version = 3.12.2".

and he breaks the assembly.

How can I fix this in the pool? I do not have physical access to the machine, as it is managed using TFS online

EDIT:

Upon detection, it is a library installed on my local machine (via the Visual Studio extension), and therefore does not exist on my computer, which means that the link is broken. I am trying to add the appropriate files to the source control and reference it directly from the control source. But I have no idea what she is referring to, because she is not talking. Link properties are as follows:

Answer 1

Unable to install extension in Hosted Build Agent.

Q: , , ?

A: . .

, Hosted Build Agent: .

. , .

Answer 2

, :

Microsoft SDKs ( ).

csproj:

<PropertyGroup>
  <SDKReferenceDirectoryRoot>$(MSBuildProjectDirectory)\..\..\..\..\Microsoft SDKs;$(SDKReferenceDirectoryRoot)</SDKReferenceDirectoryRoot>
</PropertyGroup>

, . , VSTS, dev-.

Answer 3

Hosted VSTS. TS, .

You can use the CI difference service, such as Appveyor, with some control over installing the extension through powershell.

Or you can wait for Windows 10 Anniversary with enable Sqlite.

Answer 4

• Download SQLite for the universal Windows Platform SDK here
• Install it by double-clicking.

This solved the problem with my UWP project.