phxsoftware

System.Data.Sqlite FormatException using a parameter with LIKE

I'm using Sqlite as my database of choice in a C# forms app, with http://sqlite.phxsoftware.com/ System.Data.SQLite provider. I'm trying to implement a search function, but it's not playing nice... or I'm missing something. The simplified sql I'm using looks like this: SELECT * FROM Table WHERE column LIKE @boundParameter ESCAPE '!' ...

sqlite - any improvements for this attach code (running multiple sql commands transactionally in sqlite)

Hi, Is this code solid? I've tried to use "using" etc. Basically a method to pass as sequenced list of SQL commands to be run against a Sqlite database. I assume it is true that in sqlite by default all commands run in a single connection are handled transactionally? Is this true? i.e. I should not have to (and haven't got in the...

dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? ...