blocks|key|451235|text|程序集可能会有争用吗？检查是否有另一个应用程序在DLL上具有文件锁。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451236|如果这是原因，那么使用像Sysinternal's+Process+Explorer这样的工具来发现有问题的程序应该很容易。|offset|length|451237|HTH，Clay|451238|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx^0|0|C|U|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Could there be contention for the assembly? Check to see whether there's another application with a file lock on the DLL. 

If this is the reason, it should be easy to use a tool like <a href="http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx" rel="nofollow">Sysinternal's Process Explorer</a> to discover the offending program.

HTH,
Clay

blocks|key|451254|text|我不知道这是不是一个好的答案，但是我能够通过在标识为“本地系统”的AppDomain下运行我的应用程序来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451255|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I don't know if it's a good answer, but I was able to solve this problem by running my application under an AppDomain with an identity of "Local System".

blocks|key|233321|text|NuGet的多体系结构(x86、x64)版本的SQLite的默认安装显示了您所描述的行为。如果您希望加载.NET运行时为在您的计算机上运行应用程序而选择的实际体系结构的正确版本，则可以提示DLL加载程序在何处找到正确的库，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233322|在Program.Main()之前添加对SetDLLDirectory()的kernel32.dll函数调用的声明：|233323|++++[System.Runtime.InteropServices.DllImport("kernel32.dll",+CharSet+=+System.Runtime.InteropServices.CharSet.Unicode,+SetLastError+=+true)]
++++[return:+System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.Bool)]
++++static+extern+bool+SetDllDirectory(string+lpPathName);|code-block|syntax|javascript|233324|然后使用您自己的方法确定正确的子目录，以查找特定于体系结构的“SQLite.Interop.dll”版本。我使用以下代码：|233325|++++[STAThread]
++++static+void+Main()
++++{
++++++++int+wsize+=+IntPtr.Size;
++++++++string+libdir+=+(wsize+==+4)?"x86":"x64";
++++++++string+appPath+=+System.IO.Path.GetDirectoryName(Application.ExecutablePath);
++++++++SetDllDirectory(System.IO.Path.Combine(appPath,+libdir));|233326|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

The default installation of the multi-architecture (x86, x64) version of SQLite from NuGet exhibits the behavior that you described. If you would like to load the correct version for actual architecture that the .NET runtime chose to run your application on your machine, then you can give the DLL loader a hint about where to locate the correct library as follows:

Add a declaration for the kernel32.dll function call to SetDLLDirectory() before your Program.Main():

<pre><code> [System.Runtime.InteropServices.DllImport("kernel32.dll", CharSet = System.Runtime.InteropServices.CharSet.Unicode, SetLastError = true)]
 [return: System.Runtime.InteropServices.MarshalAs(System.Runtime.InteropServices.UnmanagedType.Bool)]
 static extern bool SetDllDirectory(string lpPathName);
</code></pre>

Then use your own method for determining the correct subdirectory to find the architecture specific version of 'SQLite.Interop.dll'. I use the following code:

<pre><code> [STAThread]
 static void Main()
 {
 int wsize = IntPtr.Size;
 string libdir = (wsize == 4)?"x86":"x64";
 string appPath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);
 SetDllDirectory(System.IO.Path.Combine(appPath, libdir));
</code></pre>

blocks|key|451299|text|这就是我如何在我的项目中修复它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451300|它正在工作，当一位同事提交他的更改时，我收到了"Unable+to+load+DLL+'SQLite.Interop.dll'“异常。|451301|与项目的.csproj文件不同，这是一个非工作版本：|451302|<ItemGroup>
+++++<Content+Include="x64\SQLite.Interop.dll"+/>
+++++<Content+Include="x86\SQLite.Interop.dll"+/>
</ItemGroup>|code-block|syntax|javascript|451303|这就是工作版本所具有的：|451304|<ItemGroup>
+++++<Content+Include="x64\SQLite.Interop.dll">
++++++++++<CopyToOutputDirectory>Always</CopyToOutputDirectory>
++++++</Content>
++++++<Content+Include="x86\SQLite.Interop.dll">
++++++++++<CopyToOutputDirectory>Always</CopyToOutputDirectory>
++++++</Content>
</ItemGroup>|451305|恢复后，我没有收到异常。DLL文件已转储到相应的Debug\x64+(etc)文件夹中。|451306|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

This is how I fixed it in my project.

It was working, and when a colleague submitted his changes, I received the "Unable to load DLL 'SQLite.Interop.dll'" exception.

Diffing the project's .csproj file, this was in the NON-WORKING version:

<pre><code>&lt;ItemGroup&gt;
 &lt;Content Include="x64\SQLite.Interop.dll" /&gt;
 &lt;Content Include="x86\SQLite.Interop.dll" /&gt;
&lt;/ItemGroup&gt;
</code></pre>

And this is what the WORKING version had:

<pre><code>&lt;ItemGroup&gt;
 &lt;Content Include="x64\SQLite.Interop.dll"&gt;
 &lt;CopyToOutputDirectory&gt;Always&lt;/CopyToOutputDirectory&gt;
 &lt;/Content&gt;
 &lt;Content Include="x86\SQLite.Interop.dll"&gt;
 &lt;CopyToOutputDirectory&gt;Always&lt;/CopyToOutputDirectory&gt;
 &lt;/Content&gt;
&lt;/ItemGroup&gt;
</code></pre>

After reverting back, I didn't receive the exception. The DLL files were dumped in the appropriate Debug\x64 (etc) folders.

blocks|key|233357|text|我正在开发一个简单的控制台应用程序，以便将一些测试数据添加到SQLite数据库中，并收到此错误。项目的配置是“任意CPU”。我通过将SQLite.Interop.dll复制到bin\debug文件夹修复了这个问题。更好的方法是使用@Wil的方法，但是如何为“任何CPU”配置指定这个方法呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233358|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I am working on a simple console application to add some test data to an SQLite database and was getting this error. The configuration for the project is "Any CPU". I fixed it by copying the SQLite.Interop.dll to the bin\debug folder. A better way would be to use the method by @Wil, but how do you specify this for "Any CPU" configuration?

blocks|key|451340|text|如果您尝试在64位项目中运行32位dll，也可能出现此错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451341|当我将相同的文件(+32位版本的SQLite.Interop.dll)放在x86和x64文件夹中时，我得到了这个。|451342|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You could also get this error if you are trying to run a 32 bit dll, in a 64 bit project. 

I got this when I have placed the same file(SQLite.Interop.dll in 32 bit version) in both the x86 and x64 folder.

blocks|key|451372|text|即使这是一个老帖子，我也想分享我在这里找到的解决方案：http://system.data.sqlite.org/index.html/info/54e52d4c6f|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|451373|如果您不想读取所有问题，解决方案是将文件"msvcr100.dll“(可以在WindowsSystem32目录中找到)复制到与SQLite.Interop.dll相同的路径中。|451374|我建议阅读这个问题以了解原因，并将该文件包括在您的设置中，但只有在出现错误时才安装它，我将其设置为可在设置选项中选择的可选组件。|451375|HTH，Formentz|451376|entityMap|0|LINK|mutability|MUTABLE|url|http://system.data.sqlite.org/index.html/info/54e52d4c6f^0|R|1K|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]]]

even if it is an old post, I'd like to share the solution that I found here:
<a href="http://system.data.sqlite.org/index.html/info/54e52d4c6f" rel="noreferrer">http://system.data.sqlite.org/index.html/info/54e52d4c6f</a>

If you don't want to read all the issue, the solution is to copy the file "msvcr100.dll" (that can be found in Windows\System32 directory) in the same path as SQLite.Interop.dll.

I would advice to read the issue to understand why, and to include the file in your setup but to install it only if the error occurs, I made it an optional component selectable in the setup options.

HTH,
Formentz

blocks|key|233442|text|我在一个多项目解决方案中遇到了类似的问题。对于使用ClickOnce的软件分发的一个插件，SQLite.Interop.dll是必需的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233443|就在visual+studio中进行调试而言，一切工作正常，但是部署版本缺少包含该DLL的x86/和x64/文件夹。|233444|使用ClickOnce在部署后使其工作的解决方案是在解决方案的启动项目(也是发布的那个)中创建这两个子文件夹，将DLL复制到其中，并将它们设置为始终内容副本。|233445|这样，ClickOnce发布工具会自动在清单中包含这些文件和文件夹，并使用它们部署软件|233446|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I had a similar issue in a multiple projects solution. The SQLite.Interop.dll was necessary for one of the plugins distributed with the software using ClickOnce.

As far as debugging in visual studio everything worked fine, but the deployed version was missing the folders x86/ and x64/ containing that DLL.

The solution to have it work after deployment using ClickOnce was to create in the startup project of the solution (also the one being published) these two subfolder, copy into them the DLLs and set them as Content Copy Always.

This way the ClickOnce publishing tool automatically includes these files and folders in the manifest and deploys the software with them

blocks|key|233506|text|我在运行Visual+Studio+Express+2013时也遇到了同样的问题。我尝试了这里和其他地方提到的几种解决方案，但都没有效果。我希望这个修复对其他人有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233507|我在测试基于SQLite的服务的测试类上使用DeploymentItem+attribute修复了这个问题。|offset|length|style|CODE|233508|示例：|233509|[TestClass]
[DeploymentItem(@"x86\SQLite.Interop.dll",+"x86")]+//+this+is+the+key
public+class+LocalStoreServiceTests
{

++++[TestMethod]
++++public+void+SomeTestThatWasFailing_DueToThisVeryIssue()
++++{
+++++++++//+...+test+code+here
++++}
}|code-block|syntax|javascript|233510|这会导致将所需的SQLite.Interop.dll复制到相应"TestResults“文件夹中的x86目录中。|233511|一切都是绿色的。一切都很好。|233512|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.unittesting.deploymentitemattribute.aspx^0|0|M|E|M|O|0|0|0|0|8|I|1D|3|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@$D|14|E|15|1|16]]|A|$]]|$1|H|3|I|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|19|8|@$D|1A|E|1B|F|G]|$D|1C|E|1D|F|G]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

I had the same issue running Visual Studio Express 2013. I tried several solutions mentioned here and elsewhere to no avail. I hope this fix helps others.

I fixed it by using the <a href="http://msdn.microsoft.com/en-us/library/microsoft.visualstudio.testtools.unittesting.deploymentitemattribute.aspx"><code>DeploymentItem</code> attribute</a> on my test class that tests the SQLite-based service.

Example:

<pre><code>[TestClass]
[DeploymentItem(@"x86\SQLite.Interop.dll", "x86")] // this is the key
public class LocalStoreServiceTests
{

 [TestMethod]
 public void SomeTestThatWasFailing_DueToThisVeryIssue()
 {
 // ... test code here
 }
}
</code></pre>

This causes the needed <code>SQLite.Interop.dll</code> to get copied to the <code>x86</code> directory within the appropriate "TestResults" folder.

All is green. All is good.

blocks|key|233545|text|任何关注这个问题的人都可以参考：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233546|如果您使用nuget包，它会安装一个构建规则，为您执行复制。(参见System.Data.SQLite.Core.1.0.94.0\build+-或您安装的任何Core版本)。|233547|nuget安装程序会自动将规则添加到项目文件中。|233548|但是，这仍然不能解决测试用例问题。DeploymentItem+(https://stackoverflow.com/a/24411049/89584)方法似乎是唯一有效的方法。|offset|length|233549|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/24411049/89584^0|0|0|0|X|16|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

For reference for anyone looking at this question:

If you use the nuget package, it installs a build rule that does the copying for you. (see under System.Data.SQLite.Core.1.0.94.0\build - or whatever version of Core you install).

The nuget installer adds the rule to your project file automatically.

This still doesn't fix the test case problem though. The DeploymentItem (<a href="https://stackoverflow.com/a/24411049/89584">https://stackoverflow.com/a/24411049/89584</a>) approach is the only thing that seems to work there.

blocks|key|233590|text|我遇到这个问题是因为我使用的dll将Sqlite作为依赖项(在NuGet中仅使用Sqlite核心包进行配置)。该项目编译并复制除'SQLite.Interop.dll‘(+x86和x64文件夹)之外的所有Sqlite+dll-s。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233591|解决方案非常简单:只需将System.Data.SQLite.Core包作为依赖项(使用NuGet)添加到您正在构建/运行的项目中，dll-s就会被复制。|233592|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had this problem because a dll I was using had Sqlite as a dependency (configured in NuGet with only the Sqlite core package.). The project compiles and copies all the Sqlite dll-s except the 'SQLite.Interop.dll' (both x86 and x64 folder).
The solution was very simple: just add the System.Data.SQLite.Core package as a dependency (with NuGet) to the project you are building/running and the dll-s will be copied.

blocks|key|451588|text|我有这个问题是因为Visual+C%2B%2B+2010+redistributable没有安装在我的PC.if中你还没有安装Visual+c%2B%2B+2010+redistributable+Download并安装这个(检查x86或64dll)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|451589|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=5555^0|2J|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I had this problem because Visual C++ 2010 redistributable no installed in my PC.if you have not already installed Visual c++ 2010 redistributable <a href="http://www.microsoft.com/en-us/download/details.aspx?id=5555" rel="nofollow">Download</a> and install this(check x86 or 64 dll).

blocks|key|233680|text|我在一个包含WebAPI/MVC5+web项目和功能测试项目的解决方案中遇到了这个问题，这两个项目都来自相同的数据访问(或“核心”)项目。我和这里的许多人一样，正在使用通过Visual+Studio2013中的NuGet下载的副本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233681|我所做的是，在Visual+Studio中将x86和x64解决方案文件夹添加到Feature+Test和Web项目中。然后，我执行了一个Right+Click+%7C+Add+Existing+Item...，并从..\SolutionFolder\packages\System.Data.SQLite.Core.1.0.94.0\build\net451\[appropriate+architecture]为每个文件夹添加了适当的SQLite.interop.dll库。然后，我执行了一个Right+Click+%7C+Properties，并将Copy+to+Output+Directory设置为Always+Copy。下一次我需要运行功能测试时，测试运行成功。|offset|length|style|CODE|233682|entityMap^0|0|1W|Y|2X|2R|6T|O|7K|O|8B|B|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]|$D|R|E|S|F|G]|$D|T|E|U|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$]]

I ran across this problem, in a solution with a WebAPI/MVC5 web project and a Feature Test project, that both drew off of the same data access (or, 'Core') project. I, like so many others here, am using a copy downloaded via NuGet in Visual Studio 2013.

What I did, was in Visual Studio added a x86 and x64 solution folder to the Feature Test and Web Projects. I then did a <code>Right Click | Add Existing Item...</code>, and added the appropriate SQLite.interop.dll library from <code>..\SolutionFolder\packages\System.Data.SQLite.Core.1.0.94.0\build\net451\[appropriate architecture]</code> for each of those folders. I then did a <code>Right Click | Properties</code>, and set <code>Copy to Output Directory</code> to <code>Always Copy</code>. The next time I needed to run my feature tests, the tests ran successfully.

blocks|key|233693|text|因为这个问题很复杂，所以我想在这里发帖。我的解决方案是回滚到.Net+4.0。我已经测试了3天，还没能让System.Data.SQLite.Core.1.0.98.0与.Net+4.5或.Net+4.5.1一起工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233694|在3台计算机、2台服务器和1台开发PC上进行了详尽的测试。我还没能找到问题的根源。我已尝试编辑.vsproj文件。实际上，我已经将SQLite.interop.dll添加到所有文件夹中。我已经将该包应用于所有GAC文件夹，并单独删除和重新应用。最终被移除。|233695|我的System.Data.SQLite.Core.1.0.98.0可以与.Net+4.0一起使用。我打算继续尝试迁移，但我想我会先启动一个新项目，看看是否能让它以这种方式工作。这最初是一个.Net+3.5+web应用程序，在我的旅行中，我发现了大量仍然引用该框架的信息。|233696|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I wanted to posted here because of the complexity of this problem. My solution was to roll back to .Net 4.0. I have been testing for 3 days and have not been able to get System.Data.SQLite.Core.1.0.98.0 to work with .Net 4.5 or .Net 4.5.1.

