How to combine using Membership API with own application related data?

by

The first is the simpliest approach. Add the GUID of the user as a foreignkey in the related tables (f.e. Ordered_by). I don’t see where it breaks separating concerns. If you want to keep the order-record in database, you also have to keep the user who has ordered, that makes perfectly sense.

I have used option 4 successfully in my current application. I’ve created a table aspnet_UserID with idUser int as primary-key and fiUser(the GUID of the aspnet_Users) as foreign-key. Here is the model:

Data-Model

(Note: User is the standard aspnet_Users table created via aspnet_regsql.exe and aspnet_UserId is my custom table that maps every Guid with my int-ID)

Now i’m storing only my idUser as FK in all related tables (like in your Order-Table). That has the advantage of less storage and more readable UserID’s(i could never remember a GUID). Maybe it’s somewhat more separated with this “wrapper-table” but that was not my main intention.

You can change the delete-rule on your foreignkeys if you want to control the behavior. Set it to Cascade if you f.e. want to delete all orders that were ordered by the user you’re deleting or set it to no Action if you want to keep this order.

I can’t suggest any alternatives for the Profile question because you haven’t mentioned what you mean with “need to store and access user profile data in more flexible manner then the Profile provider supports”.

More Related Contents:

  1. Is it possible to change the username with the Membership API
  2. Custom MembershipProvider in .NET 4.0
  3. SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified [closed]
  4. Using one Asp.net Membership database with multiple applications Single Sign On
  5. How to assign Profile values?
  6. What is default hash algorithm that ASP.NET membership uses?
  7. Multiple applications using same login database logging each other out
  8. ASP.NET authentication login and logout with browser back button
  9. Entity Framework: how to solve “FOREIGN KEY constraint may cause cycles or multiple cascade paths”?
  10. How do you get the UserID of a User object in ASP.Net MVC?
  11. “The system cannot find the file specified”
  12. ASP.NET MVC3 Role and Permission Management -> With Runtime Permission Assignment
  13. Sitecore authenticate users against external membership database
  14. Building a menu similar to stackoverflow [closed]
  15. Routing to a fixed URL in ASP.NET MVC
  16. Store pictures as files or in the database like MSSQL for a web app?
  17. Can I access session state from an HTTPModule?
  18. How can I implement Ninject or DI on asp.net Web Forms?
  19. How and where to call Database.EnsureCreated and Database.Migrate?
  20. Get Image dimensions using Javascript during file upload
  21. IIS URL Rewriting vs URL Routing
  22. Is there a way to force ASP.NET Web API to return plain text?
  23. Mailbox unavailable. The server response was: 5.7.1 Unable to relay for [email protected] [closed]
  24. How to warm up an ASP.NET MVC application on IIS 7.5?
  25. Can SignalR be used with asp.net WebForms?
  26. How to POST a FORM from HTML to ASPX page
  27. ASP.NET Web Site or ASP.NET Web Application?
  28. IIS Session Timeout vs ASP.NET Session Timeout
  29. ASP.NET session state and multiple worker processes
  30. How to detect/track postback in javascript?

Leave a Comment