using Dapper;

        [HttpGet("getList")]

        public IActionResult getList()

        {

            using var conn = new Context().Database.GetDbConnection();

            string sql = @"

        select

hedef.*,

amac.ad as amacAd,

stpBoyutId,

boyut.ad as boyutAd

from StpHedef hedef

left join StpAmac  amac on amac.id = hedef.stpAmacId

left join StpBoyut boyut on boyut.id = stpBoyutId";

            var result = conn.Query(sql).ToList();

            return Ok(result);

        }

Install-Package Microsoft.AspNetCore.Mvc.NewtonsoftJson

builder.Services.AddControllers()

    .AddNewtonsoftJson(options =>

    {

        options.SerializerSettings.Formatting = Formatting.Indented;

    });

var app = builder.Build();