Is it possible to have an ordered collection of persistent capable objects without using a link table? Let's say I have a Product object with a list of ProductImage objects. The ProductImage table has a DisplayOrder column that I'd like to use as the list sequence. Since the ProductImage object will not belong to any other ordered collections, there is no need to have a link table that contains the sequence column. If this is possible, what would the OA mapping look like?
The NHibernate way of doing this with attributes looks like this
[List(Lazy = false, Cascade = CascadeStyle.AllDeleteOrphan, Access = "field")]
[Key(1, Column = "ProductId")]
[Index(2, Column = "DisplayOrder")]
[OneToMany(3, ClassType = typeof(ProductImage))]