using (var connection = DBModule.NewSqlConnection())
{
     var sql ="SELECT * FROM requestTransactions WHERE isDeleted = 0";
     return connection.Query<RequestTransaction>(sql).ToList();
}

public class RequestTransaction
{
           [Key]
           public int id { get; set; }

          [Write(false)]
          public string fromOffice =>  this.fromOfficeId != null ? Office.GetById(this.fromOfficeId ?? 0)?.nameOffice : "";

}

public class Office
{
       public static Office GetById(int id) {
            using (var connection = DBModule.NewSqlConnection())
            {
                var sql = "SELECT * FROM dic_company_offices WHERE id = @id";
                return connection.QueryFirstOrDefault<Office>(sql, new { id });           
            }
        }

}