How to register generated SQL queries from Simple.Data ORM for .NET.

Question

How to record generated sql queries (without mysql profiler)?

I am using Simple.Data.Mysql

+8

nidheeshdas Feb 15 '12 at 7:37

source share

2 answers

All generated SQL statements (plus parameter values) are written to Trace by default, so you can simply attach a listener.

+3

Mark randle Feb 27 '12 at 13:20

source share

Hmobius · Accepted Answer · 2012-10-16T13:22:46+0000

You have a couple of options here. You can either configure a trace listener like this, and then yes, it will appear in the VS output window.

<configuration> <system.diagnostics> <switches> <add name="Simple.Data" value="Info" /> </switches> </system.diagnostics> </configuration>

Or you can also look at ExampleRunner and ExampleTestListener in Simple.Data.Sample for an example of setting it in code.