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

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

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: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: SQL Licensing
    ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
    (microsoft.public.sqlserver.clients)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: MSVC++ app type choice, form design questions
    ... >> 1) MSVC Project definition requires that for an MFC app I choose ... At startup the end user sees a summary of the database contents. ... MDAC has full built-in support ... >competing with the full version of SQL Server, ...
    (microsoft.public.vc.mfc)
  • Integrated Security in a Workgroup?
    ... I'm trying to set up a development environment for developing an ASP.Net app ... that needs to access an SQL Server 2000 database. ... On machine "B" (where the SQL Server is running) I had no problem setting up ...
    (microsoft.public.sqlserver.security)