R
Ronald S. Cook
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
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