DbArithmeticExpression arguments must have a numeric common type

by

Arithmetic with DateTime is not supported in Entity Framework 6 and earlier. You have to use DbFunctions*. So, for the first part of your statement, something like:

var sleeps = context.Sleeps(o =>
    DbFunctions.DiffHours(o.ClientDateTimeStamp, clientDateTime) < 24);

Note that the DiffHours method accepts Nullable<DateTime>.

Entity Framwork core (when used with Sql Server, maybe other db providers) supports the DateTime AddXxx functions (like AddHours). They’re translated into DATEADD in SQL.

*EntityFunctions prior to Entity Framework version 6.

More Related Contents:

  1. MetadataException: Unable to load the specified metadata resource
  2. Entity Framework with NOLOCK
  3. Encrypt password in App.config
  4. ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
  5. EF: Include with where clause [duplicate]
  6. Entering keys manually with Entity Framework
  7. The cast to value type ‘Int32’ failed because the materialized value is null
  8. Pass table valued parameter using ADO.NET
  9. Entity framework left join
  10. What are the downsides to turning off ProxyCreationEnabled for CTP5 of EF code first
  11. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  12. Calling Oracle stored procedure from C#?
  13. How to run multiple SQL commands in a single SQL connection?
  14. Entity Framework. Delete all rows in table
  15. Creating a SQL Server table from a C# datatable
  16. ToArrayAsync() throws “The source IQueryable doesn’t implement IAsyncEnumerable”
  17. EF4 Code First: how to add a relationship without adding a navigation property
  18. How to COUNT rows within EntityFramework without loading contents?
  19. Simulating Cross Context Joins–LINQ/C#
  20. Can you get the DbContext from a DbSet?
  21. Entity Framework | Sequence contains more than one matching element
  22. Check if list contains item from other list in EntityFramework
  23. Why is EF generating SQL queries with unnecessary null-checks?
  24. Entities VS Domain Models VS View Models
  25. How to do an “in” query in entity framework?
  26. big issue in converting string to datetime using linq-to-entities
  27. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  28. Stored procedure returns int instead of result set
  29. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  30. Migrations in Entity Framework in a collaborative environment

Leave a Comment