LINQ to Entities for subtracting 2 dates

by

The accepted answer is better in this case, but for reference you can use the EntityFunctions class to perform operations on dates, among other things.

where (vid.CreatedDate >= EntityFunctions.AddDays(DateTime.Now, -maxAgeInDay))

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  3. The specified type member ‘Date’ is not supported in LINQ to Entities Exception
  4. Best way to check if object exists in Entity Framework? [closed]
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Include Grandchildren in EF Query
  7. LINQ To Entities + Include + Anonymous type issue
  8. Why does EF5 code first use datetime2 when inserting a nullable datetime into the database?
  9. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())
  10. ‘Contains()’ workaround using Linq to Entities?
  11. EF Core Second level ThenInclude missworks
  12. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  13. Method cannot be translated into a store expression
  14. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  15. Disable lazy loading by default in Entity Framework 4
  16. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  17. Entity Framework One-To-One Mapping Issues
  18. How can I delete 1,000 rows with EF6?
  19. How to exclude one table from automatic code first migrations in the Entity Framework?
  20. Entity Framework : How do you refresh the model when the db changes?
  21. Entity framework code first creates “discriminator” column
  22. EF Migrations: Rollback last applied migration?
  23. Using EF Core ThenInclude() on Junction tables
  24. How to update not every fields of an object using Entity Framework and EntityState.Modified
  25. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  26. What goes into DbContextOptions when invoking a new DbContext?
  27. Entity Framework Validation confusion – maximum string length of ‘128’
  28. Number of members in conceptual type does not match with number of members on object side type
  29. Delete an object and all of its related entities in Entity Framework
  30. Entity Framework Core 2.0 – Run migrations step by step

Leave a Comment