This question is locked. New answers and comments are not allowed.
Hello, I'm having some problems when I try to trace the SQL statements sent to my SQLite database. I use an OpenAccessContext derived class defined in a separate assembly which is instantiated in a class constructor and disposed in the method Dispose of my class. If I use a StringWriter (as stated in the documentation), nothing happens (the instance of StringWriter.ToString() is just empty). If I enable logging in the model, the problem is the same: nothing is logged in the Profiler and Tuning Advisor (even if I regularly connect to the database in the Advisor and I call the StartProfilerService in the bootstrapper of my app) . I also have to say that the connection string to the database is dynamically passed to the constructor of the OpenAccessContext derived class (I don't use a fixed connection string in the App.config). How can I solve this problem? What's wrong with this approach?
Thanks in advance
Fabio
Thanks in advance
Fabio