The testing was exhaustive on 3 computers, 2 servers one dev PC. I have not been able to get to the source of the issue. I have tried editing the .vsproj file. I have added the SQLite.interop.dll to all folders practically. I have applied the package to all GAC folders, and removed and reapplied individually. Eventually removed. 

I do have System.Data.SQLite.Core.1.0.98.0 working with .Net 4.0. I intend to continue to attempt the migration, but I think I will start a new project first and see if I can get it to work in that fashion. This was originally a .Net 3.5 web app, and in my travels I found a good amount of information still referencing that framework.

blocks|key|451621|text|我的也不适用于单元测试，而且出于某种原因，Michael+Bromley关于DeploymentItem属性的回答也不适用。但是，我使用测试设置使其正常工作。在VS2013中，将新项添加到解决方案中，搜索“设置”，然后选择“测试设置”模板文件。将其命名为"SqliteUnitTests“或其他名称，然后打开它。选择右侧的"Deployment“，然后添加Directory/File。将路径/目录添加到SQLite.Interop.dll文件。对于我，我添加了两个路径，分别用于Project\bin\Debug\x64和Console\bin\Debug\x86。您可能还想添加Sqlite文件，这取决于您期望您的单元测试/解决方案访问该文件的方式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451622|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Mine didn't work for unit tests either, and for some reason Michael Bromley's answer involving DeploymentItem attribute didn't work. However, I got it working using test settings. In VS2013, add a new item to your solution and search for "settings" and select the "Test Settings" template file. Name it "SqliteUnitTests" or something and open it. Select "Deployment" off to the right, and add Directory/File. Add paths/directories to your SQLite.Interop.dll file. For me, I added two paths, one each for Project\bin\Debug\x64 and Console\bin\Debug\x86. You may also want to add your Sqlite file, depending on how you expect your unit test/solution to access the file.

blocks|key|233737|text|在构建之前，尝试将平台目标设置为x86或x64+(而不是任何CPU)：在Visual+Studio中，项目->属性->构建->平台目标。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|233738|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Try to set the platform target to x86 or x64 (and not Any CPU) before you build:
Project->Properties->Build->Platform target in Visual Studio.

blocks|key|233769|text|从Tools+->+Extension+and+updates更新NuGet并使用PM>+Update-Package+-reinstall+System.Data.SQLite.Core命令重新安装SQLite.Core为我修复了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|233770|entityMap^0|1|U|15|1H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Updating NuGet from <code>Tools -&gt; Extension and updates</code> and reinstalling SQLite.Core with the command <code>PM&gt; Update-Package -reinstall System.Data.SQLite.Core</code> fixed it for me.

blocks|key|451677|text|在项目目录中复制SQLite.Interop.dll。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451678|src\
++project\
++++++bin\+++<--+Past+in+bin
+++++++++x64\
+++++++++++SQLite.Interop.dll+<--+Copy+this+if+64
+++++++++x86\
+++++++++++SQLite.Interop.dll+<--+Copy+this+if+32|code-block|syntax|javascript|451679|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Copy SQLite.Interop.dll in project directory.

<pre><code>src\
 project\
 bin\ &lt;-- Past in bin
 x64\
 SQLite.Interop.dll &lt;-- Copy this if 64
 x86\
 SQLite.Interop.dll &lt;-- Copy this if 32
