Error in converting decimal to float in a SqlDataRecord

Question

I have a SqlMetaData array defined as:

SqlMetaData[] _TvpSchema = new SqlMetaData[]{
     new SqlMetaData("Duration", SqlDbType.Float)
};

And SqlDataRecord for it as :

SqlDataRecord _DataRecord = new SqlDataRecord(_TvpSchema);

And filling this record as:

_DataRecord.SetFloat(4, (float)obj.Duration);

Where obj.Duration is decimal type and has value as 0. I am getting Exception of Invalid Cast at the above line. I tried Convert.ToSingle also, but got the same error. What I might be doing wrong in this case?

Najkin · Accepted Answer · 2017-10-26 07:21:46Z

2

A SQL Float is a .Net double according to SqlDbType documentation. If you really need to use a .Net float, use the SQL Real type, otherwise, just use SetDouble and cast your decimal to double.

answered Oct 26, 2017 at 7:21

Najkin

9321 gold badge7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Error in converting decimal to float in a SqlDataRecord

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related