System.Data.SQLite

Much appreciated. Thanks.

Is it possible for your wrapper to include the SQL statement that was being run in the exception that gets thrown?  This would definately make it easier to know what the system was trying to do when things started to break.  For basic syntax errors, it makes it easy to spot without trying to reproduce the error, and for other errors the ...

When we upgrade from one binary release to the other can we just run the scripts as if it was a new install?  I wasn't sure if we needed to clean-up the older assemblies or whether the script does that for us.[edit:  I just noticed you are packaging an installer now, but I'm still curious about clean-up][edit again:  Is it possible ...

 Here is how I built my query:if (this.State == ObjectState.NewFangled) {    sql.Append (''INSERT INTO assoc VALUES (''' + Id + ''', ''');    sql.Append (Name + ''', ''' + Desc + ''', ''');    sql.Append (Parent + ''', ''' + IsActive + ''');'');   }Where IsActive returns a bool. And ...

Sorry for the delay. I'm still not convinced its a true bug - it seems like it would've been caught in your tests.DataReader.GetType() is going to return the type of the datareader object.....so I'm not clear on what you are asking.Changing my original code (posted below) to just use a datareader.GetValue (4) returns 'false'.The table schema ...

This very well could be my problem but..string blah = reader.GetString(3);blah will equal 'True'bool blah = reader.GetBoolean(3);blah will equal 'false'This is with version 1.0.25.0

Ok, that makes sense. Thank you.

I'm new to ADO .Net style programming so I'm unsure if my situation would benefit from this. I was hoping you might have some insight.I am running very similar commands of the course of the program, however they are not in a loop condition. For example, when the user makes changes to a contact's information we run a very similar ''update'' ...