Logging erros in SqlLite database from C# Windows Forms Application

Question

I'm developing a win app in C# which communicates to a WCF Service. I want to log exceptions that are thrown on client to be logged in Sql Lite Database (Win app is using Sql Lite database for storing data locally). And then later it should be sent to the wcf service when required so that it can be useful for support/analysis/application improvement.

I want a method which can be directly called in every catch block simply by LogHelper.Log(ex).

I would like to know if anyone has done it through Enterprise library or used any good practice for such situation?

Update I'm already using sql lite database for storing data locally through System.Data.SqLite library

Answer 1

You cannot directly use microsoft enterprise library with sqlite database as backend. Use System.Data.SQLite library for all database operations.

If you still want to use enterprise library check this article. Anyways you will have to install the System.Data.SQLite library. As per my experience System.Data.SQLite will be enough for all database operations.

One more word of caution, sqlite does not support concurrency. So any database operation will lock the entire datase for the duration.

Answer 2

I've written a number of blog posts on this recently. I'm sure one or the other will provide the answer that you need:

• Lightweight, Aspect-Oriented Instrumentation with PostSharp, NLog, and SQLite
• Logging to SQLite with NLog