What is the correct SQL type to store a .Net Timespan with values > 24:00:00?

by

I’d store it in the database as a BIGINT and I’d store the number of ticks (eg. TimeSpan.Ticks property).

That way, if I wanted to get a TimeSpan object when I retrieve it, I could just do TimeSpan.FromTicks(value) which would be easy.

More Related Contents:

  1. How do you effectively model inheritance in a database?
  2. How does SQLParameter prevent SQL Injection?
  3. Like Operator in Entity Framework?
  4. Why did a network-related or instance-specific error occur while establishing a connection to SQL Server?
  5. How can I solve a connection pool problem between ASP.NET and SQL Server?
  6. Login failed for user ‘DOMAIN\MACHINENAME$’
  7. How to find foreign key dependencies in SQL Server?
  8. Update primary key value using entity framework
  9. A connection was successfully established with the server, but then an error occurred during the pre-login handshake
  10. What’s the best method to pass parameters to SQLCommand?
  11. What’s a good way to trim all whitespace characters from a string in T-SQL without UDF and without CLR?
  12. SqlDateTime.MinValue != DateTime.MinValue, why?
  13. Using “GO” within a transaction
  14. How to solve “unable to switch the encoding” error when inserting XML into SQL Server
  15. CLR Strict Security on SQL Server 2017
  16. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  17. Procedure expects parameter which was not supplied
  18. Does End Using close an open SQL Connection
  19. Does this code prevent SQL injection?
  20. TSQL md5 hash different to C# .NET md5
  21. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  22. Can you round a .NET TimeSpan object?
  23. How can you name the Dataset’s Tables you return in a stored proc?
  24. How to I serialize a large graph of .NET object into a SQL Server BLOB without creating a large buffer?
  25. Unable to load DLL ‘SqlServerSpatial.dll’
  26. .NET, the SqlConnection object, and multi-threading
  27. Implementing transactions over multiple databases
  28. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
  29. Using a variable for table name in ‘From’ clause in SQL Server 2008
  30. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?

Leave a Comment