How to use TIME datatype in SQL Server 2008 and C#?

Question

I am developing a web application with C# & SQL Server 2008.

I have a data reader which reads the column PlayTime, defined as TIME datatype.

I want to write a function that returns PlayTime's value.

private static Timespan GetTime(IDataReader rdr, string columnName)`
{
    int index = rdr.GetOrdinal(columnName);

    if (rdr.IsDBNull(index))
    {
      return ; // Here I want to return null or zero 
    }

    return (TimeSpan)rdr[index];
}

1. Am I right using Timespan for time data type?

2. How to return null if datareader value is nothing?

Best Regards,

RedsDevils

Answer 1

Something like this:

private static TimeSpan? GetTime(IDataReader rdr, string columnName)
{
    int index = rdr.GetOrdinal(columnName);
    if (rdr.IsDBNull(index))
    {
      return null;
    }
   return (TimeSpan)rdr[index];
}