SQL Server Float and Real datatypes

Mark · Jan 3, 2005

What are the best .NET datatypes to handle SQL Server's Float and Real
datatypes? I'd like to avoid using the SQL Server specific datatypes like
SqlInt32 or similar.

Thanks in advance.

-Mark

Sahil Malik · Jan 3, 2005

SqlDouble Float

and
SqlSingle Real

Though highly recommended that for talking to the d/b you should use
SqlDbType.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

Mark · Jan 3, 2005

And if I still didn't want to use the SqlXxxxx datatypes, which .NET
datatypes would work best? Thanks again.

Mark

Sahil Malik · Jan 3, 2005

Okay I should have been a bit clearer. Here is the conversion you need --

Native Sql Server Float --> System.Data.SqlTypes.SqlDouble --> .NET DataType
Double
Native Sql Server Real --> System.Data.SqlTypes.SqlSingle --> .NET
DataType Single

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik