Error in expression

Question

Can anyone help me with the following error?

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

Below is my code, I am trying in several ways to fix this error, but I have not been successful:

public IEnumerable<Dia1> GetPendenciasByUser(int centroId)
{
    var query = Db.Dia1S
        .Join(Db.Cadastros, dia1 => dia1.PatientId, cad => cad.PatientId, (dia1, cad) => new { dia1, cad })
        .Join(Db.Randomizacao, dia1 => dia1.dia1.PatientId, rand => rand.PatientId, (dia1, rand) => new { dia1, rand })
        .Where(s => s.dia1.dia1.dtd1 == null ? (Convert.ToInt32(DateTime.Now - s.rand.RandomizacaoData)) > 1 : (Convert.ToInt32(Convert.ToDateTime(s.dia1.dia1.dtd1) - s.rand.RandomizacaoData)) > 1 )
        .Select(s => s.dia1.dia1)
        .ToList();
    return query;
}

In what way is this not a duplicate? Don't simply assert it isn't, give a reason or edit your question with additional information to distinguish it. It sure looks like a duplicate to me. — , Mar 22 '18 at 14:12
How do I confirm something I did not do? The posts are totally different. Sorry, but it's not duplicated. @Amy — Leonardo Macedo, Mar 22 '18 at 14:14
They have the *same problem*. It doesn't matter whether the code is the same. — , Mar 22 '18 at 14:16
Your error tells that int32.ToInt32(precise: Convert.ToInt32 in your case, boils down to the same) is not supportet in LinqToEntities. That's exactly whats mentioned in the linked (possible) duplicate — Chrᴉz remembers Monica, Mar 22 '18 at 14:16

score 0 · Answer 1 · answered Mar 22 '18 at 14:16

The error message is clear, LINQ doesn't know how to convert the Convert.ToInt32() function to SQL. You can either use direct casting like this:

(int)(DateTime.Now - s.rand.RandomizacaoData)

Or you'll have to execute the query and get the data, then convert it in memory using Convert.ToInt32() as you wish.

Error in expression

1 Answers1