Comparing DateTime in Entity Framework with an Sql Server Compact database

Question

Why this code throws a System.NotSupportedException telling that The specified method 'int? DateDiff(string, DateTime?, DateTime?)' on the type 'System.Data.Objects.SqlClient.SqlFunctions' cannot be translated into a LINQ to Entities store expression, though DateDiff has EdmFunction attribute?

context.Users.Where(f => System.Data.Objects.SqlClient.SqlFunctions.DateDiff("second", f.LastLogOn, somedatetime) < 0)

Yury Tarabanko · Accepted Answer · 2010-07-05 21:27:08Z

2

Here is a complete enumeration of canonical Date and Time functions supported by Entity SQL query provider link.

Try something like this

context.Users.Where(f=>EntityFunctions.DiffSeconds(f.LastLogOn, somedatetime)<0);

answered Jul 5, 2010 at 21:27

Yury Tarabanko

45.1k10 gold badges88 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Parsa Over a year ago

Thanks for answer, but this is SqlCe not Sql Server, it does not support any compare functions other than DateDiff.

Yury Tarabanko Over a year ago

As far as I understand this function will be translated into DateDiff. Give it a try :)

Dherik Over a year ago

For the Entity Framework version 6, consider to use DbFunctions.DiffSeconds

Collectives™ on Stack Overflow

Comparing DateTime in Entity Framework with an Sql Server Compact database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related