Retrieve data from aspnet_Profile

Question

How can I get specific elements from aspnet_Profile?

for example, I have properties - City, Country - can I get all the users who live in Chicago?

I found a way to get all users with Membership.GetAllUsers () and analyze the result, but is there an alternative method?

Answer 1

There is no practical way to do this kind of query using the default SqlProfileProvider.

If you have the flexibility to consider a different provider, SqlTableProfileProvider is a bit more flexible when it comes to SQL queries.