I've previously posted a few things about SQLite including a HOWTO on how to build from their source code. If you still want to build your own DLL from their source code that is totally fine, but not necessary in most every single case I've seen in app usage. One of the challenges I noted is that since SQLite is a native component and if you are a managed (.NET) app you can't be architecture neutral anymore (AnyCPU). What this means is that you have to build your app for each architecture you want to support: x86, x64 and ARM. The flow of this using SQLite3.dll was that you would have to package, change the DLL, re-package.
Not anymore.
In working with the great folks on the SQLite team, they've packaged the binaries up (for Windows 8 apps) in a nice installer using the Extension SDK format. What this m ...
Go to the complete details ...