What can be used with MySQL instead of EntityFunctions.DiffMilliseconds

Asked Nov 15 '16 at 13:44

Active Nov 15 '16 at 13:44

Viewed 58 times

I have to OrderBy and Filter by TotalTime - computed value between Finish and Start. Previously, with MS SQL I was using

records = records.OrderByDescending(o =>  (o.LastRunStart != null) ? EntityFunctions.DiffMilliseconds(o.LastRunFinish ?? DateTime.UtcNow, (DateTime)o.LastRunStart) : 0);

But with MySql it is not working. Is there any useful method in EF for MySql that can by used in select?

asked Nov 15 '16 at 13:44

1gn1ter

1,414
2
22
47

what you mean `MySql it is not working.` ?? any error? – Juan Carlos Oropeza Nov 15 '16 at 14:02
"FUNCTION .DiffMilliseconds does not exis"t or other DiffDays or like this – 1gn1ter Nov 15 '16 at 14:17
You can always create a `list` from your mySql and then make the sort there. – Juan Carlos Oropeza Nov 15 '16 at 14:19
I know, but it's better to filter, to order, and apply paging on sql server and get 10 results / otherwise sort list will sort list on the app server in memory – 1gn1ter Nov 15 '16 at 14:23
maybe check this one http://stackoverflow.com/questions/5752939/entityfunctions-support-in-mysql – Juan Carlos Oropeza Nov 15 '16 at 14:26
Please provide `SHOW CREATE TABLE` so we have some clue of what you are working with. – Rick James Nov 29 '16 at 07:00
May be view can be a good solution? – 1gn1ter Dec 14 '16 at 09:43

What can be used with MySQL instead of EntityFunctions.DiffMilliseconds

0 Answers0