----------
2019-06-13

?????????????

重點:

標示   適用環境 開發環境 執行環境 C++ Runtime Library SQLite.dll 舊版
------ ------------------- ---------- -------
binary 開發環境
static         包含                 
setup          包含且嘗試自動安裝.
bundle                     包含       建議使用

?????????????

標示"staitic"的安裝包, 含有 natice 或 mixed-mode 組件連結到對應的 Visual C++ 執行環境. 通常使用於沒有安裝或無法安裝 Visual C++ 執行環境的客戶端.
標示"bundle"文字的安裝包, 都包含 System.Data.SQLite.dll 執行檔. 適用於要安裝於共用  Global Assembly Cache 的舊版的執行環境. 

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
https://www.sqlite.org/index.html


Runtime Library Notes 
All downloadable packages on this web page that do not include the word "static" in their file name require the appropriate version (e.g. 2005, 2008, 2010, 2012, 2013, 2015, 2017) of the Microsoft Visual C++ Runtime Library, to be successfully installed on the target machine, prior to making use of the executables contained therein. It should also be noted that the downloadable packages on this web page that include the word "setup" (i.e. the setup packages) already include and will attempt to automatically install the required version of the Microsoft Visual C++ Runtime Library. 
若下載的安裝包名稱沒有標示"static"標示的話, 則代表執行環境, 必須自行安裝對應的 Microsoft Visual C++ Runtime Library.
若下載的安裝包名稱    標示"setup" 標示的話, 則代表已包含所需的 Microsoft Visual C++ Runtime Library, 會嘗試自動安裝.


Latest Microsoft Visual C++ Runtime Library Downloads 
For detailed information about the latest downloads for each Microsoft Visual C++ Runtime Library release, please refer to the following page: 
Latest Supported Visual C++ Downloads 
https://support.microsoft.com/kb/2019667
最新的 Microsoft Visual C++ Runtime Library 可從以上連結下載.
  
Support Notes - Downloadable Packages 
This page contains all the downloadable packages (e.g. sources, binaries, setups, etc) for the current release version of the official "System.Data.SQLite" project. This page and the associated NuGet packages are the only official distribution points for these downloadable packages. If any of the downloadable packages are obtained elsewhere, it is very important to compare their SHA1 hashes to the corresponding hashes listed below in order to make sure the contained files are the same. 
System.Data.SQLite 專案 官網以本網頁 及 https://www.nuget.org/profiles/SQLite 為準. 若從他處取得相同的檔案, 請比對本頁中的 SHA1 雜湊值是否相符.

Support Notes - Other Projects 
There are several other projects, with widely varying levels of support and compatibility, known to use the similar names. At least one of those projects is an unofficial fork of the legacy 1.0.66.0 release, modified (by a third-party) to work with Visual Studio 2010 (or higher). Only the software contained on this page is directly supported by the maintainers of this project (i.e. the SQLite Development Team) as we do not necessarily have any knowledge of the other projects that use the same (or a similar) name. That being said, if a particular question is related to the core SQLite native library itself, one of the SQLite support options is probably the best way to get an answer. 


Windows Embedded Compact 
The Precompiled Binaries for Windows CE (.NET Compact Framework) section of this page contains several binary packages for Windows Embedded Compact 2013. Further information on integrating SQLite into Windows Embedded Compact 2013 can be found at the following web site: 
SQLite for Windows Embedded Compact 2013 
  
Release Notes 
The "release notes", which contain lists of notable changes associated with each officially released version, is available on the News page.
 
Package Types 
There are a wide variety of downloadable packages on this page. Each of them is designed to meet the requirements of a particular development and/or deployment scenario. 
本網頁中各種不同的安裝包, 可依據不同的開發需求或分派情境, 選擇下載使用.

The first step is to determine if the package is to be installed (or used) on a developer machine or a customer machine. 
首先, 要先判斷是要安裝在開發環境, 還是客戶的執行環境 ?

  The source packages are intended primarily for people interested in studying the source code that corresponds to a particular release version of the project. The source packages contain no binaries. Those interested in studying the latest source code and/or tracking the unreleased changes should consider accessing the Fossil repository instead. 
  原始碼安裝包主要是提供給開發人員使用. 不包含執行檔. 有興趣研究原始碼或追蹤將完成的變更者, 可到 http://system.data.sqlite.org/index.html/timeline?n=20&y=ci 查詢.

  The setup packages are intended to be installed only on developer machines and then only when the design-time components for Visual Studio are required. In theory, they can be installed on customer machines as well; however, this type of deployment is not recommended. 
  標示"setup"文字的安裝包, 僅適用於開發環境, 也僅適用於Visual Studoi 設計時. 理論上也可以安裝在客戶的執行環境上, 但是不建議。

  The binary packages are intended to be used by developers in order to obtain the assembly binaries necessary for development and deployment of their applications onto customer machines via XCOPY deployment. 
  標示為"binary"文字的安裝包, 適用於開發環境所需要的執行檔, 可經由 XCOPY 指令分派到客戶的執行環境. 
  
