Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It depends on what you need. If you need a <strong>single</strong> instance of your service to be instantiated for the life time of the application you might want to use single. You might do this for instance if instantiating that service was extremely expensive for some reason and it was not called very often so you weren't concerned about multiple threads hitting it at the same time.</p> <pre><code> [ServiceBehavior(Namespace = "http://somenamespace", InstanceContextMode = InstanceContextMode.Single)] public sealed class ServiceWithExpensiveDictionary : IServiceWithExpensiveDictionary, IDisposable { private DataCacheFactory factory; private ConcurrentDictionary&lt;string, DataCache&gt; dataCacheDictionary; /// &lt;summary&gt; /// Constructor /// &lt;/summary&gt; public ServiceWithExpensiveDictionary() { factory = new DataCacheFactory(); dataCacheDictionary = new ConcurrentDictionary&lt;string,DataCache&gt;(); } </code></pre> <p>In the code above, I want the ConcurrentDictionary instance to be around for all callers of the service as I'm putting expensive objects into it.</p> <p>You might use <strong>session</strong> if you were intending users to have stateful long-running conversations with your api.</p> <p>You might use <strong>per call</strong> if your services were stateless and service instantiation was cheap.</p> <p>It really depends on what you want to do.</p> <p>There is also a nice question related to this here. It also touches on throttling which you might also be interested in:-</p> <p><a href="https://stackoverflow.com/questions/7122608/wcf-concurrencymode-single-and-instancecontextmode-percall">WCF ConcurrencyMode Single and InstanceContextMode PerCall</a></p>
    singulars
    1. This table or related slice is empty.
    1. POwhat is the purpose of wcf ConcurrencyMode
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USNick Ryan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POwhat is the purpose of wcf ConcurrencyMode
      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
    1. COsorry really do not understand what u said...can u please use some sample code with various option just to make me understand. thanks
      singulars
      1. PO
      1. USThomas
    2. CO@Thomas I put in an example for Single. In the rest of my app, it's all per call at the moment - as all the other services are stateless.
      singulars
      1. PO
      1. USNick Ryan
 

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