FUNCTION database.AddDays does not exist

Asked Jun 27 '14 at 00:22

Active Jun 27 '14 at 00:22

Viewed 1,176 times

I'm trying to use dbfunction from EF6 on database MySQL but I get the follow exception "FUNCTION database.DiffDays does not exist".

I used this code:

var aux = bd.Atos.Where(w => w.IdAtivo == 1 && w.IdUtilizador == idUtilizador && DbFunctions.DiffDays(DbFunctions.AddDays(w.Data, w.NumDias).Value, DateTime.Now).Value < numeroDias)

What I'm missing?

asked Jun 27 '14 at 00:22

fmalh3iro

*FUNCTION database.AddDays does not exist* *I get the follow exception "FUNCTION database.DiffDays does not exist".* What is the actual problem? Aside from the fact that you're using MySQL. – ta.speot.is Jun 27 '14 at 00:28
You say the problem is because MySQL? It don't support the dbfunctions? – fmalh3iro Jun 27 '14 at 00:33
1

I managed to solve the problem by creating the respective functions in MySQL. thx for the help – fmalh3iro Jun 28 '14 at 12:38
How do you call this function? DbFunctions is not recognized in my code – Gil Cohen Feb 19 '15 at 00:26
You need refer System.Data.Entity – fmalh3iro Feb 19 '15 at 22:38
@fmalh3iro Can you please explain how you solved this issue? – Alonzzo2 Oct 21 '15 at 16:39
I've created in the database a function named DiffDays with two parameters of type Date – fmalh3iro Oct 21 '15 at 20:39

FUNCTION database.AddDays does not exist

0 Answers0

Linked