Failed To Convert Parameter Value From A Timespan To A Datetime

I am using SQL Server 2008. First I gave SqlDbType.Time for System.TimeSpan to the parameter type for Insert and Update. I works successfully. Now I changed to DbType.Time instead

Solution 1:

This is a confirmed bug in the current version of ADO.Net. Until, the next release, you need to use SqlDbType.Time.