Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><img src="https://i.stack.imgur.com/tE8qw.png" alt="enter image description here"></p> <p>** <a href="https://github.com/PureKrome/WorldDomination.Web.Authentication" rel="nofollow noreferrer">Clicky-click for da GitHub project</a> **</p> <p>IMO, forget storing usernames and passwords. That's crazy talk! Let people login with their Facebook, Google or Twitter credentials. That's the 80%'s for the common websites.</p> <p>Authentication and storing the credentials are two different tasks IMO. For example, I don't care where you authenticate against .. and once you do .. I don't care how you store that data :)</p> <p>Personally, I would store it in a RavenDb .. but that's my personal choice.</p> <p>As such -> keeping these two tasks SEPARATE is (IMO) crucial. </p> <p><img src="https://i.stack.imgur.com/l9Ckw.jpg" alt="enter image description here"></p> <p>So <a href="https://github.com/PureKrome/WorldDomination.Web.Authentication/blob/master/Samples/WorldDomination.Web.Authentication.Test.Mvc.Advanced/Controllers/HomeController.cs#L59" rel="nofollow noreferrer">lets look at some codez</a> ....</p> <pre><code>public ActionResult AuthenticateCallback(string providerKey) { // SNIP SNIP SNIP SNIP var model = new AuthenticateCallbackViewModel(); try { // SNIP SNIP SNIP SNIP // Complete the authentication process by retrieving the UserInformation from the provider. model.AuthenticatedClient = _authenticationService.CheckCallback(providerKey, Request.Params, state.ToString()); // Create a new user account or update an existing account. // Whatever you end up doing, this is the part u want to // pass this data to your repository (eg. RavenDb, Sql Server, etc) // I'll use RavenDb in this example... // And yes .. this is a contrite example. U might want to check for // existing email or id or whatever u need to do, etc. var myUser = Mapper.Map(model.AuthenticatedClient); session.Store(myUser); session.SaveChanges(); // SNIP SNIP SNIP SNIP } catch (Exception exception) { model.Exception = exception; } return View(model); } </code></pre> <p>So lets look at what I've done. I've snipped out any verbose stuff (value checks, etc) which are just noise in this SO answer.</p> <p>First, I handle the Authenticate callback. Eg. I've just gone to Facebook and it's said 'yes! you ARE you' .. and it's coming back to my website, with some data i've asked it to give me.</p> <p>Next... we are given some data from Facebook .. but this might not be in the format we want to put it into, in RavenDb. So i convert it from the old format to a new shiney <code>User</code> class which is what you'll stick in your Db.</p> <p>Third - I store this in the Db. <strong>This is where you would do any custom DB logic</strong></p> <p>that's it.</p> <blockquote> <blockquote> <p>M O D U L A R I Z E T H A T S H I T</p> </blockquote> </blockquote> <p>The.End.</p> <p>Now excuse me .. there's a few hours left before The Apocalypse. I must prepare myself.</p>
    singulars
    1. This table or related slice is empty.
    1. POAuthentication with Asp.Net, RavenDB and OAuth support
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPure.Krome
    1. USPure.Krome
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAuthentication with Asp.Net, RavenDB and OAuth support
      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. COI did exactly this. My need is to identify the user, not to authenticate - they can do that against whatever. So this works. Now that I have stored the User in my DB, I need to use it together with the ASP.NET membership system. So i can flag actions with [Authorize] and [AllowAnonymous], return url etc. built-in features in ASP.NET. How do I do that? With this: http://www.codethinked.com/setting-up-authentication-in-aspnet-mvc
      singulars
      1. PO
      1. USesbenr
    2. CO@esbenr To use the `[Authorize]`, etc attributes .. you **DO NOT** (and I repeat, **DO NOT**) need to use ASP.NET Membership system. **PLEASE DO NOT USE THAT AT ALL, UNDER ANY CIRCUMSTANCES** (Google for the 1000000 reasons why). To leverage `[Authorize]`, etc .. u just need to use store the use info in an `IPrincipal` and `IIdentity` (yes, 2x I's). Just create a new `GenericPrincipal` and in that, add a new `GenericIdentity`. Google for those for more code :)
      singulars
      1. PO
      1. USPure.Krome
    3. COThanks, thats what I ended up doing. I only used the Auth ticket + cookie to get the static USER principal to work - it works like a charm :-) This method is stated lot of places on the internet-thingie. BTW: I created a custom IPrinciple implementation AND a custom IIdentity impl. thus i wanted more properties on my User context. Thanks for your reply. /esbenr
      singulars
      1. PO
      1. USesbenr
 

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