Is there a way to query aspnet_profile values?

K

ken.marable

Working on an application here (SQL Server 2005, C# ASP.Net 2.0) and to
keep it simple, say we are storing EyeColor as a property in the
aspnet_profile table and aspnet_users is our main user table.

Is there a SQL statement that can select all aspnet_users where
EyeColor = Brown?

I'd like to avoid either having to parse out the property values or
making them rewrite parts of the app to store some (possibly
duplicated) profile information elsewhere in the database.

Thankfully, we are talking about probably less than a hundred users in
this table, so if need be, I might just grab all the data and filter it
in code, but it would be nice to keep it cleaner and in a stored
procedure.

Any insight would certainly be helpful.

Thanks!
Ken
 

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

No members online now.

Forum statistics

Threads
474,434
Messages
2,571,690
Members
48,796
Latest member
Greg L.

Latest Threads

Top