LINQ to Entities does not recognize the method 'System.DateTime ConvertShamsiToMiladi(System.String)' method

Question

error : LINQ to Entities does not recognize the method 'System.DateTime ConvertShamsiToMiladi(System.String)' method, and this method cannot be translated into a store expression

How do I fix it?

my codes :

var _48hoursAgoDate = DateTime.Now.AddDays(-2);
var _48hoursAgoPayments =_paymentService.GetMany(d => d.Date.ConvertShamsiToMiladi() >= _48hoursAgoDate)

extension method :

public static DateTime ConvertShamsiToMiladi(this string source)
{
    var date = source.Split('/');
    return new DateTime(int.Parse(date[0]), int.Parse(date[1]), int.Parse(date[2]), new PersianCalendar());
}

`d.Date` doesn't return `DateTime`? Because `ConvertShamsiToMiladi` is an extension method for `string` type, not `DateTime`. — Soner Gönül, Dec 31 '14 at 15:08

score 1 · Accepted Answer · answered Dec 31 '14 at 15:19

You have this message because Linq doesent know how to translate your method to SQL You should convert it to Linq to object first by using .AsEnumerable() it should look like this :

var _48hoursAgoPayments =_paymentService.AsEnumerable().GetMany(d => d.Date.ConvertShamsiToMiladi() >= _48hoursAgoDate)

Regards,

score 0 · Answer 2 · edited May 23 '17 at 12:05

Using LINQ to Entities your query is converted to SQL and ConvertShamsiToMiladi is not implemented in SQL. You either select with a proper statement and convert the date afterwards, or do the whole selection on the client side, i.e. with _paymentService.AsEnumerable().GetMany(...).

"LINQ to Entities does not recognize ..." has been discussed many times here:
LINQ to Entities does not recognize the method 'System.String ToBase64String(Byte[])' method,
LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression

LINQ to Entities does not recognize the method 'System.DateTime ConvertShamsiToMiladi(System.String)' method

2 Answers2