Use ASP.NET Profile or not?
Posted
by DotnetDude
on Stack Overflow
See other posts from Stack Overflow
or by DotnetDude
Published on 2010-05-14T22:11:26Z
Indexed on
2010/05/14
22:24 UTC
Read the original article
Hit count: 305
ASP.NET
|asp.net-membership
I need to store a few attributes of an authenticated user (I am using Membership API) and I need to make a choice between using Profiles or adding a new table with UserId as the PK. It appears that using Profiles is quick and needs less work upfront. However, I see the following downsides:
- The profile values are squished into a single ntext column. At some point in the future, I will have SQL scripts that may update user's attributes. Querying a ntext column and trying to update a value sounds a little buggy to me.
- If I choose to add a new user specific property and would like to assign a default for all the existing users, would it be possible?
My first impression has been that using profiles may cause maintainance headaches in the long run. Thoughts?
© Stack Overflow or respective owner