System.Data.SQLite

Hi,

I'm using the new Nuget package (1.0.94.0) and when I publish my project (MVC/API template) from Visual Studio the x86 and x64 folders aren't copied to publish destination.

I'm looking into this; however, if the "Publish" functionality in Visual Studio
does not take into account per-solution NuGet packages, this might be difficult
to fix.

This issue also appears when creating a Post-build script to xcopy $(TargetDir)* to another folder.   

The x86 and x64 folders and interop dlls do not appear to exist before the post-build event script runs.

example:
xcopy "$(TargetDir)*.*" "$(SolutionDir)\InstallBuild" /YES

If you create a post-build script that fails, you can see that the x86 and x64 folders do not even get created in $(TargetDir)

example:
xcopy "$(TargetDir)*.*" "$(SolutionDir)\InstallBuild" /NOTAVALIDSWITCH

Hi,

I added a new target to System.Data.SQLite.Core.targets and worked (using Visual Studio 2013).

  <Target Name="CollectSQLiteInteropFiles"
          Condition="'$(CollectSQLiteInteropFiles)' != 'false' And
                     '$(OutDir)' != '' And
                     HasTrailingSlash('$(OutDir)') And
                     Exists('$(OutDir)')">
    <ItemGroup>
      <FilesForPackagingFromProject Include="%(SQLiteInteropFiles.Identity)">
        <DestinationRelativePath>$(OutDir)%(RecursiveDir)%(Filename)%(Extension)</DestinationRelativePath>
      </FilesForPackagingFromProject>
    </ItemGroup>
  </Target>

  <PropertyGroup>
    <PipelineCollectFilesPhaseDependsOn>
      CollectSQLiteInteropFiles;
      $(PipelineCollectFilesPhaseDependsOn);
    </PipelineCollectFilesPhaseDependsOn>
    <BuildDependsOn>
      $(BuildDependsOn);
      CopySQLiteInteropFiles;
    </BuildDependsOn>
    <CleanDependsOn>
      $(CleanDependsOn);
      CleanSQLiteInteropFiles;
    </CleanDependsOn>
  </PropertyGroup>

We've got similar changes on the publishWithNuGetPkg branch.  I wonder if your
changes would work better.

See also:

http://sedodream.com/2012/10/09/VSWebPublishHowToIncludeFilesOutsideOfTheProjectToBePublished.aspx

Related to [f16c93a932].

A candidate fix is checked in on the publishWithNuGetPkg branch, here:

   [/timeline?r=publishWithNuGetPkg]

Fixed on trunk via check-in [eb697cca1c].  Please let us know if this fix does not
address the issue in your environment.