LINQ Query to Convert string to datetime

by

If you need convert it with SQL you can try use SqlFunctions.DateAdd and just add zero interval.

var DateQuery = db.Order_Reports.Select(o => new demoDate {
    DueDate = SqlFunctions.DateAdd("day", 0, o.ReportDueDateTime), 
    OrderReportID = o.OrderReportID
 });

More Related Contents:

  1. Linq: help me to make this work
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  4. Entity Framework/Linq EXpression converting from string to int
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. Linq to EntityFramework DateTime
  7. How to convert an expression tree to a partial SQL query?
  8. Join and Include in Entity Framework
  9. Max return value if empty query
  10. Remove item from list based on condition
  11. How to do an “in” query in entity framework?
  12. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  13. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  14. How to include() nested child entity in linq
  15. Should the order of LINQ query clauses affect Entity Framework performance?
  16. Get all checked nodes of a treeview
  17. How to flatten tree via LINQ?
  18. Is DateTime.Now the best way to measure a function’s performance? [closed]
  19. Can I specify my explicit type comparator inline?
  20. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  21. How to compare only date components from DateTime in EF?
  22. Entity Framework 6 Code First Custom Functions
  23. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  24. Can I split an IEnumerable into two by a boolean criteria without two queries?
  25. ef4 cause Circular reference in web service
  26. Linq Syntax – Selecting multiple columns
  27. How to parse and generate DateTime objects in ISO 8601 format
  28. DateTime.Parse(“2012-09-30T23:00:00.0000000Z”) always converts to DateTimeKind.Local
  29. Convert Date from Persian to Gregorian
  30. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]

Leave a Comment