Numeric (3,2) data type - map to C#

• rongrzywacz

  SSC Veteran

  Points: 266

  More actions

  May 20, 2008 at 1:06 pm

  #187979

  I inherited a DB with a lot of fields defined as Numeric (3,2).

  How do these map to C# data types. That is, what datatype should the C# programs use to read these fields when these data types are returned in a stored procedure.

  Thanks for any help ..

  Ron G

• GSquared

  SSC Guru

  Points: 260824

  More actions

  May 20, 2008 at 1:53 pm

  #818202

  Numeric(3,2) is any number between -9.99 and 9.99, with up to 2 digits after the decimal place. Not sure what that maps to in C#, but it's a pretty small range of decimal numbers.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon