SQLiteDataProvider class file attached.

Passes all tests except for transactions. Transaction tests all fail due to locking in the database. SQLite will not permit multiple shared connections at the same time.

It looks like these are int he trunk yes? Lemme know.

This replaces the one in the trunk and actually works. Please compare and test the code. I have also provided the northwind database in sqlite format as another issue -- for testing. Please do a bake-off if you don't trust this information. I was not able to use the trunk version due to bugs. The new version has been in use for some time without problems. It still lacks many to many generation, as does the older version.

I've just gone through this provider again and I think I have fixed the 'database is locked' errors. To fix it, I have tried to make sure that Close() is never called on the connection. All the using blocks on the connection are removed. It is some sort of bug in the sqlite wrapper code, or a latency in the file system on releasing the file, I don't know. Anyway, 196 tests pass, 16 fail due to string comparisons or database row counts, etc. I don't have the exact database rows the tests require. The migration tests all fail, so I exclude those. The test project had to be modified for sqlite... so it's a whole big thing you probably don't want to get into. Don't use the sqlite provider I attached to this issue, it's junk now.

OK - closing this. You're on commit so add this as needed.