Page 1 of 2

MembershipProvider and paging

Posted: Fri 02 Oct 2009 15:18
by alex_caro1
Hi,

I have a problem with paging in the function GetAllUsers from MembershipProvider:
MembershipProvider.GetAllUsers(0, 10, out totalUserCount);

I would expect to get only the first ten users of my system but I get all users.
Am I doing something wrong there?

Regards,
Alexandra

Posted: Mon 05 Oct 2009 16:32
by Shalex
We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.

Posted: Fri 09 Oct 2009 15:19
by Shalex
The problem is fixed. Look forward to the next build of dotConnect for PostgreSQL. I will post here when it is available for download.

Posted: Mon 12 Oct 2009 07:00
by alex_caro1
Thanks, I'm looking forward to testing it.

Posted: Tue 20 Oct 2009 09:45
by Shalex
The new build of dotConnect for PostgreSQL 4.55.49 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=16153 .

Posted: Tue 27 Oct 2009 12:41
by alex_caro1
Hi,

I just installed dotConnect 4.55.49.

Unfortunately the paging problem is still there:

the call to

MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount);

still returns the total number of users instead of 10.

Regards,
Alexandra

Posted: Wed 28 Oct 2009 11:10
by Shalex
I cannot reproduce the problem with the 4.55.49 version of dotConnect for PostgreSQL. Please make sure that the 4.55.49.0 version of Devart.Data.PostgreSql.Web.dll is loaded to the process of your application. You can check it by launching the Debug | Windows | Modules window when running your application in the debug mode and setting a break point somewhere in your code.

Please notify us about the results.

Posted: Tue 03 Nov 2009 11:59
by alex_caro1
Hi,

I think there is a problem with the installer package.

The visual studio reference properties shows Devart.Data.PostgreSql.Web 4.55.49.
But in the module window, when the application is running, it shows 4.55.42.

I already try to reinstall it, then re-add the devart references, but I still see the wrong dll version although I don't have any old version of Devart on my computer anymore.

Thanks for your help,
Alexandra

Posted: Wed 04 Nov 2009 08:39
by Shalex
1. Please check all references in your project (in the *.config and *.aspx files).
2. Make sure that there is no Devart.Data.PostgreSql.Web.dll 4.55.42 in your GAC and in the bin folder of your project.
3. Please try re-adding the references to the Devart assemblies again.

If the problem persists, let us know.

Posted: Wed 04 Nov 2009 09:22
by alex_caro1
Hi,

ok, I am now using the right dlls and the problem mentioned above is solved.

But the paging still doesn't work:

Old version:
MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount)
returns a user collection with 50 users (all).

New version (4.55.49):
MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount)
returns a user collection with only 10 users but now totalUserCount is also equal to 10 instead of 50.

Regards,
Alexandra

Posted: Thu 05 Nov 2009 14:00
by Shalex
Thank you for your report. We will fix the issue.

Posted: Fri 06 Nov 2009 15:50
by Shalex
The problem with the MembershipProvider.GetAllUsers method is fixed. Look forward to the next build of dotConnect for PostgreSQL. I will post here when it is available for download.

Posted: Fri 20 Nov 2009 16:25
by Shalex
dotConnect for PostgreSQL v 4.65 is released.
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=16438.

Posted: Wed 25 Nov 2009 13:30
by alex_caro1
Hi,

I installed the last release of dotConnect for PostgreSQL (v 4.65).

And I am sorry to say that it is still not working. The previous problem has been fixed, but the paging is still wrong.

Older version:
MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount)
returns a user collection with 50 users (all).

Version 4.55.49:
MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount)
returns a user collection with only 10 users but now totalUserCount is also equal to 10 instead of 50.

Version 4.65:
MembershipProvider.GetAllUsers(0, 10/*pageSize*/, out totalUserCount)
returns a user collection with only 10 users and totalUserCount is equal to 50. This is correct.
But now the problem is that I don't get the right user values!
For page 0, I get user0, ..., user10.
For page 1, I get user0, ..., user9, user11.
(The users are not sorted by name)

Thanks for your help,
Alexandra

Posted: Thu 26 Nov 2009 11:30
by Shalex
Thank you. We will fix the paging and send you a separate Devart.Data.PostgreSql.Web.dll assembly where the problem is resolved to your e-mail address.