using var connection = _sqlConnectionFactory.CreateConnection();

       const string sql = """
           SELECT
               a.id AS Id,
               a.last_modified_date_on_utc AS LastModifiedDateOnUtc,
               a.last_modified_by AS LastModifiedBy,
               a.created_on_utc AS CreatedOnUtc,
               a.created_by AS CreatedBy,
               a.type_of_request AS TypeOfRequest,
               a.customs_clearance AS CustomsClearance,
               a.delivery_conditions AS DeliveryConditions,
               a.cargo_readiness_period AS CargoReadinessPeriod,
               a.deadline_for_submitting_commercial_offer AS DeadlineForSubmittingCommercialOffer,
               a.type_of_cargo AS TypeOfCargo,
               a.type_of_packaging AS TypeOfPackaging,
               a.container_type AS ContainerType,
               a.places_in_container AS PlacesInContainer,
               a.loading_in_one_container_net AS LoadingInOneContainerNeT,
               a.number_of_containers AS NumberOfContainers,
               a.weight_of_one_place AS WeightOfOnePlace,
               a.loading_per_container_gross_ton AS LoadingPerContainerGrossTon,
               a.port_of_shipment AS PortOfShipment,
               a.transshipment_port AS TransshipmentPort,
               a.place_of_delivery AS PlaceOfDelivery,
               a.cargo_pickup_address AS CargoPickupAddress,
               a.note AS Note,
               a.is_visible AS IsVisible,
               a.index AS Index
           FROM transportation_request AS a
           """;

       var transportationRequestResponse = await connection.QueryAsync<GetTransportationRequestResponse>(
           sql,
           new[]
           {
               typeof(Guid),
               typeof(Audit),
               typeof(TypeOfRequest),
               typeof(LogisticsProcess),
               typeof(CargoCharacteristics),
               typeof(CharacteristicsOfTheContainer),
               typeof(LogisticsHubs),
               typeof(string),
               typeof(bool),
           },
           objects =>
           {
               Guid id = (Guid)objects[0];
               Audit audit = (Audit)objects[1];
               TypeOfRequest typeOfRequest = (TypeOfRequest)objects[2];
               LogisticsProcess logisticsProcess = (LogisticsProcess)objects[3];
               CargoCharacteristics cargoCharacteristics = (CargoCharacteristics)objects[4];
               CharacteristicsOfTheContainer characteristicsOfTheContainer = (CharacteristicsOfTheContainer)objects[5];
               LogisticsHubs logisticsHubs = (LogisticsHubs)objects[6];
               string note = (string)objects[7];
               bool isVisible = (bool)objects[8];

               GetTransportationRequestResponse getTransportationRequestResponse = new(
                   id,
                   audit,
                   typeOfRequest,
                   logisticsProcess,
                   cargoCharacteristics,
                   characteristicsOfTheContainer,
                   logisticsHubs,
                   note,
                   isVisible);

               return getTransportationRequestResponse;

           },
           splitOn: "Id,LastModifiedDateOnUtc,TypeOfRequest,CustomsClearance,TypeOfCargo,ContainerType,PortOfShipment,Note,IsVisible");


       return transportationRequestResponse.ToList();