See parametric query sent to SQLite

Question

I am getting strange formatting errors while trying to update a row in SQLite through a C# wrapper. The issue is not in the wrapper, but in how I am passing the parameters to the parametric query.

Is there a way to see the SQL generated to send to the DB? I've looked up a lot but it seems it is not very common wanting this or at least, not possible.

Answer 1

In SQLite's fundamental (C) interface you could use sqlite3_trace (or sqlite3_profile, documented at the same URL) -- I'm not sure how those functions map to the C# interface though (indeed, SQLite might be specially compiled to omit them...).