Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Actually, the answer is probably a combination of 1 and 3.</p> <p>You can take advantage of a lot of the tools and features that the framework provides for you by writing a <a href="http://msdn.microsoft.com/en-us/library/f1kyba5e.aspx" rel="noreferrer">membership</a>, <a href="http://msdn.microsoft.com/en-us/library/f1kyba5e.aspx" rel="noreferrer">role</a> or <a href="http://msdn.microsoft.com/en-us/library/0580x1f5.aspx" rel="noreferrer">profile</a> provider if the default options don't quite go as far as you'd like.</p> <p>We've done just that on a number of client sites - for example one of our clients has most of their users stored as Commerce Server users, and use the Commerce Server profile system, so we wrote a membership and profile provider to talk to those datastores - a fairly simple excercise.</p> <hr> <p>Most people are probably going for 3 because of the need to authenticate over raw TCP - this introduces a layer beyond that of the standard <strong>ASP.NET</strong> membership providers.</p> <p>Most of what MS produce is "ok" or "good enough", but there will always be edge cases where you want to do something "not quite standard" that mean you end up rolling your own. I guess to have something beyond "Basic Auth" or "Windows Auth" that was simple for your average developer to understand, they took the sensible option of "lets just build this for the web".</p> <p>If you take a look at the numerous ways you can authenticate against a WCF service, you'll see what I mean - these <strong>are</strong> designed to handle different transport mechanisms, and are therefore much more complex.</p> <p>That said, the default roles and profile providers are fairly limited (roles: no hierarchy, so you need to check for each possible role, or explicitly assign each role to the user; profiles: all stored in one field as comma seperated values - not easy to find all users who've got a value set).</p>
    singulars
    1. This table or related slice is empty.
    1. POWhich authentication and authorization schemes are you using - and why?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USZhaph - Ben Duguid
    1. USZhaph - Ben Duguid
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhich authentication and authorization schemes are you using - and why?
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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