Hi Gene,
report as promised...
The exception is attached.
Setup for completeness:
win 7 pro 32 bits
VS2013Community
svn checkout into empty folder
start windows solution
build all
=========================
Checking HomeGenie\bin\debug
System.Data.SQLite.dll is present (version 1.0.85.0)
Checking HomeGenie\bin\debug\x86
SQLite.Interop.dll is present (version 1.0.85.0) (821,760 bytes)
Checking HomeGenie\bin\debug\x64
SQLite.Interop.dll is present (version 1.0.85.0) (1,064,960 bytes)
=========================
Run homegenie and the attached exception is thrown.
SHIFT-F5 to stop it.
Run again and everything is fine and stays fine.
=========================
Checked the same files as I did before and nothing changed.
Checked all files in the HomeGenie\bin\debug and subfolders.
No files are added.
=========================
It really some SQLLite thing, the exception takes place when HomeGenie.Service.Logging.StatisticsLogger.OpenStatisticsDatabase() is called.
The call causes the CLR to load SQLite.Interop.dll since it uses SQLiteConnection
Things I didn't try:
Updating to the latest SQLite 1.0.94.1
or dowgrading to the 1.0.66.0 (that's obviously for the RPi)
I didn't try to use filemonitor or other low level tools to find out what's missing the first time.
Don't know a lot of SQLite and google is full of issues on this problem.
Gene, if you want me to dig deeper, just tell.
I can perfectly live with this small issue. (The workaround is so easy)
regards,
Wibo.