Re: Should I use SQL data type money or decimal given .NET datatype is decimal?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ronald,

Why disregard? Care to say what conclusions you came to?

Personally, I think that if you are going to store money values in the
database, then money is fine. However, if the table you are storing values
on is an intermediate table which will store values performed on money and
then have more calculations performed on those results, then you should use
decimal with a much larger scale.

For example, say you have a Product table, with a Price field which is
the price for the Product. This price should be Money.

Now, if you had an intermediate table, with an average of how much money
was spent per customer, then that field should be decimal, with a larger
scale. The reason for this is that if you use those averages as inputs into
calculations later, then you don't want a truncation of values before the
money values go into the calc.

But then again, maybe you do, it all depends on what the accuracy you
need. Personally, I like to have as many places as possible being stored
(given practical limitations) and used for my intermediary calcs and then
perform the final rounding when the results are presented back to the user.

--
- Nicholas Paldino [.NET/C# MVP]
- mvp@xxxxxxxxxxxxxxxxxxxxxxxxxxx

"Ronald S. Cook" <rcook@xxxxxxxxxxxx> wrote in message
news:Oxr8rWpfHHA.4936@xxxxxxxxxxxxxxxxxxxxxxx
Please disregard this -thx


"Ronald S. Cook" <rcook@xxxxxxxxxxxx> wrote in message
news:%23CdGyxkfHHA.208@xxxxxxxxxxxxxxxxxxxxxxx
We're designing the data model for a project. The app will be in .NET,
the database will be in SQL Server 2005.

I'm a little confused on type conversion between the two and which I
should choose.

I found this good comparison chart:
http://msdn2.microsoft.com/en-us/library/ms131092.aspx

But for monetary amounts, it looks like decimal is how .NET is going to
store the value. So then, should I go with decimal in the database for a
nice match? But then it looks like money would be a good choice.

How do I know which I should ideally choose?

It would be nice if all the types exactly matched up between the
platforms.

Thanks,
Ron






.

Relevant Pages

  • Re: Question about a price discount adjustment on item purchased already?
    ... >> the pan never opened or used, they have to give me back my money. ... >> back to your card if u used one no matter what store it is. ... >> case, i used my credit card, so they would have to credit it back. ... >> Again, my question was price adjustment which they wouldn't give, so i ...
    (rec.food.cooking)
  • Zimbabwe Experience - Part 2
    ... The good Lord gave me my money. ... Zimbabwe experiences such leaps on an hourly basis! ... impose price and wage controls. ... Hungry crowds gathered outside whenever police entered a store ...
    (soc.culture.zimbabwe)
  • Re: Question for Aussies - Re: Import duty on lenses from the US.
    ... Americans got greedy, we always wanted a deal, save money, so, the ... there are very few "good manufacturing jobs left here now". ... "Americans wanted to get a deal"!. ... camera store will be gone, why, because everyone wanted a deal. ...
    (rec.photo.digital.slr-systems)
  • Re: Solving the piracy problem for good (was Re: SF Author incomes)
    ... >> A third issue is local price variation. ... >> store today exhibits this: a track sells for US $0.99 and ... Are you saying that the color of money SHOULD ... > Maybe I didn't understand your scheme as well as I thought I did. ...
    (rec.arts.sf.written)
  • Re: Best Buy SUCKS
    ... I didn't have a money issue with them, but I won't go back because every ... I went to the store ... > bank online to make sure that the item had not been charged to my debit ... Not only did they charge me after they said ...
    (sci.med.transcription)