SqlDataReader.GetGuid with column name c#?

Question

Is there a way to get a column by name and retain the SQL type information returned by SqlDataReader?

I only see .GetGuid(int column)?

Answer 1

There is no separate method to get a GUID (or any of the other types) by column name directly.

What you need to do is this:

Guid someguid = dr.GetGuid(yourDataReader.GetOrdinal("your-col-name"));