473,320 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Consecutive GUID Generation in DotNet Framework

Current Framework 2.0/3.0.

...

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
.........
Here is a test stored procedure I wrote to show you what I'm talking about.


IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[uspNewSequentialUUIDCreateRange]') AND type in (N'P',
N'PC'))

DROP PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange]

GO

CREATE PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange] (

@newUUIDCount int --return

)

AS

SET NOCOUNT ON

declare @t table ( dummyid int , entryid int identity(1,1) , uuid
uniqueidentifier default newsequentialid() )

insert into @t ( dummyid ) select top (@newUUIDCount) 0 from dbo.sysobjects
so with (nolock)

select entryid , uuid from @t

SET NOCOUNT OFF

GO



/*

--START TEST

set nocount ON

Create Table #HolderTable (entryid int , uuid uniqueidentifier )

declare @NewUUIDCount int

select @NewUUIDCount = 20

INSERT INTO #HolderTable EXEC dbo.uspNewSequentialUUIDCreateRange
@NewUUIDCount

select * from #HolderTable

DROP Table #HolderTable

--END TEST CODE

*/
Sep 5 '08 #1
16 2366
System.Guid.NewGuid()

--
John Saunders | MVP - Connected System Developer
Sep 5 '08 #2
Just use whatever constructor best fit your needs :
http://msdn.microsoft.com/en-us/libr...guid.guid.aspx

--
Patrice

"sloan" <sl***@ipass.neta écrit dans le message de groupe de discussion :
uf**************@TK2MSFTNGP05.phx.gbl...
Current Framework 2.0/3.0.

..

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line
prompt tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
........
Here is a test stored procedure I wrote to show you what I'm talking
about.


IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[uspNewSequentialUUIDCreateRange]') AND type in (N'P',
N'PC'))

DROP PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange]

GO

CREATE PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange] (

@newUUIDCount int --return

)

AS

SET NOCOUNT ON

declare @t table ( dummyid int , entryid int identity(1,1) , uuid
uniqueidentifier default newsequentialid() )

insert into @t ( dummyid ) select top (@newUUIDCount) 0 from
dbo.sysobjects so with (nolock)

select entryid , uuid from @t

SET NOCOUNT OFF

GO



/*

--START TEST

set nocount ON

Create Table #HolderTable (entryid int , uuid uniqueidentifier )

declare @NewUUIDCount int

select @NewUUIDCount = 20

INSERT INTO #HolderTable EXEC dbo.uspNewSequentialUUIDCreateRange
@NewUUIDCount

select * from #HolderTable

DROP Table #HolderTable

--END TEST CODE

*/

Sep 5 '08 #3
I don't see a way to do this with the System.Guid class. newsequentialid was
introduced to provide some optimization in SQL, but that was not part of the
intent of GUIDs. GUIDs are somewhat random, and newsequentialid does away
with the randomness.
"sloan" wrote:
Current Framework 2.0/3.0.

...

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
.........
Here is a test stored procedure I wrote to show you what I'm talking about.


IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[uspNewSequentialUUIDCreateRange]') AND type in (N'P',
N'PC'))

DROP PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange]

GO

CREATE PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange] (

@newUUIDCount int --return

)

AS

SET NOCOUNT ON

declare @t table ( dummyid int , entryid int identity(1,1) , uuid
uniqueidentifier default newsequentialid() )

insert into @t ( dummyid ) select top (@newUUIDCount) 0 from dbo.sysobjects
so with (nolock)

select entryid , uuid from @t

SET NOCOUNT OFF

GO



/*

--START TEST

set nocount ON

Create Table #HolderTable (entryid int , uuid uniqueidentifier )

declare @NewUUIDCount int

select @NewUUIDCount = 20

INSERT INTO #HolderTable EXEC dbo.uspNewSequentialUUIDCreateRange
@NewUUIDCount

select * from #HolderTable

DROP Table #HolderTable

--END TEST CODE

*/
Sep 5 '08 #4
Mike,

Thanks for actually reading my post.

Yeah, I don't see a way to do it with System.Guid. ( I was already aware of
that class' existence ).

I may use my usp and push some sequential guid's up to the business layer,
since I'll already be in the database.
Or delay their creation until I'm pushing some data back into the tsql.

Oh well, I thought I'd ask.


"Family Tree Mike" <Fa************@discussions.microsoft.comwrote in
message news:76**********************************@microsof t.com...
>I don't see a way to do this with the System.Guid class. newsequentialid
was
introduced to provide some optimization in SQL, but that was not part of
the
intent of GUIDs. GUIDs are somewhat random, and newsequentialid does away
with the randomness.
"sloan" wrote:
>Current Framework 2.0/3.0.

...

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line
prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
.........
Here is a test stored procedure I wrote to show you what I'm talking
about.


IF EXISTS (SELECT * FROM sys.objects WHERE object_id =
OBJECT_ID(N'[dbo].[uspNewSequentialUUIDCreateRange]') AND type in (N'P',
N'PC'))

DROP PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange]

