What is aspnet_Users and aspnet_Membership? Which one should I use? What is the difference?

Question

I'm using default membership class in my website. But I'm a little confused with the complex database design of the ASPNETDB.

Let's say I want to add details about user like name, surname, address etc... Where should I put them aspnet_Membership table or aspnet_Users table and why? I mean I can see that I should put the details on aspnet_Membership. But then again why there is two of them and the bindings on aspnet_Users...

Or lets say I'm adding a messaging into that which table should I key to, for the user details?

I'm confused and I would be appreciated if you can tell me the use of these two tables.

Here is the diagram for the default ASPNETDB which you should probably have:

Answer 1

Rather than modifying the built in ASP.NET membership schema, you can use ASP.NET profiles to store custom properties about your users. Here's one tutorial on the subject.

You can add the profile tables to your schema using aspnet_regsql.exe (which you're probably already familiar with, given that you have already generated most of the schema). Use the -R p switch to get the profile tables/procs.