To be able to do this type of SQL querying, you need to use a custom provider
that allows for searching columns in a non-opaque way in the database. On
codeplex.com there are a couple of good samples of "table-based" providers
that do this.
-- Peter
Site:
http://www.eggheadcafe.com UnBlog:
http://petesbloggerama.blogspot.com MetaFinder:
http://www.blogmetafinder.com [quoted text, click to view] "Tem" wrote:
> Is this possible with asp.net membership provider?
> I need it to return the user name of a user whos profile property age > 65
>
> If not directly from the provider how do I write a sql query that does this?
>
> Tem
>