I am migrating a website to Windows Azure and also migrating SQL Server to SQL Azure.
I found that the Membership function FindUsersByName() does not work as in the on premises server. It works ok if I pass a normal string to the function (like "bob" will return all username that contains "bob" like bobby or johnbob). However,
if I pass the string "a%" to the function (which is supposed to return all username begin with 'a'), it only works in the old server but not in the Azure environment.
I check with msdn library and it says that the old provider, SqlMembershipProvider, performs its search using a LIKE clause. But I use 'System.Web.Providers.DefaultMembershipProvider' in the Azure site. I guess these two providers implement
Does anyone know how to retrieve only those username begin with letter 'a' (or other letters) when using the 'System.Web.Providers.DefaultMembershipProvider'? Since I have over 20 thousands members, I don't want to retrieve all members then
do the filtering afterwards. I want to only retrieve those with 'a' only in the first place.
As far as i know, DefaultMembershipProvider default connection string is DefaultConnection that use SQL Server Express as the default database instance, have you change it to SQL Azure? Because local SQL Server is not the recommended way in cloud environment,
so I think the suggestion is use SqlMembershipProvider.