Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2008-08-21 : 13:07:42
|
| Hello,quick question. How do i customize the memebrship database to suit our needs.Basically we have far more needs that the basic aspnet_membership DB.1. Do we normalize it, by creating a new table with FK to the membership table. 2. How do we insert into the new table if option 1 is the way to go ? Do we create a custom SP to insert data ?THANKSEhi |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 22:49:42
|
| Where did you get that? How does it look like? |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-08-22 : 01:48:54
|
| Get what ?We are using memberships in .net and profiles, however we are looking to create custom columns to fit our needs ??? |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2008-08-22 : 22:25:19
|
| Ehi, You'll need to create a custom provider to map the controls to your existing db schema. There are lots of examples on the net. Heres one: [url]http://blogs.syrinx.com/blogs/dotnet/archive/2007/12/14/a-simple-custom-sql-membership-provider-part-1.aspx[/url]Out of the box it looks like MS intended to store extended attributes like FirstName or DateOfBirth in the name:value profile table, though for many of us that is simply too limiting. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-08-23 : 03:57:45
|
Ok thanks.Yes MS implementation is way too limiting. It doesnt even allow proper reporting or sorting records e.g. by city or certain xters  |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-08-23 : 04:25:51
|
| that particular article talks about passwords. But had a link to MS website which had a more detailed article. |
|
|
|
|
|
|
Customizing membership provider DB