how to add hours and minutes using canonical functions in linq

Question

My linq query now,

 return _db.Details
           .FirstOrDefault(c => c.Master.Id.Value == nId && 
                                c.Id == c.Master.Id && 
                                c.Alert.Va <= c.Va && 
                                DateTimeNowc.ValidityTill <= (EntityFunctions.AddHours(DateTime.UtcNow,5) &&
                                EntityFunctions.AddMinutes(DateTime.UtcNow,30)));

ERROR:

DateTime? EntityFunctions.Addminutes(DateTime?timevalue, int? addvalue) (+2 overload(s))

Invokes the canonical Add Minutes function. For Information about the canonical AddMinutes function, see Date and Time canonical Functions(Entity SQL).

Here I get line error enter image description here

Sorry, I forgot my telescope in my other pants. It looks really stupid if I squint at my display from 5 cm afar. Could you please post the error as text? — Marco, Feb 26 '14 at 08:08

score 1 · Answer 1 · answered Feb 26 '14 at 08:15

1

DateTimeNowc.ValidityTill <= (EntityFunctions.AddHours(DateTime.UtcNow, 5) &&
EntityFunctions.AddMinutes(DateTime.UtcNow, 30)));

You're trying to perform && on two DateTime instances. That's not gonna work.

You should place one method call within another:

EntityFunctions.AddMinutes(EntityFunctions.AddHours(DateTime.UtcNow, 5), 30));

answered Feb 26 '14 at 08:15

MarcinJuraszek

124,003
15
196
263

The thought to nest those methods did not occur to me even once, but I like it – Marco Feb 26 '14 at 08:23
i want to add hours 5 and minutes 30.. for this it will work? – Duk Feb 26 '14 at 08:49

score 0 · Answer 2 · answered Feb 26 '14 at 08:18

0

Your comparison syntax is wrong. If you try to compare if the time is <= 5hours 30 minutes, try to use just AddMinutes().

//5*60 minutes + 30 minutes
DateTimeNowc.ValidityTill <= EntityFunctions.AddMinutes(DateTime.UtcNow,330)));

answered Feb 26 '14 at 08:18

Marco

22,856
9
75
124

how to add hours and minutes using canonical functions in linq

2 Answers2