Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Like Ash, I write all actual processing code in a separate class library assembly, which was then referenced by the windows service executable, as well as a console app.</p> <p>However, there are occasions when it is useful to know if the class library is running in the context of the service executable or the console app. The way I do this is to reflect on the base class of the hosting app. (Sorry for the VB, but I imagine that the following could be c#-ified fairly easily):</p> <pre class="lang-vb prettyprint-override"><code>Public Class ExecutionContext ''' &lt;summary&gt; ''' Gets a value indicating whether the application is a windows service. ''' &lt;/summary&gt; ''' &lt;value&gt; ''' &lt;c&gt;true&lt;/c&gt; if this instance is service; otherwise, &lt;c&gt;false&lt;/c&gt;. ''' &lt;/value&gt; Public Shared ReadOnly Property IsService() As Boolean Get ' Determining whether or not the host application is a service is ' an expensive operation (it uses reflection), so we cache the ' result of the first call to this method so that we don't have to ' recalculate it every call. ' If we have not already determined whether or not the application ' is running as a service... If IsNothing(_isService) Then ' Get details of the host assembly. Dim entryAssembly As Reflection.Assembly = Reflection.Assembly.GetEntryAssembly ' Get the method that was called to enter the host assembly. Dim entryPoint As System.Reflection.MethodInfo = entryAssembly.EntryPoint ' If the base type of the host assembly inherits from the ' "ServiceBase" class, it must be a windows service. We store ' the result ready for the next caller of this method. _isService = (entryPoint.ReflectedType.BaseType.FullName = "System.ServiceProcess.ServiceBase") End If ' Return the cached result. Return CBool(_isService) End Get End Property Private Shared _isService As Nullable(Of Boolean) = Nothing #End Region End Class </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAm I Running as a Service
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USKramii
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAm I Running as a Service
      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. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't see how this could work if the same assembly could be run as a console app or as a Windows service...Assembly.GetEntryAssembly() and Assembly.EntryPoint return the same values in both cases. I'd guess it only works if you run different assemblies in the two cases.
      singulars
      1. PO
      1. USDan Ports
    2. CO@DanPorts: I've never attempted to run the same *assembly* as both a console app and as a Windows Service. However, it is sometimes useful to compile the same set of classes into an app of each kind, in which case the class above can be useful to determine which context it is being used in.
      singulars
      1. PO
      1. USKramii
 

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