实体框架7:获取数据库时间

问题描述:

在EF7中获取数据库服务器时间的最佳方法是什么?到目前为止,我发现我不支持使用输出参数查询。

What is the best method to get the database server time in EF7? I discovered so far that is currently no support for query with output parameters.

使用ADO.NET方法完成:

Done using ADO.NET approach:

public DateTime GetServerUtcNow()
{
    using (var connection = new SqlConnection(_settings.ConnectionString))
    {
        connection.Open();
        var command = connection.CreateCommand();
        command.CommandText = "select SYSUTCDATETIME()";
        return (DateTime)command.ExecuteScalar();
    }
}