ContextSwitchDeadlock was detected

I got following error while trying to retrieve data from a SQL table into a datagridview. Table contains 1000s of data and while retrieving I have to process some data also.

ContextSwitchDeadlock was detected
Message: The CLR has been unable to transition from COM context 0x159bc0 to COM context 0x1598e0 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.

After goggling for about 1 hour I came up with a solution which makes the deadlock detection disable.

 

Step 1

obtain the debug exceptions window (right click tool bar - customize - debug and drag exceptions into the debug menu).

 

Step 2

Select from Debug - Exceptions - Managed Debugging Assistants and disable ContextSwitchDeadlock.

Now visual studio will not through the ContextSwitchDeadlock detected exception. You’ll just have to wait until your long running process completes..