2

I have a client-server architechture where all the processes connects to the same database (SQL Server) and all the communication between the processes is done through the database. I use LINQ (System.Data.Linq.DataContext) to interact with the database.

Since the different processes may have assynchronous times, and comparing DateTimes is something very relevant to my application, I want whenever a process needs to write the current DateTime in the database, I want it to use the current time of the SQL Server, instead of the OS current time. It may need the SQL Server's time also to compare with values it reads.

My question is basically how to access the SQL Server time through LINQ; that would be enough to I make what I want, but any better suggestion is appreciated.

André Santaló
  • 639
  • 1
  • 9
  • 24

1 Answers1

4

You can have a trigger or a default value for the date/time field so that the time inserted is obtained from the database and not passed from your client to the server. Example 1: SQL Server Default Date Time Example 2: SQL Server Trigger for date update.

Community
  • 1
  • 1
NoChance
  • 5,632
  • 4
  • 31
  • 45
  • I agree. If that date-stamp is critical to you (the OP), then handling it at the db level makes more sense. Upvote for this response. – granadaCoder Oct 21 '13 at 20:10