Is there possibility to get difference between two dates in LINQ-to-Entity?
Thanks
Get difference between dates in LINQ-to-Entity
This function is available in Entity SQL only.
Here is a sample to get the interval:
and a sample to use it in the Where method:
Please note that this functionality will be available only in the next build.
Here is a sample to get the interval:
Code: Select all
select Devart.Data.Oracle.DateInterval(, ) from
Code: Select all
db.Emps.Where("Devart.Data.Oracle.DateInterval(it.FIREDATE, it.HIREDATE) > @p", new ObjectParameter("p", new TimeSpan(30, 0, 0)));