</code></pre>

blocks|key|451726|text|我为此挣扎了很长一段时间，偶尔，我发现测试设置是不正确的。如下图所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451727|📷|atomic|offset|length|451728|​|451729|我只需取消选中测试设置，问题就会消失。否则，将发生异常。希望这能对某些人有所帮助。不确定是不是根本原因。|451730|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/fdc02668407d0f44bb6b7984fd810ab1.png|imageAlt^0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@$E|V|F|W|1|X]]|A|$]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R|S|-4]]]]

I've struggled with this for a long time, and, occasionally, I found that the test setting is incorrect. See this image:
<img src="https://i.stack.imgur.com/OWSxH.png" alt="Test setting">

I just uncheck the test setting, and the issue disappears. Otherwise, the exception will occurs.
Hopefully, this will help someone.
Not sure it's the root cause.

blocks|key|451771|text|将x86和x64的"SQLite.Interop.dll“文件复制到调试文件夹中。这些文件应该复制到调试文件夹中的"x86“和"x64”文件夹中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451772|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Copy "SQLite.Interop.dll" files for both x86 and x64 in debug folder. these files should copy into "x86" and "x64 folders in debug folder.

blocks|key|233944|text|正如SQLite+wiki所说，您的应用程序部署必须：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|233945|​|233946|📷|atomic|233947|233948|所以你需要遵守规则。找到与您的目标平台匹配的dll，并将其放置在图片中描述的位置。Dlls可在YourSolution/packages/System.Data.SQLite.Core.%25version%25/.中找到|233949|我在部署应用程序时遇到了问题，所以我只是在我的项目中添加了right+SQLite.Interop.dll，在setup项目中添加了x86文件夹到AppplicationFolder，并添加了对dll的文件引用。|233950|entityMap|0|LINK|mutability|MUTABLE|url|https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1bcb7edf0d78a1d2a2fb67774ddac37c.png|imageAlt^0|2|B|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|6|7|15|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|16|8|@]|9|@$A|17|B|18|1|19]]|C|$]]|$1|I|3|E|5|6|7|1A|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1B|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1C|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]|V|$5|W|R|X|C|$Y|Z|10|-4]]]]

