How to read sql_variant database type in C#

Question

Looking into System.Data.DbType there is no SqlVariant type there. SqlDataReader, for example, provides the GetString method for reading into string variable. What is the appropriate way to retrieve data from the database field of type sql_variant, presumably into object?

The aim is to read data stored as sql_variant type in database. Not to assign the value into variable of object type. I mentioned object type variable because I thing the sql_variant, if possible, would go into such type.

Rob · Accepted Answer · 2008-10-08 14:34:14Z

4

If you want to put the data into a variable of type object then (simplified):

object result = null;
result = reader["columnNameGoesHere"];

Should do the trick.

There's also a good explanation of the various different methods of retrieving the contents of a given columns current record in this DevHood tutorial. The summary table of data type mappings at the end may come in handy too!

edited Oct 8, 2008 at 14:34

answered Oct 8, 2008 at 14:21

Rob

45.9k24 gold badges126 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JEuvin · Accepted Answer · 2021-11-24 21:44:20Z

1

Sql_Variant is of type object.

Microsoft Docs

answered Nov 24, 2021 at 21:44

JEuvin

1,0361 gold badge15 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to read sql_variant database type in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related