OracleSiteMapProvider sorts based on insert order

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
rcuirle
Posts: 1
Joined: Wed 29 Jul 2009 13:29
Location: Akron, OH

OracleSiteMapProvider sorts based on insert order

Post by rcuirle » Wed 29 Jul 2009 15:26

It appears that there is no control over the order in which sitemap nodes are displayed. It always orders (within a parentnodeid) based on the order in which the records were inserted. This isn't optimal. Every time the sitemap nodes change, I have to modify a sql script to trunc the table and reinsert the nodes in the correct order.

Please add an OrderID column (or something) that allows user control over the return result set.

Example insert sets:

Code: Select all

truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main',  'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
COMMIT;
vs.

Code: Select all

truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main',  'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
COMMIT;

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 31 Jul 2009 09:26

We will fix this issue. Look forward to the next build of dotConnect for Oracle.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 16 Nov 2009 16:20

We have added the orderid column for the Site Map provider for custom map node ordering. Look forward to the next build of dotConnect for Oracle. I will post here when it is available for download.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 20 Nov 2009 16:22

dotConnect for Oracle v 5.35 is released.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.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=16436.

Post Reply