C#.net 2008 columns correspond to sql server column sizes

Question

Can you point me to a reference that shows what sql server 2008 r2 data types are equivlent to in C#.net 2008?

I have fields i n sql seerver 2008 r2 that are size number(18,0). What size in a C#.net 2008 desktop application would this be equivalent to?

Vulpes · Answer

The following link may help ( http://msdn.microsoft.com/en-us/library/cc716729.aspx ). I'd imagine that if you have a number with precision (18 0) in SQL Server then it will be of the decimal type. The C# decimal type to which the SQL type naturally maps can deal with numbers with up to 28 digits and so can easily accommodate 18.