0

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.

Manuel Ferreria
  • 1,216
  • 1
  • 13
  • 23

2 Answers2

0

It seems that the answer can be a little tricky..you can see here for an explanation for SqlServer, I think that for Sqlite is the same

Community
  • 1
  • 1
Tobia Zambon
  • 7,479
  • 3
  • 37
  • 69
0

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...).

Alex Martelli
  • 854,459
  • 170
  • 1,222
  • 1,395