SQLite Forum

Pre-release Versions of System.Data.SQLite packages?
Yes, we are aware. The feature however allows us to translate UPDATE ... JOIN statements from Access to SQLite without having to perform individual row updates. This reduces the number of round trips to the database and improves performance. All of our SQL are in data layer objects which allow for database agnostic updates from the application's perspective. Once the SQLite implementation is complete we will replace the Access data layer with the SQLite one.