SQLTime not assigned to TimeSpan

[reibanaag]

Hi,

Good Day!

There seemed to be an issue when retrieving time data type because it is always null when it was mapped to timespan in c#.

This is the table:

CREATE TABLE [dbo].[DeliverySchedule]
(
[Id] INT IDENTITY(1,1) PRIMARY KEY,
[ArrivalTime] TIME NOT NULL DEFAULT N'10:00:00'
);
GO

[Dapper.Table("DeliverySchedule")]
public class DeliverySchedule
{
public virtual Int32 Id { get; set; }
public virtual TimeSpan ArrivalTime { get; set; }
}

in my code

var deliveries = conn.GetListAsync().Result;

but when I check the deliveries the Id field was assigned but the ArrivalTime is still null

I hope you can help me with this.

Thank you.

[BlinkSun]

The type DateTime work perfectly from my side ... to convert to TimeSpan, look at those solutions:
https://stackoverflow.com/questions/1026841/how-to-get-only-time-from-date-time-c-sharp