>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