GetDate() using Entity Framework

Question

I am trying to use entity framework and get the date from the SQL server. The old way of doing this in LINQ is below but i'm needing something for the entity framework:

Partial Public Class ActivityActionsDataContext
<[Function](Name:="GetDate", IsComposable:=True)> _
Public Function GetSystemDate() As DateTime
    Dim mi As MethodInfo = TryCast(MethodBase.GetCurrentMethod(), MethodInfo)
    Return DirectCast(Me.ExecuteMethodCall(Me, mi, New Object() {}).ReturnValue, DateTime)
End Function

End Class

Answer 1

Have you tried using DateTime.Now or DateTime.UtcNow? I'd like to think that would be converted into GetSystemDate() by the query translator.

Answer 2

Search at google "efquerysamples" entity framework samples and download those good examples then look canonical function CurrentDateTime(), it worked with:

DateTime fecha = ServicioContexto.Contexto.CreateQuery("CurrentDateTime()").Execute(MergeOption.NoTracking).First();

I'd like to understand more about canonical functions. Please explain me. Thank you