backoffice-repository-service
Legacy WCF reference-data service exposing repository, place and itinerary lookups (places, providers, marketing sources, emergency contacts) backed by the Repository and Phenix SQL databases.
Health score
0 to 100 across seven weighted factors; nothing is hidden. Green is 75 and above, amber 50 to 74, red below 50. How scoring works.
Facts
| Languages | csharp, sql |
| Frameworks | WCF, LINQ to SQL |
| Runtimes | .NET Framework 4.7.2 |
| Tests / CI | none / CI in place |
| Last commit | 2025-09-17 |
| Owner | Owner unknown (mapping to be curated) |
| Domain | Platform services (system generated; curate in repo-owners.json to override) |
| Product area | Phenix |
| Hosted | On-prem Deployed to our own machines
|
| Releases | 2 release pipeline(s): \finance\backoffice\backoffice-repository Database; \finance\backoffice\backoffice-repository-service |
| Integration | wcf, soap |
| Source | Open in Azure DevOps |
Risk flags
Each flag links to its glossary definition.
Dependencies in context
Entanglement
kernel Bound into the core by 2 mechanism(s).
- Speaks WCF (host)
- Shares core database sqlserver:Phenix
Detaches when its WCF surface gains a modern interface or its WCF calls move to one; and when the shared database group it belongs to gains an owned API or completes schema separation (sqlserver:Phenix).
Depends on / used by
Migration playbooks
Generated from this repo's assessment data: what is feasible, what blocks it, and the steps in order. Ratings: green means actionable now, amber means sequence other work first, red means blocked, grey means not applicable.
ZDD adoption
A long roadTechnically eligible one day, but the blockers are structural: hosted WCF or SOAP contracts that cannot run two versions at once, or heavy legacy coupling. Sequence the modernisation work first. Hosts WCF or SOAP endpoints: strict serialization contracts cannot safely run two versions at once (the shared-enum trap). End-of-life runtime compounds the work. Shares sqlserver:Phenix: schema changes move in convoy.
- Shares sqlserver:Phenix with 21 system(s): destructive schema change is prohibited in a single release; expand and contract only
- Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
- Raise automated test coverage first: ZDD trades the end-of-sprint manual gate for continuous automated confidence, so the tests are the entry ticket.
- Make every change dual-version safe: backwards-compatible APIs (new major version for breaking wire changes), expand and contract for any schema change, and consumers tolerant of unknown fields.
- Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
- Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
- Route deployments through the Workflow Engine's automated drain, deploy, health-check, return cycle (the path proven by the first automated production run in mid-2026).
- Verify with area-scoped regression rather than the whole-platform cycle, and watch error rates after rollout with automated rollback on alert.
SQL Server exit
Blocked by a shared core databasesqlserver:Repository, sqlserver:Phenix are shared, so this system cannot change engine on its own: every sharer moves in convoy. The stage 4 work (named owner, declarative schema, owned API) has to land first; after that, the steps below apply to whatever slice this system ends up owning.
- sqlserver:Repository is shared with 1 other system(s)
- sqlserver:Phenix is shared with 21 other system(s) and is a core database
- Inventory the schema and query surface of sqlserver:Repository, sqlserver:Phenix: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
- Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
- Replatform to modern .NET first (see the recommended actions): current PostgreSQL and MongoDB drivers and EF Core providers target modern .NET, and doing one risky change at a time is cheaper than doing two.
- Data access is not through an ORM, so port the SQL by hand: translate T-SQL constructs, replace stored procedures with application code or target-native equivalents, and add integration tests around the queries that matter first.
- Stand up the target alongside SQL Server, backfill with an ETL pass (pgloader or an export/import job), then dual-write or replicate until parity is proven.
- Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
- Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.
Containerisation
Feasible after replatformingAppropriate eventually, but not from here: the legacy runtime and the hosted WCF surface both have to go first, and that work is already in this repo's recommended actions.
- .NET Framework only runs on Windows; practical (Linux) containers need modern .NET
- Hosts WCF or SOAP endpoints, which have no home on modern .NET; consumers need a modern interface first
- Replatform to modern .NET first (see the recommended actions), replacing the hosted WCF/SOAP surface with REST, gRPC or messaging so consumers can follow. Containerising then becomes routine.
- Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
- Log to stdout and expose a health check endpoint so ECS can supervise it.
- Adopt the shared ci.yml pipeline template with the container parameters (awsRegion, containerAfterBuild, ecsTerraformRepo), which is exactly how the estate's existing AWS services deploy.
- Define the service in the Terraform repo, deploy to a non-production environment, then shift traffic and disarm the deployment-group release pipeline.
Recommended actions
Replatform backoffice-repository-service to modern .NET
Runs on .NET Framework 4.7.2, out of mainstream support. No pinning dependency blocks it; sequence by fan-in (providers before consumers). Shares sqlserver:Phenix, so batch it with its database group (stage 4).
Impact: Reduces the end-of-life runtime count
proposedAssessment notes
backoffice-repository-service
Purpose
Provides shared reference/lookup data to the Phenix backoffice estate via three WCF services (RepositoryService.svc, PlaceService.svc, ItineraryService.svc): places/destinations, providers, marketing sources and campaigns, Galileo places and emergency contact info. Ships a TC.Phenix.Repository.Service.WCFClient client library.
Tech stack
C# on .NET Framework 4.7.2, classic ASP.NET/WCF web project (TC.Phenix.Repository.Services) with wsHttp and basicHttp bindings (including unsecured bindings). Data access via LINQ to SQL .dbml contexts (Repository, Phenix, PhenixDB, Booking, InsuranceMondial) and SimpleInjector for DI. Includes a SQL database project (db/Repository) with differential change scripts.
Deployment
Actively deployed (prod_application, 2 releases). Build pipelines backoffice-repository-service CI (build.yml, MSBuild/VS agent pool) and backoffice-repository-service Database (build-db.yml, differential DB packaging via shared templates); release pipelines \finance\backoffice\backoffice-repository-service and \finance\backoffice\backoffice-repository Database.
Dependencies
No calls to other estate services detected — it is a data provider consumed by others. Uses internal TC ConnectionBroker for connection-string resolution. No third-party external services.
Data stores
SQL Server Repository database (owned; schema managed in db/Repository change scripts) and the shared Phenix database, both resolved via GetDatabaseConnectionString.
Integration points
Inbound SOAP/WCF only (wsHttpBinding with security mode None, basicHttpBinding). No REST API, no message bus.
Code health
No test projects in the solution. CI exists for both app and database. Last commit 2025-09-17 (about ten months before assessment) — low activity, effectively in maintenance mode.
Modernisation risks
High priority: .NET Framework 4.7.2 with WCF (no supported migration path on modern .NET without CoreWCF), LINQ to SQL (deprecated technology), unsecured WCF bindings, shared Phenix database coupling, and no automated tests. Any consumer migration off WCF will need this service rebuilt as a REST API or its data absorbed elsewhere.