GO

CREATE PROCEDURE [dbo].[uspNewSequentialUUIDCreateRange] (

@newUUIDCount int --return

)

AS

SET NOCOUNT ON

declare @t table ( dummyid int , entryid int identity(1,1) , uuid
uniqueidentifier default newsequentialid() )

insert into @t ( dummyid ) select top (@newUUIDCount) 0 from
dbo.sysobjects
so with (nolock)

select entryid , uuid from @t

SET NOCOUNT OFF

GO



/*

--START TEST

set nocount ON

Create Table #HolderTable (entryid int , uuid uniqueidentifier )

declare @NewUUIDCount int

select @NewUUIDCount = 20

INSERT INTO #HolderTable EXEC dbo.uspNewSequentialUUIDCreateRange
@NewUUIDCount

select * from #HolderTable

DROP Table #HolderTable

--END TEST CODE

*/

Sep 5 '08 #5
I don't understand - why do you need them to be sequential? Is it not enough
that each one is unique?
--
John Saunders | MVP - Connected System Developer

Sep 5 '08 #6
"John Saunders" <no@dont.do.that.comwrote in message
news:uv**************@TK2MSFTNGP02.phx.gbl...
>I don't understand - why do you need them to be sequential? Is it not
enough that each one is unique?
If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence SQL
server provides the newsequentialid function which generates a form of Guid
which more predictable and when compared each new id is than the previous.
This increases slightly the risk of collision but since the scope of use is
so narrow its beyond worrying about and yet provides a good basis for a
clustered key.

--
Anthony Jones - MVP ASP/ASP.NET

Sep 5 '08 #7
There are really good reasons to use a unique, sequential PK--most of the
reasons have to do with how the index pages are managed and index
fragmentation. While the NEWSEQUENTIALID is _UNIQUE_ it is not globally
unique unless the system has a NIC card (it uses the MAC address to generate
the uniqueness) so there is NO problem with concurrency in any case.

I quote from the doc: "Each GUID generated by using NEWSEQUENTIALID() is
unique on that computer. GUIDs generated by using NEWSEQUENTIALID() are
unique across multiple computers only if the source computer has a network
card."

hth

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
__________________________________________________ __________________________________________

"Anthony Jones" <An***********@yadayadayada.comwrote in message
news:eY**************@TK2MSFTNGP04.phx.gbl...
"John Saunders" <no@dont.do.that.comwrote in message
news:uv**************@TK2MSFTNGP02.phx.gbl...
>>I don't understand - why do you need them to be sequential? Is it not
enough that each one is unique?

If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence
SQL server provides the newsequentialid function which generates a form of
Guid which more predictable and when compared each new id is than the
previous. This increases slightly the risk of collision but since the
scope of use is so narrow its beyond worrying about and yet provides a
good basis for a clustered key.

--
Anthony Jones - MVP ASP/ASP.NET
Sep 5 '08 #8

Ding Ding Ding Ding Ding!

That's for explaining it, so I didn't have to. I'm worn out this week.

.....................

And sometimes we build our relationships OUTSIDE of the database, and shoot
them in via xml.
And we use a surrogate key......and with set based inserts......a
consecutive guid would be beneficial.

We have been relying on the newsequentialid (as the default value for the
uniqueidentifier primary key), but I was going to experiment with creating
the surrogate key outside of the database and pushing it in instead.

..............

This was experimentation stuff. And trying to figure out if having them
generated outside of the db provided any benefit.

One of the biggest wait stats we have is
PAGELATCH_EX.

I'm not a dba, I'm not trying to experiment to see if the "outside
sequential guid" creation might help.

Maybe someone can comment on the

PAGELATCH_EX ... and if I'm barking up the wrong tree or not.


PAGELATCH_EX

True
Occurs when a task is waiting for a latch for a buffer that is not in
an I/O request. The latch request is in Exclusive mode.

Contention can be caused by issues other than IO or memory
performance, for example, heavy concurrent inserts into the same index range
can cause this kind of contention. If many inserts must be added on the same
page, they are serialized using the latch. Lots of inserts into the same
range can also cause page splits in the index which holds onto the latch
while allocating a new page (this can take time). Any read accesses to the
same range as the inserts would also conflict on the latches. The solution
in these cases is to distribute the inserts using a more appropriate index.


"Anthony Jones" <An***********@yadayadayada.comwrote in message
news:eY**************@TK2MSFTNGP04.phx.gbl...
"John Saunders" <no@dont.do.that.comwrote in message
news:uv**************@TK2MSFTNGP02.phx.gbl...
>>I don't understand - why do you need them to be sequential? Is it not
enough that each one is unique?

If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence
SQL server provides the newsequentialid function which generates a form of
Guid which more predictable and when compared each new id is than the
previous. This increases slightly the risk of collision but since the
scope of use is so narrow its beyond worrying about and yet provides a
good basis for a clustered key.

--
Anthony Jones - MVP ASP/ASP.NET

