SQLite Forum

> some more pointers, URLs, samples/worked examples

For R there's [the definitive guide][WRE]. Download the sources of whatever 
package is providing you SQLite and take it apart. Ask on R-help or R-pkg-dev 
if something breaks.

For C# and VB.NET there's [P/Invoke], so, in theory, you could declare all 
SQLite functions you are interested in as `[DllImport("sqlite.dll", ...)]` 
and supply your own `sqlite.dll`, but that's a lot of manual work that 
System.Data.SQLite is supposed to protect you from. I have never used or built 
`System.Data.SQLite` myself and I can't offer any assistance regarding that. 
Presumably, you could follow [the build procedures][SDSQL], substituting your 
own copy of SQLite and/or ask around on .NET programming forums.

[WRE]: https://cran.r-project.org/doc/manuals/R-exts.html
[P/Invoke]: https://docs.microsoft.com/en-us/dotnet/standard/native-interop/pinvoke
[SDSQL]: http://system.data.sqlite.org/index.html/doc/trunk/www/build.wiki