Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>To answer question <strong>a</strong> (sort of) - I do not think there is a "preferred" approach - it really just depends how you want your service to be available. I've hosted net.tcp (I suspect this is the most common in a windows service environment but I am guessing), webhttp, basichttp and wshttp services all fine from inside a windows service. Onto <strong>b</strong>...</p> <p>So the way I do this (and maybe this is just a style thing but it works for me) is that I have a regular windows service and in the program main I bootstrap the container (so stuff that you would do inside App_Start in global asax) and I have installers for the different parts of the application I want to install (incidentally, generally in WCF I split the contracts out into their own assembly and implement them inside the windows service assembly, or in a separate assembly if I need to host the same service in multiple places). </p> <p>Once the container is bootstrapped, I then resolve the ServiceBase from the container and give it to the <a href="http://msdn.microsoft.com/en-us/library/tks2stkt.aspx" rel="nofollow">ServiceBase.Run</a> static method. This way my service can have dependencies on whatever else is registered in the container (this is the only place I would ever call Resolve on the container but I think it is justified in this circumstance). </p> <p>I don't know what else you want your service to do other than hosting WCF services, maybe nothing, but this is a bit of framework to get you going so here it is... </p> <pre><code>static class Program { static void Main() { ServiceBase.Run(CreateContainer().Resolve&lt;ServiceBase&gt;()); } private static IWindsorContainer CreateContainer() { var container = new WindsorContainer(); container.Install(FromAssembly.This()); return container; } } public class ServicesInstaller : IWindsorInstaller { public void Install(IWindsorContainer container, IConfigurationStore store) { container .AddFacility&lt;WcfFacility&gt;(f =&gt; { f.CloseTimeout = TimeSpan.Zero; }) .Register( Component .For&lt;IVirusCheckService&gt;() .ImplementedBy&lt;VirusCheckService&gt;() .LifeStyle.Transient .AsWcfService(new DefaultServiceModel() .AddBaseAddresses("http://localhost:8080/MyService") .AddEndpoints(WcfEndpoint.BoundTo(new BasicHttpBinding()) .At("basic")) .PublishMetadata(o =&gt; o.EnableHttpGet())), Component .For&lt;ServiceBase&gt;() .ImplementedBy&lt;MyService&gt;()); } } </code></pre> <p><em>NOTE: The MyService class is just a regular Windows service class (you can use the one visual studio generates for you when you go file | new | windows service if you like) - I have not shown it because it can just be an empty implementation.</em></p>
    singulars
    1. This table or related slice is empty.
    1. POWCF Service Library hosted as a Windows Service using Castle.Windsor 3.0 issue
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USkmp
    1. USkmp
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWCF Service Library hosted as a Windows Service using Castle.Windsor 3.0 issue
      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
    1. COGreat answer, thank you.
      singulars
      1. PO
      1. USM05Pr1mty
    2. COHaving finally got round to implementing this solution, I have come accross a problem. When starting the service I recieve an "error 1083 the executable program that this service is configured to run does not implemented the service". As far as I am aware this refers to either: service names not matching the installers, or the executable that derives from service base is not registered? Any suggestions here?
      singulars
      1. PO
      1. USM05Pr1mty
    3. COI can't be sure what would cause that without more information. Maybe you should create a new question with all the relevant bits in it (like the installer etc). I would say though first, start by creating a service which is just a normal empty service and make sure it installs and runs fine (so no logic in it at all) and then add in the castle part that registers the ServiceBase and make sure that works and then add in the WCF bits and make sure that works. Then you will have the ingredients for a good question (just stop when it doesn't work) or it just works and you've solved it.
      singulars
      1. PO
      1. USkmp
 

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