TimeSpan SqlLite

I use Dapper.Contrib with SqlLite and it does not work.

create table mytable (
    id integer primary key,
    duration text not null,
);
insert into mytable(duration) values ('0.01:00:00');

C# code

[Table("mytable")]
public class ClientTest
{
        public long Id { get; set; }
        public TimeSpan Duration { get; set; }
}

Got error:

System.Data.DataException: Error parsing column 4 (duration=0.01:00:00 - String)

When I write a TypeHandler:

public class TimeSpanHandler : SqlMapper.TypeHandler<TimeSpan>
{
    public override TimeSpan Parse(object value)
    {
        return TimeSpan.Parse((string)value);
    }

    public override void SetValue(IDbDataParameter parameter, TimeSpan value)
    {
        throw new InvalidOperationException("Never called!");
        //parameter.Value = value.ToString();
    }
}

Then it works fine for query and update, too. That's a mistake since SetValue is never called.

So we have a 2 bugs:

1. TimeSpan for SqlLite does not work by default.
2. TypeHandler is called just Parse, the SetValue is never called.

Start by reproducing the SQLite query and update using the shown ClientTest model and TimeSpanHandler. Inspect how Dapper.Contrib handles TimeSpan values and how TypeHandler invokes Parse and SetValue; done means default TimeSpan reads work and the handler's write path is exercised for updates.