Client Side Sequential Guid Generation

Is it possible to generate a Guid on the client side similar to
NEWSEQUENTIALGUID()?
I need a solution to PK generation that benefits from Guid so i can create
an object graph on the client side without the performance problems of
standard Guids.
Master-Detail data will be inserted into a Dataset and posted to the
database in one transaction to save round trips in a web service
application.here is from an old post:
http://groups.google.co.uk/groups/s...ql+oj+dllimport
-oj
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Hi Anthony
If you want to identify the individual client then you a GUID would not give
you that information, therefore you would probably end up storing that as a
separate column which is part of a composite key. For SQL Server the other
column could be an Identity which would give you incrementing numbers and if
you needed these to be contiguous then they could be ranked. The other
alternative would be to maintain a counter for each client that you incremen
t.
John
"Anthony" wrote:

> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>
>|||It depends on the application. If it's a .net app, then it's very easy to
generate the guid by using the Guid.NewGuid() method. (It sounds like it
from the use of DataSet, which is a .net class.)
There should be a way from other languages to generate a guid.
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Sorry, I mean I NEWSEQUENTIALGUID() was introduced to counter the
performance problems of the standard Guid. BUt I would like my Id
generated within my .NET app.
Anthony wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.