CODEWITHSUNDEEP
codefluent
Jean-Yves
Jean-Yves

Reputation: 1

MyPivoRunner & Progress bar control

I'd like to show a Progress Bar Control while running the Pivot script file. However, when updating my database, there's a long wait (several minutes) when the UpdateTable method is called for the first time. Is there a way to track all executed SQL queries? (somthing like with the TraceServer class / SQL Profiler)?

PivotRunner runner = new MyPivotRunner();
runner.ConnectionString = _myPersistence.ConnectionString;
runner.Run();

public class MyPivotRunner : PivotRunner
{

...

protected override void UpdateTable(PivotRunnerTable table, Table existingTable)
{
    base.UpdateTable(table, existingTable);

    // first call: hanging several minutes 
    // second and following calls: ok
}

Upvotes: 0

Views: 46

Answers (1)

MChiva
MChiva

Reputation: 11

You could implement a Logger (IServiceHost) and set it on your Runner through Logger property. Many ExecuteQuery used at several steps called by UpdateTable are logged using the existing Logger if one is provided.

Upvotes: 1

Related Questions