Working with data that has no data type

I am trying to write an application



Product Lot (individual)


Procedures (many procedures per product)


SQL_Variant data (one variable per procedure)
 Each product is made using a different list of procedures.  Each procedure can have a user defined variable attached to it of a user defined data type.  The datatype will be a Byte corresponding with a small table of TINYINT's and VARCHAR(16)s.  I am currently trying to write the ObjectVariable class that has the fields:

private Int64 _variableid;

private Object _data;

private Byte _datatypelookup;

private Type _datatype;

 

My question is, for example, if I have an object with an Int32 stored in the SQL_Variant field in the database and that corresponds to looking up the Byte (record number 1) in the datatype lookup table (so I know that the user ...