Sep 5 '08 #9
If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence
SQL server provides the newsequentialid function which generates a form of
Guid
Why/when would that be preferable over just using an incremental numeric ID
field?

-Darrel

Sep 5 '08 #10

When you need to merge N number of databases.
Yes, there are "identity" workarounds, but if you ever need to merge massive
databases, using GUID's makes it easier.
Replicating IDENTITY's is a big headache as well.


"darrel" <no*****@notreal.comwrote in message
news:O3**************@TK2MSFTNGP03.phx.gbl...
>If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence
SQL server provides the newsequentialid function which generates a form
of Guid

Why/when would that be preferable over just using an incremental numeric
ID field?

-Darrel

Sep 5 '08 #11
Using an Identity coupled with a DB-specific column value as a PK would
solve this issue.

--
__________________________________________________ ________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
__________________________________________________ __________________________________________

"darrel" <no*****@notreal.comwrote in message
news:O3**************@TK2MSFTNGP03.phx.gbl...
>If you are using them as a unique or primary key in a database such a SQL
server their highly random nature makes them less than desirable. Hence
SQL server provides the newsequentialid function which generates a form
of Guid

Why/when would that be preferable over just using an incremental numeric
ID field?

-Darrel
Sep 5 '08 #12
When you need to merge N number of databases.
Yes, there are "identity" workarounds, but if you ever need to merge
massive databases, using GUID's makes it easier.
Ah! Yes, that makes sense.

-Darrel
Sep 5 '08 #13
"William Vaughn (MVP)" <bi****@NoSpamBetav.comwrote in message
news:un**************@TK2MSFTNGP05.phx.gbl...
Using an Identity coupled with a DB-specific column value as a PK would
solve this issue.
A bit of a pain to set up and not as convienent to consume in C#.

--
Anthony Jones - MVP ASP/ASP.NET

Sep 6 '08 #14
On Sep 5, 4:37*pm, "sloan" <sl...@ipass.netwrote:
Current Framework 2.0/3.0.

..

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
Hi sloan,

I don't think anyone's given you a straight answer - NewSequentialID
in SQL Server is essentially just exposing UuidCreateSequential from
rpcrt4.dll. You should be able to find the signature on PInvoke.net

Damien
Sep 8 '08 #15

Thanks for the straight answer.........!


"Damien" <Da*******************@hotmail.comwrote in message
news:21**********************************@79g2000h sk.googlegroups.com...
On Sep 5, 4:37 pm, "sloan" <sl...@ipass.netwrote:
Current Framework 2.0/3.0.

..

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line
prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
Hi sloan,

I don't think anyone's given you a straight answer - NewSequentialID
in SQL Server is essentially just exposing UuidCreateSequential from
rpcrt4.dll. You should be able to find the signature on PInvoke.net

Damien
Sep 8 '08 #16

Just to follow up, here is the import and sample C# code:

http://www.pinvoke.net/default.aspx/...equential.html

Thanks again Damien.........

"Damien" <Da*******************@hotmail.comwrote in message
news:21**********************************@79g2000h sk.googlegroups.com...
On Sep 5, 4:37 pm, "sloan" <sl...@ipass.netwrote:
Current Framework 2.0/3.0.

..

In Sql Server, there is a way to generate consecutive guid's.
newsequentialid.

Is there a way to reproduce this type of consecutive guid's in the
framework.

I found some info about uuidgen , but that seems like a command line
prompt
tool, not a class library.

I'd like to be able to throw an int value (N) at it, and it return N
consecutive guid's.
Hi sloan,

I don't think anyone's given you a straight answer - NewSequentialID
in SQL Server is essentially just exposing UuidCreateSequential from
rpcrt4.dll. You should be able to find the signature on PInvoke.net

Damien
Sep 8 '08 #17

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Scott Meddows | last post by:
In VB.net you can dim aGUID as System.GUID aGuid = Guid.NewGuid() >-----Original Message----- >Hi, >I need to know how to generate a GUID programmatically. I >basically want to use the...
8
by: Tamir Khason | last post by:
I want to build Guid Array so doing: Guid data = new Guid; .... and recieve an error "; expected" - What's the hell? TNX -- Tamir Khason You want dot.NET? Just ask: "Please, www.dotnet.us...
10
by: www.dir | last post by:
Hi, The following is from MSDN. "A GUID is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. Such an identifier has a...
3
by: Marty McDonald | last post by:
Using Visual Studio.Net... I have two classes, one derives from the other. My web service accepts the base class as input, it returns the derived class as the return value. When I set a web...
6
by: SevDer | last post by:
Is there a way to test guid string? I want to do it without try catch block to save on performance. Thanks in advance. -- SevDer
0
by: Tim Golden | last post by:
Robert Rawlins wrote: Not only is the answer, Yes: http://docs.python.org/lib/module-uuid.html but it's just featured as Doug Hellmann's module of the Week: ...
16
by: sloan | last post by:
Current Framework 2.0/3.0. ... In Sql Server, there is a way to generate consecutive guid's. newsequentialid. Is there a way to reproduce this type of consecutive guid's in the framework.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.