difference between Guid.newGuid() and newid()

Question

1.00/5 (1 vote)

See more:

can you help me in determining the difference between the first function in c#
and the second one in Sql
if i use Guid.newGuid() can i guarantee that will be no conflict in ids if i have multiple data sources each one on a machine when i join them together
i read that the first version of Guid Generates the id depending on machine mac and timestamp which i think can insure uniqueness in multiple datasources on different machines am i wrong?
my second question is how can i determine the version of function Guid.newGuid in C#

Posted 26-Nov-14 22:03pm

oula alsheikh

Add a Solution

Comments

Maciej Los 29-Nov-14 4:34am

What's this for?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Answer 1 · 2014-11-26T22:07:00

Solution 1

1.Yes, by using Guid class, the resulted ID will be unique for all cases, and this was the propose of the GUID. You could find detail in the MDSN[^].

2.The second question is not clear. What do you want to check/do?

Posted 26-Nov-14 22:07pm

Raul Iloc

Comments

oula alsheikh 29-Nov-14 2:48am

thanks i got confused because of this two pages
can you please read them
http://stackoverflow.com/questions/18472251[^]

http://forums.asp.net/t/364242.aspx[^]

Raul Iloc 29-Nov-14 8:33am

You could use GUID in your application without fear, because their algorithms were designed to assure uniqueness!

oula alsheikh 29-Nov-14 2:50am

what about newid() in sql does it guarantees uniqueness?

Raul Iloc 29-Nov-14 8:32am

This function also generate a GUID that could be used in SQL tables, and because is an GUID is unique.