SQL decimal equivalent in .NET

Question

What is the SQL (MS SQL Server) Decimal equivalent in .NET?

Should it be Double, Decimal or Float (Single in VB.NET)?

Answer 1

There's no exact equivalent type in .NET, as SQL's decimal type is fixed point, whereas .NET's System.Decimal type is a floating (decimal) point type.

However, System.Decimal is definitely the closest match, and should generally be what's used to represent the value stored in a decimal column in a SQL database.

Answer 2

Use Decimal, as can be seen in this table.