docs VS System.Data.SQLite

MS docs ar now on github. Licence lists "CC-BY-4 and MIT licence found" https://github.com/dotnet/docs/tree/main

Yeah, I saw that devdocs and the like don't include what was previously not cross platform and not popular for linux guys: C#, msbuild.

This ability to nest object/collection initializers is not documented TMK and if you feel it is you could update this nearly 4 year old ticket requesting it be documented: https://github.com/dotnet/docs/issues/12979 .

To be like, really pedantic, C#'s foreach will perform an implicit typecast in some scenarios, which can cause the enumeration to throw an InvalidCastException when it hits an item that can't be cast to the specified type (in this case, ShadowCaster2D).

Instead of changing environment variables to modify the DLL search locations, I wanted to see if we can somehow provide an absolute path for the DLL location. Looking at the source for the NuGet package it's clear that, as the Microsoft Docs page noted, the C# code just invokes the native code (sqlite3_load_extension()) directly. Therefore I looked at the SQLite source code. SQLite has the concept of VFS which is a portability layer at the bottom of the SQLite architecture. There are implementations of this abstraction for specific operating systems. Windows and Linux implementations are os_win.c and os_unix.c respectively. The extension loading code eventually relies on VFS implementations to load DLLs. On Linux this is handled by dlopen and it's LoadLibraryW on Windows. I later rediscovered this same information after reading the bottom (section 7) of a SQLite documentation page.