Posts Tagged SQL

Saturday, November 29, 2008 10:16

Sending the LINQ To SQL log to log4net

DataContext Log Property can be used to print generated SQL query or command in the console window as shown below:

db.Log = Console.Out;

If you want to print the SQL query in DebugView or VS Output window you may use DebugWriter class(by Kris Vandermotten) .The usage of the class is pretty simple …

db.Log = new DebugWriter();

I wrote [...]

Saturday, November 29, 2008 10:16

SQLite Administrator

SQLite Administrator provides you with powerful and effective tools for SQLite administration and object management. Its Graphical User Interface  allows you to create/edit all SQLite database objects in a most easy and simple way, run SQL scripts, build SQL queries, extract or print metadata, export/import data, edit BLOBs and many more abilities that will make [...]