using datediff in entityframework entity-sql

Question

I want to do something like this using EntityFramework entity-sql query. I am using .Net3.5

StringBuilder query = new StringBuilder(@"
                Select VALUE o
                From ordercontainer.report as o
                WHERE o.xId = @xId
                ");

query.Append("  && datediff(hh,getdate(),o.StatusChangeTimeStamp) >= @DurationInHours");

maybe you can use this object `System.Data.Objects.SqlClient.SqlFunctions` — Alexandre Rondeau, Oct 10 '13 at 15:39
thanks allo.. but that class is there from .net4 onwards... am using .net 3.5 framework.. — krishnakumar, Oct 11 '13 at 07:54

score 0 · Answer 1 · edited Oct 29 '13 at 07:52

0

Use this method in .NET 3.5

System.Data.Linq.SqlClient.SqlMethods.DateDiffHour(startDate, endDate);

See msdn site

This class contains several more Methods that can be used in .NET3.5

edited Oct 29 '13 at 07:52

Touki

7,465
3
41
63

answered Oct 22 '13 at 22:33

Yakov R.

602
8
22

using datediff in entityframework entity-sql

1 Answers1