DbFunctions.TruncateTime LINQ equivalent in EF CORE

by

In EF6 DbFunctions.TruncateTime is used instead of DateTime.Date property because for some reason the later is not supported.

In EF Core the former is not needed simply because DateTime.Date now is recognized and translated correctly.

group events by events.DateTimeFrom.Date into dateGroup

Unfortunately there is no documentation (yet) of what is supported, so as a general rule of thumb, always try the corresponding CLR method/property (if any) and check if it translates to SQL and how.

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. Import CSV to SQLite
  5. Difference between 2 dates in SQLite
  6. Select random row from a sqlite table
  7. Dynamically access table in EF Core 2.0
  8. How to get Top 5 records in SqLite?
  9. Sqlite primary key on multiple columns
  10. SQLite Schema Information Metadata
  11. Can SQLite support multiple users?
  12. Export from sqlite to csv using shell script
  13. SQLite: How do I save the result of a query as a CSV file?
  14. Create table in SQLite only if it doesn’t exist already
  15. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  16. SQLITE_BUSY The database file is locked (database is locked) in wicket
  17. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  18. Sqlite over a network share [closed]
  19. SQLite table constraint – unique on multiple columns
  20. How to auto create database on first run?
  21. EF Core queries all columns in SQL when mapping to object in Select
  22. Is there a boolean literal in SQLite?
  23. Entity Framework core – Contains is case sensitive or case insensitive?
  24. sqlite get ROWID
  25. How to have an automatic timestamp in SQLite?
  26. SELECT INTO statement in sqlite
  27. How to display blob value using x’abc’ binary string literal syntax?
  28. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  29. How to get the number of rows of the selected result from sqlite3?
  30. How to get the last index of a substring in SQLite?

Leave a Comment