My device is running Windows CE .NET 4.2 Core, which doesn't support Microsoft .NET Compact Framework 2.0. The latest version it can use is 1.0 SP3. The program I want to create is supposed to read a SQLite table and update and delete some rows in that table. Is there a way I can still use Basic4PPC to create my program?
You want be able to do it with Basic4ppc or Visual Studio. The .Net SQLite wrapper requires .Net CF 2.0.
Well ... in Visual Studio one can use the Finisar ADO.NET Data Provider for SQLite (http://sourceforge.net/projects/adodotnetsqlite/). Though the project is no longer under active development it does work. But the learning curve and cost of Visual Studio are too steep for me and my simple one-time development
When I wrote the SQL library I thoroughly tested this project (because it doesn't require .Net CF 2.0). As this is an inactive project and it is not a stable one I decided that it will be a mistake to use it.