Platform Evolution
Assessment run-2026-07-27-1 · 213 of 213 repos assessed
Repos / teams-service

teams-service

.NET 8 Teams API managing TC teams, membership, cover/mentor arrangements and the commission-split rules that divide booking commission between team members and head office.

87 · greenlowkernelOn-premZDD: no excuseapi

Health score

87

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.


Runtime currency / 25
25
Runs on supported modern .NET
Legacy transport / 15
6
Calls at least one legacy WCF endpoint
Test posture / 15
15
Good test coverage
Security hygiene / 15
15
No credentials found in source
Dangerous coupling / 15
11
depends on pinning component(s): application-framework
Activity / 10
10
Actively maintained
Deployment hygiene / 5
5
CI in place
Health over time
2026-07-24 (run-2026-07-24-1): 872026-07-27 (run-2026-07-27-1): 87
No change since 2026-07-24 (87 to 87).

Facts

Languagescsharp
FrameworksASP.NET Core 8, MediatR, Dapper
Runtimes.NET 8
Tests / CIgood / CI in place
Last commit2026-05-26
OwnerOwner unknown (mapping to be curated)
DomainAgent tools and community (system generated; curate in repo-owners.json to override)
Product areaShared platform
HostedOn-prem Deployed to our own machines
  • Release "\finance\teams\teams-service Database dacpac Dev": QA: deployment-group phase (agents on our own machines)
  • Release "\finance\teams\teams-service Database dacpac Release": Staging: deployment-group phase (agents on our own machines)
  • Release "\finance\teams\teams-service Database dacpac Release": Production: deployment-group phase (agents on our own machines)
  • Release "\finance\teams\teams-service Database dacpac Release": Training: deployment-group phase (agents on our own machines)
  • Release "tc-teams-api": QA: deployment-group phase (agents on our own machines)
Releases4 release pipeline(s): \finance\teams\teams-service Database dacpac Dev; \finance\teams\teams-service Database dacpac Release; tc-teams-api; tc-teams-api Stealth
Integrationrest, wcf, sqlserver
SourceOpen in Azure DevOps

Risk flags

Each flag links to its glossary definition.

Dependencies in context

Laying out the graph…
greenamberreddata store (square, dashed link)Node size follows fan-in. Click any node to open it.

Entanglement

kernel Bound into the core by 2 mechanism(s).

Detaches when its pinning dependencies are cut or multi-targeted (application-framework); and when its WCF surface gains a modern interface or its WCF calls move to one.

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

No excuse

Nothing technical is holding this repo on the three-week release. It either already deploys without downtime (AWS) or is a modern, well-tested service the automated stealth path can carry today. Modern runtime, good tests, no hosted legacy transport: the automated stealth path can carry it today. Calls legacy WCF endpoints as a client; stay dual-version safe on client package upgrades.

Dependencies and gotchas
  • 9 system(s) depend on this repo; during a rolling deploy they will talk to old and new versions at once, so responses must stay compatible
  • Consumes WCF contract packages: never take a breaking client bump mid-feature, and treat obsolete warnings as migration debt
Steps
  1. Adopt the four-stage discipline from the ZDD engineering standard: pre-deployment compatibility, deployment, feature activation behind a flag, post-release cleanup.
  2. 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.
  3. Audit serialized data: anything in Redis, queues or shared caches must deserialize cleanly across adjacent versions.
  4. Wrap behaviour changes in feature flags so code deploys dark and release becomes a business decision, not a deployment event.
  5. 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).
  6. 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 database

sqlserver:Teams is shared, so this system cannot change engine on its own: every sharer moves in convoy. Either agree the move with all sharers as one programme, or first split this system's data out behind an owned API, then follow the steps below.

Blockers
Steps
  1. Inventory the schema and query surface of sqlserver:Teams: tables, stored procedures, triggers, cross-database joins and anything else engine-specific.
  2. Confirm the target: PostgreSQL (relational model; keep transactions and joins, swap the engine).
  3. 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.
  4. 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.
  5. Move reads to the target, watch correctness and latency, then cut writes over and keep SQL Server read-only until confidence is earned.
  6. Decommission the SQL Server database and remove the connection strings and firewall paths that pointed at it.

Containerisation

Ready to containerise

Modern runtime, no hosted legacy transport: this service can follow the estate's proven container path (Dockerfile, shared pipeline template, ECS via Terraform).

Steps
  1. Add a Dockerfile and make the app read all configuration from environment variables and the secrets manager, never from machine-local files.
  2. Log to stdout and expose a health check endpoint so ECS can supervise it.
  3. 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.
  4. 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

No specific actions for this repo. It either needs only normal maintenance, or its work is covered by an estate-level action. See the full programme.

Assessment notes

teams-service

Purpose

Owns TC teams: creation and membership management, cover and mentor arrangements, and the commission-rule engine (Default/Booker/Always rule hierarchy with date ranges) that determines how booking commission is split between team members and head office. Publishes TC.Teams.Contracts and TC.Teams.API.Client NuGet packages consumed by several other estate services.

Tech stack

C# .NET 8 ASP.NET Core API with API versioning, MediatR-style handlers, SimpleInjector/Scrutor, Dapper over SQL Server, MongoDB.Driver, Serilog with Mongo request/response logging, PhenixAuth JWT scheme, Swashbuckle plus NSwag client generation, Nerdbank.GitVersioning, xUnit/MSTest tests.

Deployment

prod_application, release_count 4. YAML pipelines in build/: buildAPI.yml (builds TC.Teams.API and publishes the two NuGet packages), dbBuild.yml (dacpac) and deploy-mongodb.yml. Build pipelines tc-teams-api and the teams-service dacpac pair feed release pipelines tc-teams-api (+ Stealth) and the \finance\teams\ dacpac Dev/Release pipelines — the API and the database schema deploy separately.

Dependencies

Internal packages: TC.ConnectionBroker.* (Sql, Api, Wcf, Mongo), TC.Exceptions.WebApiClient, TC.Phenix.ApplicationFramework (application-framework), TC.UserAccount.ServiceClient (backoffice-useraccount-service, called over WCF with a health check), TC.ScriptRunner.Mongo. External: New Relic APM.

Data stores

SQL Server Teams database (dacpac project db/TeamsDatabase, Dapper repositories, ConnectionBroker connection Teams). MongoDB database Teams for commission rules and rule logs, and teams_logs for request/response logging.

Integration points

Inbound REST (/api/tcteams) with PhenixAuth JWT. Outbound WCF to the user-account service. Downstream consumers integrate via the published contracts/client packages (at least five estate repos list teams-service as a dependency).

Code health

Four test projects (API integration tests with fakes, services unit tests, data-transformer tests, general unit tests) covering the commission-rule logic well. Genuinely informative README explaining the commission-rule domain, plus a Database.md for the dacpac workflow. Last commit 2026-05-26 — active.

Modernisation risks

Low: modern .NET 8, YAML CI, dacpac database releases, good tests. Residuals: a legacy WCF client for user-account lookups, data split across SQL Server and MongoDB for related concepts (teams in SQL, commission rules in Mongo), and high fan-in via its NuGet packages means contract changes ripple across the estate.