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

c# sql sql-server tsql double
CloudMeta picture CloudMeta · Sep 17, 2009 · Viewed 49.1k times · Source

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

Answer

David picture David · Sep 17, 2009

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

Related questions

What represents a double in sql server?

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what is best to use, decimal or float? This …

Read More
Generate class from database table

How can I generate a class from a SQL Server table object? I'm not talking about using some ORM. I just need to create the entities (simple class). Something like: public class Person { public string Name { get;set; } public string …

Read More
SQL error: Incorrect syntax near the keyword 'User'

I am using SQL to insert data to SQL Database file using C# as follows. String cs = System.Configuration.ConfigurationManager.ConnectionStrings["connection1"].ConnectionString; SqlConnection conn = new SqlConnection(cs); String sql = "INSERT INTO User (login, password, status) " + "VALUES (@login, @password, @status)"; …

Read More