Anyway to Specify the User's Name with Membership?

[Jonathan Wood]

Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and not
ideal for the user's actual name. (Also, I'm going to use emails for the
username.)

Thanks for any suggestions.

 

[Eliyahu Goldin]

I usually add another table user_details and join it with aspnet_Users on
UserId.

 

[Kevin Spencer]

If you implement your own Membership Provider derived class and database,
you can add any columns and/or tables you want to, as well as any methods
you wish to add to the base class.

--
HTH,

Kevin Spencer
Chicken Salad Surgeon
Microsoft MVP

I usually add another table user_details and join it with aspnet_Users on
UserId.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin

Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and not
ideal for the user's actual name. (Also, I'm going to use emails for the
username.)

Thanks for any suggestions.

 

[Peter Bromberg [C# MVP]]

If you are already using the Membership Provider, consider using also the
Profile Provider, and store the user's full name or firstname / lastname and
any additional items there.
--
--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com

 

[Eliyahu Goldin]

But then the user names etc go out of the schema and become cumbersome to
get in a single query.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

 

[Jonathan Wood]

Yeah, I'm doing something similar, although I wasn't sure the best way. By
join, do you mean you'll create a relationship between the two tables?

Originally, I thought maybe the user's name would already be part of the
existing membership logic.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

I usually add another table user_details and join it with aspnet_Users on
UserId.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin

Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and not
ideal for the user's actual name. (Also, I'm going to use emails for the
username.)

Thanks for any suggestions.

 

[Jonathan Wood]

I've looked at that, but am not sure it's my best route.

Thanks.

 

[Eliyahu Goldin]

No, I mean just joining tables in the from clause like

select u1.LastName, u1.FirstName, a1.UserName
from aspnet_Users a1 inner join user_Details u1
on a1.UserId=u1.UserId



--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

Yeah, I'm doing something similar, although I wasn't sure the best way. By
join, do you mean you'll create a relationship between the two tables?

Originally, I thought maybe the user's name would already be part of the
existing membership logic.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

I usually add another table user_details and join it with aspnet_Users on
UserId.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin

Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and not
ideal for the user's actual name. (Also, I'm going to use emails for the
username.)

Thanks for any suggestions.

 

[Jonathan Wood]

Okay, so you just mean to create the join when querying the database so that
the data is all together.

Great. Thanks for the clarification. This is probably what I'll be doing.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

No, I mean just joining tables in the from clause like

select u1.LastName, u1.FirstName, a1.UserName
from aspnet_Users a1 inner join user_Details u1
on a1.UserId=u1.UserId



--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

Yeah, I'm doing something similar, although I wasn't sure the best way.
By join, do you mean you'll create a relationship between the two tables?

Originally, I thought maybe the user's name would already be part of the
existing membership logic.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

I usually add another table user_details and join it with aspnet_Users on
UserId.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin


Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and
not
ideal for the user's actual name. (Also, I'm going to use emails for
the
username.)

Thanks for any suggestions.