>>>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.
>
>I have confirmed that both statements are equivalent.
Equivalent result. But I'm with Cetin - the cast will be more efficent....