title: When I add value to SqlDataRecord number is rounding
body: <p>When I add a value to my SqlDataRecord some how it is round the value.  I am not sure what is causing it.</p>
  
  <p><strong>EDIT:</strong> John made a good point Left out the property type for dm which is "decimal?"</p>
  
  <pre><code>TotalCount = 2.5245332200983
  
  SqlDataRecord rec = new SqlDataRecord(
                  new SqlMetaData("TotalCount", SqlDbType.Decimal));
  
  rec.SetNullableDecimal(0,dm.TotalCount);
  
  When it is written to the DB it is showing 3.0000000000000
  </code></pre>
  
  <p>Database Type added so I can pass a TVP:</p>
  
  <pre><code>CREATE TYPE dbo.TestCount AS TABLE(
  TotalCounts decimal(38,20) NULL
  );
  </code></pre>
  
  <p>Database Table:</p>
  
  <pre><code>CREATE TABLE dbo.TestCountTbl(
  TotalCounts                 decimal(38,20) NULL);
  </code></pre>
  
  <p>What am I doing wrong? Is the SqlDbType wrong? </p>
  
  <p><strong>EDIT:</strong> Per @user957902 I had to add precision / scale to my SqlDataRecord....totally makes sense...duh.  So I added that and works like a charm.   Thanks All!</p>
  
  <pre><code>SqlDataRecord rec = new SqlDataRecord(
                  new SqlMetaData("TotalCount", SqlDbType.Decimal,38,20));
  </code></pre>