Which field should I use in SQL Server to save a duration time? E.g.: 2Days 23H 47Min 00Sec.
If you have an example with Fluent API it will help a lot.
The correct .NET type for representing time durations is
It is possible to use the
Time type to store this data, according to this compatibility table .
Using .NET 6 onwards it is possible to adopt
Something that people usually do is also use an
BIGINT to store ticks or milliseconds or even seconds , according to the precision you need.
As the question does not give details, I cannot go beyond that.