Tag Archives: Sqlite

SQLite WARNING: Type mapping failed

The log of our product started showing SQLite warnings. We ignored them to focus on the release. Now it was time to repro and fix the warnings. After reading the verbose log we found the issue. Unknown datatypes are allowed … Continue reading

Posted in Development | Tagged , | Leave a comment

Run unit tests in 64-bit

Some unit tests fail since my “upgrade” to Windows 8 64 bit coming from a 32 bit installation. The exception is shown below System.BadImageFormatException: Could not load file or assembly ‘XXX SQLite’ or one of its dependencies. An attempt was … Continue reading

Posted in Test | Tagged , , , , | Leave a comment

Mono.Data.Sqlite and filelocks

While porting my projects to Mono I noticed some file locking on databases. There were no problems with the dotNET code. Seems like a difference in behavior between the two frameworks. A simple query to a Sqlite database would look … Continue reading

Posted in Development | Tagged , , , , , , | 2 Comments

EF4 and SQLite

I want to create my datalayer with Entity Framework. But I’m using SQLite as the database. How to create the database if it is a new file? First create a database to import in EF. Model first just isn’t that … Continue reading

Posted in Development | Tagged , , , , , , | 2 Comments