best way to handle sql decimal fields

[Steve Richter]

I have having a hard time getting the numeric columns in my sql tables
to map correctly to .NET. I have a price and a cost column in a
table. What is the most .NET friendly way to declare those columns?

cmd = new SqlCommand("CREATE TABLE ItemMaster ( " +
"ItemId INT PRIMARY KEY," +
"ItemDesc varChar(80), " +
"Price Numeric(7,2), " +
"Cost Numeric(7,2)",
conn);

new SqlParameter( "@Price", SqlDbType.Money ) ; // ??????

System.Decimal cost ;
SqlDataReader reader ;
cost = reader.GetSqlMoney(3) ; // ?????????????????

thanks,
-Steve

 

[Guest]

Use Money on database side and Decimal on .NET side. I recommend using
GetDecimal instead of GetSqlMoney.

 

[Jeremy S.]

<< I recommend using GetDecimal instead of GetSqlMoney >>

Why?

 

[Guest]

GetSqlMoney is specific to SqlDataReader. GetDecimal is in the IDataRecord
interface. If you are planning to abstract your database access, then you
don't want to make calls that are specific to any particular provider.