Left Join - Linq is bringing Duplicate Value

Question

Hello, I have a print method, which makes several left join, it is bringing the values I want, but some of these values are coming duplicated, as shown in the images:

Table TabelaImposto: select TbImp_codigo, TbImp_TpMdobc from TabelaImposto

Table TipoModBaseICMS: select TpMdoBC_Codigo, TpMdoBC_Descricao from TipoModBaseICMS

Result Obtained:

My method:

    [HttpGet]
    [Route("imprimir2")]
    public HttpResponseMessage Imprimir2()
    {
        try
        {
            var result = new HttpResponseMessage(HttpStatusCode.OK);

            var impostos = (from a in bdprincipalEntities.TabelaImposto

                            join e in bdprincipalEntities.TipoModBaseICMS on a.TbImp_TpMdobc
                            equals e.TpMdoBC_Codigo into a_e
                            from e in a_e.DefaultIfEmpty()

                            select new
                            {
                                a.TbImp_codigo,

                                e.TpMdoBC_Descricao

                            }).ToList();

            result.Content = new StringContent(JsonConvert.SerializeObject(impostos));
            result.Content.Headers.ContentType = new System.Net.Http.Headers.MediaTypeHeaderValue("application/json");
            return result;
        }
        catch (Exception)
        {
            return new HttpResponseMessage(HttpStatusCode.BadRequest);
        }
    }

Answer 1

The field TpMdoBC_Codigo table TipoModBaseICMS is not only!

Let’s take for example, Code Tax 1. He has the TbImp_TpMdobc value 3. By doing the join with the table TipoModBaseICMS 2 records are found:

• "Value of the Transaction"
• "Neutral List (Value)"

The problem is not in the query, it is in the data structure.