Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Services are run by the windows service hosting system, which runs using MTA threads. You can't control this. You have to create a new <a href="http://msdn.microsoft.com/en-us/library/system.threading.thread.aspx" rel="noreferrer">Thread</a> and <a href="http://msdn.microsoft.com/en-us/library/system.threading.thread.setapartmentstate.aspx" rel="noreferrer">set its ApartmentState to STA</a>, and do your work on this thread.</p> <p>Here's a class that extends ServiceBase that does this:</p> <pre><code>public partial class Service1 : ServiceBase { private System.Timers.Timer timer; public Service1() { InitializeComponent(); timer = new System.Timers.Timer(); this.timer.Interval = 10000; // set for 10 seconds this.timer.Elapsed += new System.Timers.ElapsedEventHandler(Tick); } protected override void OnStart(string[] args) { timer.Start(); } private void Tick(object sender, ElapsedEventArgs e) { // create a thread, give it the worker, let it go // is collected when done (not IDisposable) var thread = new Thread(WorkerMethod); thread.SetApartmentState(ApartmentState.STA); thread.Start(); OnStop(); // kill the timer } private void WorkerMethod(object state) { // do your work here in an STA thread } protected override void OnStop() { timer.Stop(); timer.Dispose(); } } </code></pre> <p>Note this code doesn't actually stop the service, it stops the timer. There could be lots of work still being done on multiple threads. For instance, if your work consisted of running multiple queries off a large database you may end up crashing because you have too many threads running at the same time.</p> <p>In a situation like this, I'd create a set number of STA threads (maybe 2x the number of cores to start off with) which monitor a thread-safe queue for work items. The timer tick event would be responsible for loading that queue with the work needing done. </p> <p>It all depends on what you're actually doing every ten seconds, whether or not it should be completed the next time the timer ticks, what you should do in this situation, etc etc.</p>
    singulars
    1. This table or related slice is empty.
    1. PO.NET Windows Service needs to use STAThread
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USWill
    1. USWill
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO.NET Windows Service needs to use STAThread
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 for the workaround; however, how do you explain that the same problem exists for console applications? From my understanding your explanation seems not correct though. A service is started as a child process of the service control manager (and not as a thread) and then the service connects to the controller by calling `StartServiceCtrlDispatcher` (from what I can see in Reflector) so starting a service as STA should be possible.
      singulars
      1. PO
      1. USDirk Vollmar
    2. COIt does not exist for console apps. Console apps respect the STAThreadAttribute. Services do not. The SCM does not run in an STA thread. The SCM does not respect nor does it provide any method for services to communicate their desired apartment state. The OP's code is confusing, as it includes the Main method. All the Main method does is say, "Hey, SCM, here's a DLL containing a service type I want you to run, kthxbai" and goes away. Yeah, that runs in an STA thread, but it does not block and immediately returns. The SCM then determines when to run the service using its own threads.
      singulars
      1. PO
      1. USWill
    3. COWill, After looking up some more on the web and your response, I have a new structure below (there wasn't enough characters to leave it as a comment)
      singulars
      1. PO
      1. USWalter Williams
 

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