Which sql server data type best represents a double in C#? [duplicate]

Is it money, float, real, decimal, _________ ?


Solution 1:

Answer to this and all mapping of types can be found here.

SQL-CLR Type Mapping

Chart, stolen from that page:

enter image description here


Updated 1/7/2013 - there's a more recent version, .not so colorful here: SQL Server Data Type Mappings

Solution 2:

That would be float.

See Mapping CLR Parameter Data.

Solution 3:

Float is the sql type you are looking for.