I'm trying to run this query:
DateTime DDate=DateTime.Today; //Today's date without Time
var v= db.measurements.Where(m => EntityFunctions.TruncateTime(m.InDate) == DDate);
It just returns objects where those two dates are equal, ignoring the time part.
But I receive:
{"FUNCTION [database].TruncateTime does not exist"}
StackTrace:
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.Entity.EFMySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
I'm using:
C# Visual Studio 2010
EntityFramework 4 database first
NetFramework 4
MYSQL Server 5.6
The version of MySQL.Data and MySQL.Data.Entity is 6.6.5.0
Same thing happened to this person.
解决方案
I couldn't resolve it, so I just created a Function named "TruncateTime" in the database.
Create FUNCTION TruncateTime(dateValue DateTime) RETURNS date
return Date(dateValue);
And it works, but I don't like it.
These people did similar things:
So now I think that might be unnecessary and I can just call it directly from the database and still get entities, something like this:
var x = db.ExecuteStoreQuery(@"SELECT field1,field2
FROM Measurements
WHERE Date(InDate) = {0}", DDate);
And that's all.