As the <a href="https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki" rel="noreferrer">SQLite wiki</a> says, your application deployment must be:

<a href="https://i.stack.imgur.com/YJJca.png" rel="noreferrer"><img src="https://i.stack.imgur.com/YJJca.png" alt="Application deployment"></a>

So you need to follow the rules. Find dll that matches your target platform and put it in location, describes in the picture. Dlls can be found in YourSolution/packages/System.Data.SQLite.Core.%version%/. 

I had problems with application deployment, so I just added right SQLite.Interop.dll into my project, the added x86 folder to AppplicationFolder in setup project and added file references to dll.

blocks|key|451855|text|因此，在添加NuGet之后，部署不会向下复制互操作。您可以将此代码添加到您的csproj文件中，它应该会修复该行为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|451856|+<PropertyGroup>+
++++<ContentSQLiteInteropFiles>true</ContentSQLiteInteropFiles>
++++<CopySQLiteInteropFiles>false</CopySQLiteInteropFiles>
++++<CleanSQLiteInteropFiles>false</CleanSQLiteInteropFiles>
++++<CollectSQLiteInteropFiles>false</CollectSQLiteInteropFiles>
+</PropertyGroup>|code-block|syntax|javascript|451857|如果你查看SQLite的NuGet源代码，你会发现它们具体在做什么。这使我能够使用ASP.Net核心进行部署。|451858|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

So, after adding the NuGet the deployment doesn't copy down the Interops. You can add this to your csproj file and it should fix that behavior:

<pre><code> &lt;PropertyGroup&gt; 
 &lt;ContentSQLiteInteropFiles&gt;true&lt;/ContentSQLiteInteropFiles&gt;
 &lt;CopySQLiteInteropFiles&gt;false&lt;/CopySQLiteInteropFiles&gt;
 &lt;CleanSQLiteInteropFiles&gt;false&lt;/CleanSQLiteInteropFiles&gt;
 &lt;CollectSQLiteInteropFiles&gt;false&lt;/CollectSQLiteInteropFiles&gt;
 &lt;/PropertyGroup&gt;
</code></pre>

If you look in the source for NuGet for SQLite you can see what these are doing specifically. This allowed me to get a deploy working with ASP.Net Core.

blocks|key|234019|text|还将dll添加到测试项目中(通过Nuget+Manager)，并修复了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|234020|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Also added the dll to the test project (through Nuget Manager) and it fixed it.

blocks|key|234047|text|只为我工作:包管理器控制台上的Install-Package+System.Data.SQLite.Core。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|234048|entityMap^0|F|13|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Just worked this for me : <code>Install-Package System.Data.SQLite.Core</code> on Package Manager Console.

blocks|key|451958|text|正在升级到Visual+Studio+2019版本。16.10导致了我的问题，其中msbuild为System.Data.SQLite.Core-package报告了以下内容：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|451959|CopySQLiteInteropFiles:
Skipping+target+"CopySQLiteInteropFiles"+because+it+has+no+outputs.|code-block|syntax|javascript|451960|https://github.com/dotnet/msbuild/issues/6493|451961|微软表示，该漏洞已通过版本修复。16.10.4。现在只需等待AppVeyor更新他们的Visual+Studio图像(在此之前，人们可以使用Previous+Visual+Studio+2019)。|451962|现在AppVeyor对当前和以前的Visual+Studio2019-image都使用了损坏的dotnet-build-engine。现在必须显式安装dotnet+sdk版本。5.0.302：|451963|Invoke-WebRequest+-Uri+'https://dot.net/v1/dotnet-install.ps1'+-UseBasicParsing+-OutFile+"$env:temp/dotnet-install.ps1";+&+$env:temp\dotnet-install.ps1+-Architecture+x64+-Version+5.0.302+-InstallDir+"$env:ProgramFiles\dotnet"|451964|entityMap|0|LINK|mutability|MUTABLE|url^0|1D|N|0|0|0|19|0|0|1Y|R|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|13|8|@]|D|@$9|14|A|15|1|16]]|E|$]]|$1|M|3|N|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1A|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1B|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|L]]]]

