0

My question is similar to C# Console App, slow to exit

But I have been able to isolate the cause to a certain extent.

To summarize: I have a console app that does a sqlbulkcopy.writetoserver. Everything seems to work fine. The data all gets inserted into the destination table. The stored procedures that work on the transferred data all work as expected.

The only strangeness is this: if there is no data to write then the app exits normally. But if writetoserver actually did write something - even one row, then the app takes an unusually long time to exit (at least one second sometimes more). In other words if I have a console.writeline just before the end of the main method, the message appears but then there is a delay of a second before the prompt returns. I cannot imagine this is expected behaviour.

I have had other console apps where the use of SqlConnection.ClearAllPools (as mentioned in that other question) has been the solution.

But this time ClearAllPools has made no difference. Having Pooling set to true and false in the sql connection string has made no difference. Ensuring the sqlbulkcopy is closed, the connection is closed etc, nothing I have done has made a difference to this strange delay.

I would be grateful for any ideas

user2849221
  • 113
  • 8
  • Pause the debugger while it's exiting & see what it's doing. – SLaks Feb 07 '18 at 16:00
  • In vs 2017 community I placed a break point on the last statement in main but I don't seem to be able to step into what ever is executing after that point. it just say the exe has exited – user2849221 Feb 07 '18 at 19:13
  • Click pause in the debugger when it's hung – SLaks Feb 07 '18 at 19:15

1 Answers1

0

From one of the replies to this (similar) question:

Console app takes a long time to exit after finishing work

Having this code just before the end of main removes the unwanted delay

    GC.Collect();
    GC.WaitForPendingFinalizers();
    GC.Collect();

I don't understand why this works but I am grateful to Yvette Colomb for the suggestion

user2849221
  • 113
  • 8