Not logged in

How to log the SQL queries made by XPO

Article Details

ID:	A2572
Version(s):	1, 6.x, 7.x
Updated:	10/25/2011

Product Group:	.NET
Product:	eXpress Persistent Objects

Description:

Is it possible to see the queries generated and executed by XPO?

Solution

Yes, you can see the XPO database queries and their execution results in the Output window when debugging your project in Visual Studio. For this, please add the following lines to the App.Config file of your project:

[XML]

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <system.diagnostics>

        <switches>

            <add name="XPO" value="3" />

        </switches>

    </system.diagnostics>

</configuration>

If your project does not include such a file, please add it via the Project | Add New Item... menu command:

If you wish to output XPO SQL commands in a text file, please write the following code in your application's configuration file. XPO will create a trace.log file with queries in the application directory.

[XML]

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <system.diagnostics>

        <trace autoflush="true" indentsize="4">

            <listeners>

                <add name="LogFileTraceListener" type="System.Diagnostics.TextWriterTraceListener" 

                    initializeData="trace.log" />

                <remove name="Default" />

            </listeners>

        </trace>

        <switches>

            <add name="XPO" value="3" />

        </switches>

    </system.diagnostics>

</configuration>

As you can see, XPO utilizes the standard System.Diagnostics trace logging mechanism. Thus, you can create your own TraceListener class, which logs queries in a database or in a text box, for example.

[C#]

System.Diagnostics.Trace.Listeners.Add(new MyTraceListner(textBox1));

...

class MyTraceListner : System.Diagnostics.TraceListener {

    TextBox outputWindow;

    public MyTraceListner(TextBox outputWindow) {

        this.outputWindow = outputWindow;

    }

    public override void Write(string message) {

        outputWindow.AppendText(message);

    }

    public override void WriteLine(string message) {

        outputWindow.AppendText(message + "\r\n");

    }

}

The additional information on this can be found in the MSDN Library:
TraceListener Class

Attachments

dxKB2572.zip (402 bytes)

Do you have any comments? We are eager to hear them!

How would you rate the quality of this content?

Average rating: 7.93 out of 9
15 people have rated this page

Post Your Vote (Login Required)

If you need any clarification with regards to the contents of this article, please don't hesitate to contact our Support Team.

Product Group:

Product:

Keywords:

Searching Tips

Suggestions
Active: 1,156
Processed: 31,145
Questions & Issues
Active: 910
Processed: 255,330 + 100,867
2,125 Knowledge Base Articles
3,413 Code Central Examples