Jupiter.Market.Elastic.Titles.Services.DataService

This service uses Dapper for data access, Polly for retry policies, and NetTopologySuite for geospatial data. All queries support cancellation and optional retry logic for transient failures.

See also: Data Retrieval Guide

Methods

Jupiter.Market.Elastic.Titles.Services.DataService.InitAsync

No summary available.

Exceptions:

• $etype: Thrown when initialization fails after retries.

Jupiter.Market.Elastic.Titles.Services.DataService.GetConnectionAsync

No summary available.

Exceptions:

• $etype: Thrown when connection cannot be established.

RunQueryAsync``1

No summary available.

Type Parameters:

• $tpName: The type to map query results to.

Parameters:

• query: The SQL query to execute.
• parameters: Anonymous object containing query parameters.
• useRetry: If true, applies Polly retry policy for transient failures.
• cancellationToken: Cancellation token for the operation.
• queryKey: Optional key for performance tracking.

Exceptions:

• $etype: Thrown when query fails after retries (if enabled).
• $etype: Thrown when query times out after retries (if enabled).

RunQueryByKeyAsync``1

No summary available.

Type Parameters:

• $tpName: The type to map query results to.

Parameters:

• queryKey: The key identifying the query in QueryConstants.Queries dictionary.
• parameters: Anonymous object containing query parameters.
• useRetry: If true, applies Polly retry policy for transient failures.
• cancellationToken: Cancellation token for the operation.

Exceptions:

• $etype: Thrown when queryKey is not found in .
• $etype: Thrown when query fails after retries (if enabled).

GetUprnsByTitleIdsAsync

No summary available.

This method executes a complex CTE query that:Identifies all UPRNs associated with the title and their parent buildings from !:xref:Table.UprnAggregates rateable values from multiple assessments from !:xref:Table.RateAssessmentSelects the most reliable size data based on source priority (VOA > EPC > RM > ZP > AB)Selects the most reliable room counts based on source priorityRetrieves the latest EPC (Energy Performance Certificate) ratings from !:xref:Table.EnergyPerformanceCertificateAggregates VOA classifications as JSON from !:xref:Table.ClassificationAggregates planning use classes as JSONConcatenates floor levels in sorted order

The returned dictionary groups UPRNs by their parent building ID. UPRNs without buildings are assigned to a zero GUID building ID.

See also: Data Retrieval Guide

Parameters:

• titleId: The unique identifier of the title.
• cancellationToken: Cancellation token for the operation.

GetTitleReferenceByIdAsync

No summary available.

This method retrieves core title information from !:xref:Table.Title including:Title number and areas (square meters, square feet, acres)Tenure type (Freehold, Leasehold)Property category and typesComplete address components from !:xref:Table.AddressGiven (building number, street, town, county, postcode)

The method handles flexible PropertyType mapping, supporting List<string>, string[], or single string values from the database.

See also: Data Retrieval Guide

Parameters:

• titleId: The unique identifier of the title.
• cancellationToken: Cancellation token for the operation.

Returns: A object containing base title information, or null if not found.

Fields

QueryMetrics

No summary available.