Type "Time" in SQL Server and C#

Question

Is there any way that I can create the type time in C# to be compatible with the type time of the SQL server?

Answer 1

According to MSDN:

Mapping CLR Parameter Data

You're looking for the TimeSpan type.

Answer 2

try using the below date formatter in C#.

DateTime dateTime = DateTime.Now; string text = dateTime.ToString("yyyy'-'MM'-'dd HH':'mm':'ss.fff");

This will lead to the same format as sql date format 'yyyy-mm-dd hh:mm:ss.fff'

Thanks!