title: LINQ to SQL Math.Round Problem
body: <p>I'm having an issue with a query I wrote where for some reason the variable that I'm using to store a decimal value in returns 6 values after the decimal place (they're mostly 0). </p>
  
  <p>I have tried the following (and different combinations using Math.Round) with no luck.</p>
  
  <pre><code>Sales =
            (from invhed in INVHEAD 
             ... // Joins here
             orderby cust.State ascending
             select new Sale
             {
                  InvoiceLine = inv.InvoiceLine,
                  InvoiceNum = inv.InvoiceNum,
                  ...
                  NetPrice = Math.Round((inv.ExtPrice - inv.Discount) * (Decimal) (qsales.RepSplit / 100.0), 2, MidpointRounding.ToEven),
             }).ToList&lt;Sale&gt;();
  </code></pre>
  
  <p>The NetPrice member has values like 300.000000, 5000.500000, 3245.250000, etc.</p>
  
  <p>Any clues? I can't seem to find anything on this issue online.</p>
  
  <h1>EDIT:</h1>
  
  <p>Decimal.Round did the trick (I forgot to mention that the NetPrice member was a Decimal type). See my answer below.</p>