Tag Archives: Sqlite

SQLite WARNING: Type mapping failed

Posted on August 10, 2015 by erictummers

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

Posted on November 12, 2012 by erictummers

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

Posted on March 21, 2012 by erictummers

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

Posted on March 4, 2011 by erictummers

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