error with EF and Mysql query

Question

error with EF and Mysql query

Navigation

#1 by (5 votes)

2

I have the following query:

 var produto = (from a in context.ItensReceita
                join b in context.Receita on a.t0080_id_receita equals b.t0080_id_receita
                join c in context.Medicamento on a.t0080_id_receita equals c.t0051_id_medicamento     
                join d in context.Pessoa on b.t0031_id_paciente equals d.t0031_id_pesso
                   where b.t0020_id_empresa == idEmpresa
                   && Convert.ToDateTime(b.t0080_dt_venda) >= Convert.ToDateTime("2017/01/01")
                   && Convert.ToDateTime(b.t0080_dt_venda) <= Convert.ToDateTime("2017/01/31")
                   select new { b.t0080_dt_venda, d.t0031_nome, c.t0051_nome, a.t0081_lote, a.t0081_qtde, b.t0080_status });

But this error:

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

Not accepting the date conversion, how can I resolve this?

mysql datetime entity-framework linq-to-entities

asked by anonymous 09.02.2017 / 11:15

1 answer

How to get the GET value in Laravel, even when the request method is POST? How to overlay floating div on other elements of the web page?

score 5 · Answer 1

Linq does not support method ToDateTime

What you can do is create a variable and then use it in your query

var data1 = Convert.ToDateTime("2017/01/01");
var data2 = Convert.ToDateTime("2017/01/31");

and use these two variables in your query

var produto = (from a in context.ItensReceita
                join b in context.Receita on a.t0080_id_receita equals b.t0080_id_receita
                join c in context.Medicamento on a.t0080_id_receita equals c.t0051_id_medicamento     
                join d in context.Pessoa on b.t0031_id_paciente equals d.t0031_id_pesso
                   where b.t0020_id_empresa == idEmpresa
                   && DbFunctions.TruncateTime(b.t0080_dt_venda) >= data1
                   && DbFunctions.TruncateTime(b.t0080_dt_venda) <= data2
                   select new { b.t0080_dt_venda, d.t0031_nome, c.t0051_nome, a.t0081_lote, a.t0081_qtde, b.t0080_status });

One detail is that you will have to use DbFunctions.TruncateTime that is part of namespace System.Data.Entity