title: What is the correct SQL type to store a .Net Timespan with values > 24:00:00?
body: <p>I am trying to store a .Net <code>TimeSpan</code> in SQL server 2008 R2. </p>
  
  <p>EF Code First seems to be suggesting it should be stored as a <code>Time(7)</code> in SQL. </p>
  
  <p>However <code>TimeSpan</code> in .Net can handle longer periods than 24 hours. </p>
  
  <p>What is the best way to handle storing .Net <code>TimeSpan</code> in SQL server?</p>