Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You have some options. If you don't care if the operation completes when the application is going down you might be better off using a ThreadPool thread via <a href="http://msdn.microsoft.com/en-us/library/system.threading.threadpool.queueuserworkitem.aspx" rel="nofollow">QueueUserWorkItem</a> or (as Servy suggests in comments) set the <a href="http://msdn.microsoft.com/en-us/library/system.threading.thread.isbackground.aspx" rel="nofollow">IsBackground</a> property of your thread to true, which will allow the process to exit without the thread exiting.</p> <p>If you do care about the operation completing and/or have cleanup logic that needs to be run on shutdown you probably don't really want to use Thread.Abort, at least not as your goto strategy. What I use is something similar to this:</p> <pre><code>public abstract class DisposableThread : IDisposable { private ManualResetEvent exiting = new ManualResetEvent(false); private Thread theThread; private TimeSpan abortTimeout; public DisposableThread(): this(TimeSpan.FromMilliseconds(100)) { } public DisposableThread(TimeSpan abortTimeout) { this.abortTimeout = abortTimeout; theThread = new Thread((_) =&gt; ThreadProc()); } protected virtual void ThreadProc() { while(!exiting.WaitOne(0)) { WorkUnit(exiting); } ThreadCleanup(); } public void Dispose() { this.Dispose(true); GC.SuppressFinalize(this); } protected virtual void Dispose(bool disposing) { exiting.Set(); if (!theThread.Join(abortTimeout)) { // logme -- the thread didn't shutdown gracefully theThread.Abort(); while (!theThread.Join(1000)) { // logme -- the thread is doing something dumb in an exception handler } } exiting.Dispose(); } // WorkUnit should return as quickly as safe if the exiting handle is set // If it doesn't the thread will be aborted if it takes longer than abortTimeout protected abstract void WorkUnit(WaitHandle exiting); // override if you need to cleanup on exit protected virtual void ThreadCleanup() { } } </code></pre> <p>Which gives your thread a chance to exit gracefully and only aborts if a graceful exit fails.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to close a thread containing a blocking method in C#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USYaur
    1. USYaur
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COYou don't want to put very long running operations in thread pool threas. You should just mark the thread you create as a background thread through `IsBackground = true` instead.
      singulars
      1. PO
      1. USServy
    2. COso with the example in the website I mentioned, how do I close the 2 threads properly? =/
      singulars
      1. PO
      1. USCaTx
    3. COI don't see an example here...
      singulars
      1. PO
      1. USYaur
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload