you can insert Time column value as TimeSpan.
saple code:[
^]
using (SqlConnection cn = new SqlConnection(connstring))
using (SqlCommand cmd = new SqlCommand("Insert into Events (EventName, EventStartTime) values (@Name, @Start)", cn))
{
cmd.Parameters.AddWithValue("@Name", "Thanksgiving Dinner (East Coast USA)");
cmd.Parameters.AddWithValue("@Start", new DateTimeOffset(2007, 11, 22, 16, 0, 0, new TimeSpan(-5, 0, 0)));
cn.Open();
cmd.ExecuteNonQuery();
}