problem with Entityframework

Asked

Viewed 29 times

1

see the return of the script, running directory in mysql, by sqlYog:

inserir a descrição da imagem aqui

However, when I run in Visual Studio, the return is different: inserir a descrição da imagem aqui

Serialized result:

"TotalMesAMes": [
    {
        "mes": "January",
        "status": "Fechado",
        "valor_negocio": 1500
    },
    {
        "mes": "February",
        "status": "Fechado",
        "valor_negocio": 1260
    },
    {
        "mes": "March",
        "status": "Fechado",
        "valor_negocio": 500
    },
    {
        "mes": "May",
        "status": "Fechado",
        "valor_negocio": 1300
    },
    {
        "mes": "June",
        "status": "Fechado",
        "valor_negocio": 1500
    },
    {
        "mes": "July",
        "status": "Fechado",
        "valor_negocio": 1000
    },
    {
        "mes": "August",
        "status": "Fechado",
        "valor_negocio": 3800
    },
    {
        "mes": "September",
        "status": "Contato",
        "valor_negocio": 0
    },
    {
        "mes": "September",
        "status": "Contato",
        "valor_negocio": 0
    },
    {
        "mes": "September",
        "status": "Contato",
        "valor_negocio": 0
    },
    {
        "mes": "September",
        "status": "Contato",
        "valor_negocio": 0
    },
    {
        "mes": "October",
        "status": "Em andamento",
        "valor_negocio": 5500
    },
    {
        "mes": "October",
        "status": "Em andamento",
        "valor_negocio": 5500
    },
    {
        "mes": "November",
        "status": "Em andamento",
        "valor_negocio": 500
    },
    {
        "mes": "November",
        "status": "Em andamento",
        "valor_negocio": 500
    }
]

Strange, I need the return to be equal to the executed on sqlyog. for example, in the month of November, it is returning twice the same value, but the correct one is new 500 and November 400

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.