Is there an easy to log all back-end sql for each operation?

Thread is closed for posting
2 posts, 0 answers
  1. Leon
    Leon avatar
    5 posts
    Member since:
    Jul 2008

    Posted 14 Jun 2009 Link to this post

    As the title, is there an easy to do that? For eg., put some codes in scope provider, so that we can log all back-end sql generated for each operation, logged by log4net or something else, is it doable? Thanks.
  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 15 Jun 2009 Link to this post

    Hello Leon,

    OpenAccess has its own logging mechanism, you just have to enable it. Open the OpenAccess menu -> "Configuration" -> "Backend Configuration Settings", scroll to the "Logging" section and enable "Event tracing". You can choose logging to a file, to the Output console of Visual Studio or both. If file logging is enabled, you have to specify a file name as well. The log level should be "normal" or higher to track the SQL statements.

    Sincerely yours,
    Alexander
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
Back to Top