---
title: CertificateHolderQueryProvider
summary: API reference for CertificateHolderQueryProvider.
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data
reference_type: package
---

# CertificateHolderQueryProvider

Query provider exposing 2 data-access operation(s) (`GetCertificateHolder`, `GetCertificateHolders`) against 1 distinct table(s); see [sql/index.md](../../sql/index.md) for the full ORM operation catalog.

## Purpose
- Provides read/write access to 1 table(s) via NHibernate `IQueryable<T>`/`GetRepository<T>()` calls documented in [sql/index.md](../../sql/index.md).
- Exposes 2 public query/command method(s) consumed by higher application layers; see [database-tables.md](../../database-tables.md) for the underlying schema.

## Context
- Namespace: `SAIF.Data.Queries.Policies.Certificates`
- Assembly/package: `SAIF.Data`

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| GetCertificateHolder | `CertificateHolder GetCertificateHolder(long certificateHolderId)` | Executes an ORM query ([SQL-051](../../sql/SQL-051-certificate-holder-query-provider-get-certificate-holder.md)) against [CERTIFICATE_HOLDER](../../database-tables.md#certificate_holder). |
| GetCertificateHolders | `IEnumerable<CertificateHolder> GetCertificateHolders(long policyNumber, bool includeExpired)` | Executes an ORM query ([SQL-052](../../sql/SQL-052-certificate-holder-query-provider-get-certificate-holders.md)) against [CERTIFICATE_HOLDER](../../database-tables.md#certificate_holder). |
| GetCertificateHolders | `IEnumerable<CertificateHolder> GetCertificateHolders(long policyNumber, bool includeExpired, string searchTerm)` | Executes an ORM query ([SQL-052](../../sql/SQL-052-certificate-holder-query-provider-get-certificate-holders.md)) against [CERTIFICATE_HOLDER](../../database-tables.md#certificate_holder). |
| CertificateHolderQueryProvider(IRepositoryFactory factory) | `CertificateHolderQueryProvider(IRepositoryFactory factory)` | Initializes a new instance, wiring the repository factory used by this provider's query methods.* |

## Behavioral notes
- Query methods build LINQ expressions over `IQueryable<T>` obtained via `Factory.GetRepository<T>()` and execute them against the underlying NHibernate session.*

## Constraints and usage notes
- Instances are constructed with an `IRepositoryFactory` and are expected to be resolved through dependency injection rather than instantiated directly.*

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- `Data/SAIF.Data/Queries/Policies/Certificates/CertificateHolderProvider.cs`