Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting SQL Server uniqueidentifier to .NET Guid type
Message
 
 
To
24/03/2009 10:35:28
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01391015
Message ID:
01391019
Views:
53
>Hopefully somebody can provide a better way of doing this. The UserId field in my datareader is uniqueidentifier type in SQL Server.
>
>
>Guid UserId = new Guid(Convert.ToString(reader["UserId"]));
>
>
>Would this be better (more efficent):
>
>Guid UserId  = (Guid) reader["UserId"];
>
>
>Overall, is it better to use the System.Convert method or do a cast like the second example?

The two statements are not equavalent. In the first I think you're creating a new Guid. The last statement just takes the existing value and assigns it to a variable. I would assume the second is more efficient.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform