c#entity mySql_c# – 如何在Entity Framework和Mysql中使用规范函数

我想使用

MySql数据库将Timespan添加到EntityFramework中的DateTime.

我尝试过使用DbFunctions.AddMinutes(someminutes)和EntityFunctions.AddMinutes(someminutes),但是当我执行时,我得到了类似的异常

FUNCTION projectName.AddMinutes does not exist

我在用

> MySql.Data.Entities 6.8.3.0

> EntityFramework 6.0.0

> MySql.Data 6.8.4

> MySql.Web 6.8.4

> MySql(数据库)5.6.17

我的Linq查询如下

IQueryable orders = _dbContext.Orders

.OrderByDescending(x => x.ID)

.Select(x => new OrderViewModel

{ ID = x.ID,

AddedOn = DbFunctions.AddMinutes(x.AddedOn, diffMinutes).Value,

Customer = (x.IsGuestCheckOut == true ? x.CustomerEmail : x.Customer.FirstName + " " + x.Customer.LastName),

Phone = x.Phone,

TotalAmount = x.TotalAmount,

OrderStatus = x.OrderStatus });

在某些条件和分页应用的路上