Linq2DB Nlog or logging

Question

is there a way to log all linq2DB sql queries that are made to he database with NLog?

I cannot find any realistic example. There is something for miniprofiler, but this doesn't help me, because I have not experience with it.

pull request

example

example 2

maybe this is helpful? http://www.dotnetcurry.com/showarticle.aspx?ID=647 — Julian, May 03 '17 at 22:33
or what about this: https://github.com/usarskyy/VXCore.MiniProfiler — Julian, May 03 '17 at 22:36
I ended up asking directly in github.com. https://github.com/linq2db/linq2db/issues/646 — Franki1986, May 04 '17 at 04:18

score 20 · Answer 1 · edited Sep 17 '18 at 14:18

20

Inside your Setup method you could turn on Trace and setup WriteTraceLine to Console.WriteLine

[SetUp]
public void Setup()
{
    LinqToDB.Data.DataConnection.TurnTraceSwitchOn();
    LinqToDB.Data.DataConnection.WriteTraceLine = (message, displayName) => { Console.WriteLine($"{message} {displayName}"); };
}

This will write all executed SQL Queries (together with params) to the Console

edited Sep 17 '18 at 14:18

Guru Stron

102,774
10
95
132

answered Mar 14 '18 at 10:33

croban

387
2
7

Linq2DB Nlog or logging

1 Answers1