Hi,
I'm having some problems with sequences too (adjusent thread), hope
gurus will come and solve :). Meanwhile I suspect that order in which
accumulated changes to database are applyed could not be guaranteed
(multithreading or some internal optimizations?). IMHO asking for
sequence ordering sounds a bit unnatural - usually PK-IDs are just
unique identifiers and one should not care about their actual values.
So if you care about ordering you should just select sequence next
value and assign it yourself in the order you need.
Koka
On Sun, 9 Jan 2005 22:32:45 -0500, Matt Kerr
<mat..entralparksoftware.com> wrote:
> dear list members -
>
> forgive potentially obvious question ..
>
> i call dataContext.createAndRegisterNewObject()
> on objects A, B, and C .. respectively.
>
> after commitChanges() the object id's (pk) in the db
> do not have the same ordering ?
>
> they appear like ...
>
> 1 - C
> 2 - A
> 3 - B
>
> or whatever :-/
>
> is there some way to have the id's follow the
> same ordering as the createAndRegisterNewObject() invocations?
>
> (aside from being heavy handed, and calling commitChanges())
>
> thanks!
> -matt
>
> ~~
> Marriage changes passion. Suddenly you're in bed with a relative.
>
>
This archive was generated by hypermail 2.0.0 : Mon Jan 10 2005 - 01:31:07 EST