Upgrading to Visual Studio 2019 ver. 16.10 caused the issue for me, where msbuild reported the following for the <code>System.Data.SQLite.Core</code>-package:
<pre><code>CopySQLiteInteropFiles:
Skipping target &quot;CopySQLiteInteropFiles&quot; because it has no outputs.
</code></pre>
<a href="https://github.com/dotnet/msbuild/issues/6493" rel="nofollow noreferrer">https://github.com/dotnet/msbuild/issues/6493</a>
Microsoft says the bug has been fixed with ver. 16.10.4. Now just have to wait for AppVeyor to update their Visual Studio Images (Until then one can use <code>Previous Visual Studio 2019</code>).
Now AppVeyor is using broken dotnet-build-engine for both current and previous Visual Studio 2019-image. Now one have to explicit install dotnet sdk ver. 5.0.302:
<pre><code>Invoke-WebRequest -Uri 'https://dot.net/v1/dotnet-install.ps1' -UseBasicParsing -OutFile &quot;$env:temp/dotnet-install.ps1&quot;; &amp; $env:temp\dotnet-install.ps1 -Architecture x64 -Version 5.0.302 -InstallDir &quot;$env:ProgramFiles\dotnet&quot;
</code></pre>

blocks|key|234142|text|我在这里尝试了几乎所有的解决方案，但没有任何运气。最后，通过将与我选择的平台对应的SQLite.Interop.dll的副本直接放在我的安装项目的根目录下，最终解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|234143|我不知道为什么它有效，但它确实有效。|234144|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I tried pretty much all of the solutions here without any luck. Finally solved it by putting a copy of the SQLite.Interop.dll corresponding to my selected platform directly under the root of my setup project.
I have no idea why it worked but it did.

blocks|key|452057|text|超过30个答案，但我用一种不同的方式解决了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|452058|我有两个独立的项目。Windows服务和Windows窗体应用程序。应用程序引用WS项目，两者都引用SQLite+Core+nuget包。|452059|在构建WS项目时，x64和x32文件夹都在那里。但在构建应用程序时，文件夹不会显示出来。|452060|检查这里的答案，我不能让它们工作。但我发现以下代码片段存在于WS项目中，而在App项目中缺失。我添加了它，文件夹现在可以正确显示了。|452061|<Import+Project="..\packages\System.Data.SQLite.Core.1.0.112.0\build\net46\System.Data.SQLite.Core.targets"+Condition="Exists('..\packages\System.Data.SQLite.Core.1.0.112.0\build\net46\System.Data.SQLite.Core.targets')"+/>|code-block|syntax|javascript|452062|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Over 30 answers, and yet I solved it in a different way.
I had 2 separate projects. A Windows Service, and a Windows Forms app. The App references the WS project, and both reference the SQLite Core nuget package.
When building the WS project, the x64 and x32 folders are there. But when building the App, the folders don't show up.
Checking the answers here, I couldn't make them work. But I figured out that the following snippet was present in the WS project, and was missing in the App project. I added it, and the folders now show up correctly.
<pre><code>&lt;Import Project=&quot;..\packages\System.Data.SQLite.Core.1.0.112.0\build\net46\System.Data.SQLite.Core.targets&quot; Condition=&quot;Exists('..\packages\System.Data.SQLite.Core.1.0.112.0\build\net46\System.Data.SQLite.Core.targets')&quot; /&gt;
</code></pre>

blocks|key|234204|text|我发现当我允许Nuget更新SQLite到1.0.115.5时，我的项目不再需要'SQLite.Interop.dll‘。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|234205|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I found that when I allowed Nuget to update SQLite to 1.0.115.5 my project no longer needed the 'SQLite.Interop.dll'.

Periodically I am getting the following exception:

<code>Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)</code>

I am using 1.0.82.0. version, installing it with nuget in VS2010, OS Win7 64.

Once exception starts to appear, it appears constantly - in debug and release and running application within or outside VS.

The only way to stop it is logoff and logon. The exception is not thrown and dll is loaded.
It can work for days, but then it can break again. 

Has anyone seen something like this and is there a solution for it?

Unable to load DLL 'SQLite.Interop.dll'

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我会定期收到以下异常：Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)我使用的是1.0.82.0。版本，使用nuget在VS2010...

问无法加载DLL 'SQLite.Interop.dll‘
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法加载DLL 'SQLite.Interop.dll‘EN