get date part only from datetime value using entity framework

by

You can compare just specified parts:

context.tblvalue.Any(x => x.date.Year == data.Year 
                        && x.date.Month == data.Month 
                        && x.date.Day == data.Day);

EDIT:
You can also try the following:

context.tblvalue.Any(x => EntityFunctions.TruncateTime(x.date) == data.Date);

Another approach:

context.tblvalue.Any(x =>  SqlFunctions.DatePart("year", x.date)  == data.Year 
                        && SqlFunctions.DatePart("month", x.date) == data.Month 
                        && SqlFunctions.DatePart("day", x.date)   == data.Day);

More Related Contents:

  1. System.IndexOutOfRangeException: Cannot find table 0
  2. Solving “The ObjectContext instance has been disposed and can no longer be used for operations that require a connection” InvalidOperationException
  3. Read data from SqlDataReader
  4. Entering keys manually with Entity Framework
  5. Entity Framework (EF) Code First Cascade Delete for One-to-Zero-or-One relationship
  6. How can I retrieve Id of inserted entity using Entity framework? [closed]
  7. Entity Framework Join 3 Tables
  8. Entity Framework Timeouts
  9. Getting data from stored procedure with Entity Framework
  10. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  11. Entity Framework Refresh context? [closed]
  12. Format of the initialization string does not conform to specification starting at index 0
  13. What is the right way to populate a DropDownList from a database?
  14. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  15. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  16. Non-static method requires a target
  17. The instance of entity type cannot be tracked because another instance of this type with the same key is already being tracked
  18. Creating Composite Key Entity Framework
  19. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  20. The result of a query cannot be enumerated more than once
  21. Entity Framework – retrieve ID before ‘SaveChanges’ inside a transaction
  22. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  23. Mapping Database Views to EF 5.0 Code First w/Migrations
  24. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  25. EF migration for changing data type of columns
  26. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  27. ASP.NET Identity – Multiple object sets per type are not supported
  28. The entity type ApplicationUser is not part of the model for the current context
  29. User in Entity type MVC5 EF6
  30. Unable to find the requested .Net Framework Data Provider. It may not be installed

Leave a Comment