in
SubSonic Forums » SubSonic 2.x » FAQ - Frequently Asked Questions » Top with Collection

Top with Collection

Last post 05-04-2008 7:56 PM by yitzchok. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 05-04-2008 7:07 PM

    Top with Collection

    Reply Contact

    Hi there, I would like to retrieve a simple collection, limiting to the top 5 most recent records, but without resorting to a query object. When using this:

    OrganizationCollection myRecentOrgs = new OrganizationCollection().OrderByDesc(Organization.Columns.CreationDate).Load();

    ...I don't see any option for TOP. Am I missing something?

  • 05-04-2008 7:39 PM In reply to

    Re: Top with Collection

    Reply Contact

    Check out http://forums.subsonicproject.com/forums/p/2660/12393.aspx#12393 - And the patch file

    In short this is not yet possible.

    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk

  • 05-04-2008 7:49 PM In reply to

    Re: Top with Collection

    Reply Contact

    Great, thanks. Fair to assume it's in the source but not yet part of a release? Will it be in the next beta?

  • 05-04-2008 7:56 PM In reply to

    Re: Top with Collection

    Reply Contact
    No it's not yet in the SVN repository but it might be in the next release (You can vote for it on codeplex to give the feature a boost:)
    If I am I because I am I, and You are You because You are You, then I am I, and you are you. But If I am I because You are You, and You are You because I am I, then I am not I and You are not You. -Rabbi of Kotzk
Page 1 of 1 (4 items)