All the "bundle" packages contain the "System.Data.SQLite.dll" mixed-mode assembly. These packages should only be used in cases where the assembly binary must be deployed to the Global Assembly Cache for some reason (e.g. to support some legacy application on customer machines). 
標示"bundle"文字的安裝包, 都包含 System.Data.SQLite.dll 執行檔. 適用於要安裝於共用  Global Assembly Cache 的舊版的執行環境. 

All the "static" packages contain either native or mixed-mode assembly binaries linked statically to the appropriate version of the Visual C++ runtime. Typically, these packages are used in cases where customer machines may not have the necessary version of the Visual C++ runtime installed and it cannot be installed due to limited privileges. 
標示"staitic"的安裝包, 含有 native 或 mixed-mode 組件連結到對應的 Visual C++ 執行環境. 通常使用於沒有安裝或無法安裝 Visual C++ 執行環境的客戶端.

The next step is to identify the version of the .NET Framework being targeted by the application. Generally, assembly binaries linked against the .NET Framework 2.0 (or the .NET Framework 3.5) will work with the .NET Framework 4.0 (or higher); however, this is less than ideal. Furthermore, assemblies linked against the .NET Framework 4.0 (or higher) cannot be loaded by any versions of the .NET Framework prior to 4.0. 
其次, 應確認 .NET Framework 的版本. 通常連結到版本 2.0 以上的組件, 可於版本 4.0 以上執行, 但這並非最佳組合. 反之, 連結到版本 4.0 的組件, 則無法於較低的版本環境中載入執行.


Using Native Library Pre-Loading 
The final step is to identify the target processor architecture on both the development and customer machines. Generally, x86 binaries will work on an x64 machine running Windows (using WoW64). However, there is a problem when using managed code. If the executable that starts the process consists entirely of managed code, it will run with the native processor architecture of the machine, which will be x64 on an x64 machine. Later on, this will cause assemblies containing any native code compiled for x86 (e.g. the "System.Data.SQLite.dll" mixed-mode assembly, the "SQLite.Interop.dll" native interop assembly, or the "sqlite3.dll" native library) to fail to load, typically resulting in a BadImageFormatException being thrown. 
最後要確認的是, 開發環境以及客戶環境的電腦處理器. 通常 x86 執行檔可在 x64 電腦中執行. 但是使用 Managed Code 時有一個問題: 若啟動執行時, 組件 Managed Code與處理器一致, 則會由機器本身的處理器執行, 即 x64 組件在 x64 處理器執行, 後續則將因此無法載入 x86 的組件, 並產生 BadImageFormatException 錯誤.

If the development and customer machines may have different processor architectures, more than one binary package may be required. For this situation, using the native library pre-loading feature is highly recommended. It is available as of version 1.0.80.0 and enabled by default. In order to take advantage of this feature, the separate managed and interop assemblies must be used with XCOPY deployment (i.e. this feature is not supported by the mixed-mode assembly, nor when the assembly is deployed to the global assembly cache), resulting in an application deployment that looks something like this: 
若開發環境跟客戶執行環境處理器不同時, 則需要同時安裝不同的安裝包.
在這種情況下, 建議採用 native library pre-loading feature 的方式, 這是在 1.0.80.0 版本之後提供的功能, 預設為啟用.
使用這種方式時, 必須分開安裝不同版本的組件, 利用 XCOPY 指令存放組件到不同的檔案目錄中, 如下範例:  
<bin>\App.exe (optional, managed-only application executable assembly) 
<bin>\App.dll (optional, managed-only application library assembly) 
<bin>\System.Data.SQLite.dll (required, managed-only core assembly) 
<bin>\System.Data.SQLite.Linq.dll (optional, managed-only LINQ assembly) 
<bin>\System.Data.SQLite.EF6.dll (optional, managed-only EF6 assembly) 
<bin>\x86\SQLite.Interop.dll (required, x86 native interop assembly) 
<bin>\x64\SQLite.Interop.dll (required, x64 native interop assembly) 
  
The string "<bin>" above represents the directory where the application binaries are to be deployed on the target machine. With the native library pre-loading feature enabled and the application deployment shown above, the System.Data.SQLite managed-only assembly will attempt to automatically detect the processor architecture of the current process and pre-load the appropriate native library. 
以上文字"<bin>" 代表執行檔的存放位置.
當啟用 native library pre-loading 功能時, System.Data.SQLite 組件將會自動偵測目前執行緒的處理器, 並預先載入適用的函式庫執行.


Advanced Configuration Settings 
If native library pre-loading feature does not work properly in your environment, it can be disabled by setting the "No_PreLoadSQLite" environment variable (i.e. to anything) prior to loading and/or using the System.Data.SQLite assembly. There are several more environment variables that can be used to influence the behavior of the native library pre-loading feature, documented here. 
若 native library pre-loading 功能失效時, 也可以利用環境變數 "No_PreLoadSQLite" 關掉此功能.
還有其他的環境變數, 可以關掉native library pre-loading 功能. 參考如下: http://system.data.sqlite.org/index.html/artifact?ci=trunk&filename=Doc/Extra/Provider/environment.html


Use of environment variables for configuration settings is not supported by the .NET Compact Framework builds of System.Data.SQLite, due to limitations imposed by the platform itself. 
.NET Compact Framework 的 System.Data.SQLite 版本, 不支援使用環境變數. 因.NET Compact Framework 本身不支援環境變數.

Alternatively, as of version 1.0.91.0, all configuration settings can be specified via an optional XML configuration file. Using the XML configuration file when the primary System.Data.SQLite assembly ("System.Data.SQLite.dll") is being executed from the Global Assembly Cache is unsupported. 
替代方法是在版本 1.0.91.0 之後, 採用 XML 檔案設定. 這種方式則不是用於安裝於共用的 Global Assembly Cache 的 System.Data.SQLite.dll.

For each configuration setting, the associated environment variable value, if present, will override the value specified via the XML configuration file. 
若環境變數與XML設定檔同時存在相同的設定時, 則以環境變數為設定結果.


For the full .NET Framework, the XML configuration file must be named "System.Data.SQLite.dll.config" and it must be present in the base directory for the application domain or the directory containing the primary System.Data.SQLite assembly as reported by its location property; otherwise, it will be ignored. 
所有版本的 .NET Framework, XML 設定檔都必須命名為"System.Data.SQLite.dll.config", 並且應存放在 1. application domain, 或 2.the directory containing the primary System.Data.SQLite assembly as reported by its location property, 否則無效.

For the .NET Compact Framework, the XML configuration file must be named "System.Data.SQLite.dll.config" and it must be present in the directory containing the primary System.Data.SQLite assembly; otherwise, it will be ignored. 
.NET Compact Framework的版本, XML 設定檔必須命名為"System.Data.SQLite.dll.config", 並且應存放在 the directory containing the primary System.Data.SQLite assembly, 否則無效.


Deployment Guidelines 
To summarize the above: 
  
Using XCOPY deployment in conjunction with the native library pre-loading feature, especially for customer machines, is highly recommended. 

Using the Global Assembly Cache (at all) is not recommended; therefore, the "bundle" packages should be avoided unless deemed absolutely necessary. 

Using the "static" assembly binaries on development machines is not recommended; therefore, the "static" packages should be avoided if all the target machines already have the Visual C++ runtime installed or it can be easily deployed beforehand. 

Choosing the package matching the version of the .NET Framework being targeted is highly recommended. 

Choosing the package matching the target processor architecture (for both development and customer machines) is almost certainly required for proper operation. Using the native library pre-loading feature should help with this. 

摘要重點:
1. 建議使用 XCOPY 在客戶的電腦上安裝需要的組件.
2. 不建議安裝組件為共用(Global Assembly Cache). 因此, 標示為"bundle"的安裝包應盡量避免使用, bundle版本適用於舊版windows 環境, 例如XP.
3. 不建議在開發環境上安裝"static"版本組件. 因此"static"安裝包應避免在已安裝 Visual C++ 元件的執行環境中使用.
4. 建議應選用對應的.NET Framework版本編號安裝包.
5. 選用正確的處理器版本是必要得步驟. 可利用 native library pre-loading 功能取得協助.