SAP SQL Anywhere

Question

I'd like to get the Date part of a DateTime value in an .NET entity framework query. I am not able to workaround by retrieving the date part in c# because consider following example:

var result = context.Products
  .Select(p => p.SomeMappedSqlFunction(p.CreateDateTime.Date)) // .Date is not supported
  .ToList();

Following functions are not mapped to an sql function by Sybase:

Date property of DateTime
System.Data.Objects.EntityFunctions.TruncateTime
System.Data.Entity.TruncateTime

The only solution i could imagine right now would be to write an sql function my own which does the conversion and map it to my edmx scheme. Is there really no out function mapped which converts/casts DateTime to Date?

Thank you very much ;)

Accepted Answer

0	I ended up mapping the date(...) function in my edmx scheme. permanent link answered 17 Sep '15, 05:36 dIeGoLi 1●1●1●3 accept rate: 50% flat view

SAP SQL Anywhere

EntityFramework get Date part of a DateTime

Follow this question

Related questions