title: Specified cast is not valid.In VS2015 c# getting data from a sql
body: <p>I have a SQL with this columns and the class with de info of the data in the sql (in VS):</p>
  
  <p><a href="https://i.stack.imgur.com/cpjc9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cpjc9.png" alt="enter image description here"></a></p>
  
  <p>the class that makes a List:</p>
  
  <p><a href="https://i.stack.imgur.com/ZlcJG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZlcJG.png" alt="enter image description here"></a></p>
  
  <p>here is the problem, when a execute this lasts commands VS say: "An unhandled exception of type 'System.InvalidCastException' occurred in System.Data.dll"</p>
  
  <p>this happen with the lines:</p>
  
  <pre><code>pt3.datetime = reader.GetDateTime(5);
  
  pt3.time= reader.GetTimeSpan(7);
  
  pt3.test_time = reader.GetInt32(8);
  
  pt3.no_load_current_ext = reader.GetDecimal(10);
  </code></pre>
  
  <p>I think is the SQL but it looks fine, and i try to change the type, but that nnot work</p>