await using var fusionConnection = await context.OpenFusionConnectionAsync();

const string sql =
    """
    SELECT *
    FROM Department D
        LEFT JOIN Course C ON D.DepartmentID = C.DepartmentID
    WHERE D.DepartmentId = @DepartmentID
    ORDER BY D.Name;
    """;

var from = new From<Department>(
    new Join<Course>());

var parameters = new Parameters { { nameof(Department.DepartmentID), 4 } };

var dataNode = await fusionConnection.GetDataNodesAsync(sql, from, parameters).Single();

return dataNode;