System.Data.SQLite parseViaFramework

Question

I was using System.Data.SQLite to open some databases on a UNC path. The version in use was 1.0.82 and it worked well. When it was upgraded to 1.0.86 I suddenly started getting an error that it couldn't open the database file.

After a while I discovered that in the SQLiteConnection constructor a new parameter was added called parseViaFramework. When I set it to true everything started working again.

However there is very little information about what this parameter actually does. I could pick up that it had something to do with how the connection string was parsed, but that's as far as I could get. If I enter parseViaFramework into a google search I get only 2 pages of results.

Can anyone tell me exactly what this parameter does?

Answer 1

This addition is to allow the built-in (i.e. framework provided) connection string parser to be used when opening a connection. Apparently, this change is to solve this problem.(source)

There's another thing I have noticed myself. When using ExecuteReader, you get an "empty reader", and you need to do the first Read() yourself. I think this is due to the upgrade, as my code was working well without it before. Maybe that's another thing you need to check.