Devart Forums

Posted: **Tue 20 May 2014 10:54**

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?

Posted: **Wed 21 May 2014 11:50**

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.

Posted: **Wed 21 May 2014 12:33**

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?

Posted: **Fri 23 May 2014 13:17**

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.

Posted: **Mon 26 May 2014 09:47**

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

Thx, I've missed that moment..

Devart Forums

Get server time not local one for EF entity

Get server time not local one for EF entity

Re: Get server time not local one for EF entity

Re: Get server time not local one for EF entity

Re: Get server time not local one for EF entity

Re: Get server time not local one for EF entity