Get server time not local one for EF entity

[bairog]

I use dotConnect for SQLite 5.2.146 + Entity Framework 6.1.0 and Code-First approach.

Suppose I have a following Entity:

Code: Select all

public class User
    {
        [Key]
        public int Id { get; set; }
        public String Name{ get; set; }
        public DateTime LastOperationDate{ get; set; }
    }

My database is located on server.
What I want to achieve is LastOperationDate to be server time, not my local machine time.

So what should I use instead of

Code: Select all

LastOperationDate = DateTime.Now

Maybe some SQL?

[Shalex]

Please make the code to generate the LastOperationDate column in the database with the datetime('now') default value. You can set sql default value with Code-First Migrations.

[bairog]

I'm not only talking about field's default value.
LastOperationDate is updated frequenty

Code: Select all

private void UpdateUser(int Id, String NewName)

LastOperationDate should be set to server time, at which that function above was called.
What should I use in that case?

[Shalex]

SQLite is a local database. Even if you locate the file of database remotely in local network, the database engine (sqlite3.dll) will be placed on the workstation where the code is executed. So datetime('now') in SQL will be equal to DateTime.Now in .NET code.

[bairog]

So datetime('now') in SQL will be equal to DateTime.Now in .NET code.

Thx, I've missed that moment..