This is a migrated thread and some comments may be shown as answers.

Collections sorting

4 Answers 43 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Igor
Top achievements
Rank 1
Igor asked on 09 Aug 2011, 03:02 PM
In our own, old ORM library we could set additional field NUMBERID in join tabe for relations many-to-many to keep elements order.
The sorting was processed implicitly. It was possible to insert, add and delete items in necessary positions.
There are some possibilities to realise this property in OpenAccess ?

4 Answers, 1 is accepted

Sort by
0
IT-Als
Top achievements
Rank 1
answered on 10 Aug 2011, 08:02 AM
Hi Igor,

Are you using the Classic approach or the Context (Visual Designer) approach?

I know it s possible with the Classic one, exactly the same way by selecting "Ordered" on the m:n relation.

Regards

Henrik
0
Ivailo
Telerik team
answered on 12 Aug 2011, 02:43 PM
Hello Henrik,

Henrik is correct; there is a similar functionality in the OpenAccess ORM Classic wizards. A property is made available for this purpose, called Preserve Order. You can find a detailed description here.

As for the Visual Designer, unfortunately this functionality is not directly available on the association options screen. Basically, there are two options:
1) You can add manually your additional field in the SequenceColumn of the MetaJoinTableAssociation object.
2) You can use the Fluent Mapping API for your mapping as a general approach. We recommend it in case you have other complications in your model and you would like to have a better handling of the low level operations like this one. Here you can find the explanation of using SequenceColumns with the Fluent Mapping API.

Let us know if you would like further assistance or advice on this – whichever option you choose.


Kind regards,
Ivailo
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

0
IT-Als
Top achievements
Rank 1
answered on 12 Aug 2011, 03:06 PM
Hi Ivailo,

Thanks for pointing it out. It was "Preserve Order" and not "Ordered"... typo :-(
0
IT-Als
Top achievements
Rank 1
answered on 15 Aug 2011, 07:53 AM
Hi Igor,

Did this work for you. If so please mark the thread as answered so other visitors of the forums will be able to find the answer fast.
Thanks

/Henrik
Tags
General Discussions
Asked by
Igor
Top achievements
Rank 1
Answers by
IT-Als
Top achievements
Rank 1
Ivailo
Telerik team
Share this question
or