Binding grid to Membership Users

[plusHR]

Hi.

We have over 5000+ users in our asp membership database and we finding that when binding this to the radgridview that the query times-out. The inital query is calling the Membership.GetAllUsers but this is what is causing us problems.

public IQueryable<MembershipServiceUser> GetWebUsers()
        {
            return Membership.GetAllUsers().Cast<MembershipUser>().Select(u => new MembershipServiceUser(u)).OrderBy(o=>o.UserName).AsQueryable();
        }

 I have seen that you can call this with PageSizes and the query could read something like this; However I have adjusted the pagesize in the query but with no result;

#region Administration functions

       public IQueryable<MembershipServiceUser> GetWebUsers(int pageIndex, int pageSize, out int totalRecord)
       {
           return Membership.GetAllUsers(pageIndex, pageSize, out totalRecord).Cast<MembershipUser>().Select(u => new MembershipServiceUser(u)).OrderBy(o => o.UserName).AsQueryable();
       }

<riacontrols:DomainDataSource x:Name="MyData"
                                     QueryName="GetWebUsers"
                                     AutoLoad="True"
                                     PageSize="200"
                                     LoadedData="MyData_LoadedData">
           <riacontrols:DomainDataSource.DomainContext>
               <ds:UserRegistrationContext />
           </riacontrols:DomainDataSource.DomainContext>
       </riacontrols:DomainDataSource>

Can you tell me how I can get the grid to pass in the page sizes etc so that we can get the list of login accounts quicker and without having a time-out in the wcf service returning the results.

Thanks
P

[Milan]

Hello Paul,

I Believe that the .GetAllUsers() invocation is breaking the code since it will get all users no matter what. You should skip this step and simply apply your OrderBy condition. For example:

 

public IQueryable<MembershipServiceUser> GetWebUsers()
        {
            return Membership.OrderBy(o=>o.UserName).AsQueryable();
        }

Greetings,
Milan
the Telerik team