实体框架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();
}
}