adding data to ASPNETDB.MDF

S

Seb

As of now I have added a few pieces of data to my profile through
web.config. More specifically

<profile enabled="true">
<properties>
<add name="Height" type="Int16"/>
<add name="BirthDate" type="System.DateTime"/>
</properties>
</profile>

How would I go about retrieving all users who are above 180 cm or all
the users who have birthday today?
I'm unsure about how to work with this on a global level and not just
for an individual user.
Is there a way to have this data magically appear as columns in my
aspnet_User table? because that way it would be simple enough.

Another issue is when I want relational data such as weight associated
with a date? For the sake of normalization I have now manually added a
new table containing user id, weight and data columns. But is this
best practice? And what are the alternatives...


best regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,997
Messages
2,570,240
Members
46,828
Latest member
LauraCastr

Latest Threads

Top