GetUTCDate with Entity Framework

Question

I saw this question (http://stackoverflow.com/questions/1888004/entity-framework-getutcdate): "Can I use the SQL-function getutcdate() from entity framework to set a date field in the database when saving an entity object?" with this answer from Craig Stuntz: "Yes, you can do this. The CLR function DateTime.UtcNow is mapped to the canonical function CurrentUtcDateTime, which should translate, for SQL Server to GETUTCDATE() or similar."

Can somebody provide me a code snippet how to do this?

Thanks

Answer 1

var q = from e in MyContext.SomeEntities
        select new 
        {
           Entity = e,
           Utc = DateTime.UtcNow
        };

I just tried this in LINQPad; it works.