« Nobody should ever have direct access to the database tables
Should Float or Decimal data type be used for dollar amounts? »

SQL Server and .NET Framerwork use a different default algorithm for rounding

Just as an additional warning, SQL Server and the .Net framework use a different default algorithm for rounding. Make sure you check out the MidPointRounding parameter in Math.Round(). .Net framework uses Bankers algorithm by default and SQL Server uses Symmetric Algorithmic Rounding.

This entry was posted on Thursday, April 16th, 2009 at 11:38 pm and is filed under .NET Framework. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.