ProviderQueryProvider¶

Query provider exposing 15 data-access operation(s) (GetActiveWorkingRelationshipsForProvider, GetAllActiveProviderAddressesForUpdateDate, GetBillProviderLocationIds, GetExpiredRelationshipsOnOrAfterDate, GetLocation, GetProvider and 9 more) against 12 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose¶

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

Context¶

Namespace: SAIF.Data.Queries.Providers
Assembly/package: SAIF.Data

Public members¶

Member	Signature	Purpose
GetProviderAddressLastUpdateDate	`DateTime GetProviderAddressLastUpdateDate()`	Executes an ORM query (SQL-200) against PROVIDER_ADDRESS.
GetAllActiveProviderAddressesForUpdateDate	`IEnumerable<BatchProviderAddress> GetAllActiveProviderAddressesForUpdateDate(DateTime lastUpdateDate)`	Executes an ORM query (SQL-201) against PROVIDER_ADDRESS.
GetProvider	`Provider GetProvider(long providerId)`	Executes an ORM query (SQL-202) against PROVIDER.
GetProviderByTaxId	`Provider GetProviderByTaxId(string taxId, bool includeNonPrimaryTaxIds = false)`	Executes an ORM query (SQL-203) against PROVIDER_TAX_ID.
GetLocation	`ProviderLocation GetLocation(long locationId)`	Executes an ORM query (SQL-205) against PROVIDER_LOCATION.
GetProviderAddresses	`IEnumerable<ProviderAddress> GetProviderAddresses(long providerId)`	Executes an ORM query (SQL-206) against PROVIDER_ADDRESS, PROVIDER_LOCATION, PROVIDER.
GetProviderAddresses	`IEnumerable<ProviderAddress> GetProviderAddresses(long providerId, string addressType, bool includeExpired = false)`	Executes an ORM query (SQL-206) against PROVIDER_ADDRESS, PROVIDER_LOCATION, PROVIDER.
GetProviderPaymentAddresses	`IEnumerable<ProviderAddress> GetProviderPaymentAddresses(long providerId, bool includeExpired = false)`	Retrieves provider payment addresses.*
GetProviderPhysicalAddresses	`IEnumerable<ProviderAddress> GetProviderPhysicalAddresses(long providerId)`	Retrieves provider physical addresses.*
GetProviderPhysicalAddresses	`IEnumerable<ProviderAddress> GetProviderPhysicalAddresses(long providerId, bool includeExpired)`	Retrieves provider physical addresses.*
GetProviderLocationAddresses	`IEnumerable<ProviderAddress> GetProviderLocationAddresses(long providerLocationId, bool includeExpired = false)`	Executes an ORM query (SQL-208) against PROVIDER_ADDRESS, PROVIDER_LOCATION.
GetProviderLocationAddresses	`IEnumerable<ProviderAddress> GetProviderLocationAddresses(long providerLoctionId, string addressType, bool includeExpired = false)`	Executes an ORM query (SQL-208) against PROVIDER_ADDRESS, PROVIDER_LOCATION.
GetProviderLocationPaymentAddresses	`IEnumerable<ProviderAddress> GetProviderLocationPaymentAddresses(long providerLocationId)`	Retrieves provider location payment addresses.*
GetProviderLocationPaymentAddresses	`IEnumerable<ProviderAddress> GetProviderLocationPaymentAddresses(long providerLocationId, bool includeExpired)`	Retrieves provider location payment addresses.*
GetProviderLocationCorrespondenceAddresses	`IEnumerable<ProviderAddress> GetProviderLocationCorrespondenceAddresses(long providerLocationId)`	Retrieves provider location correspondence addresses.*
GetProviderLocationCorrespondenceAddresses	`IEnumerable<ProviderAddress> GetProviderLocationCorrespondenceAddresses(long providerLocationId, bool includeExpired)`	Retrieves provider location correspondence addresses.*
GetProviderLocationPhysicalAddresses	`IEnumerable<ProviderAddress> GetProviderLocationPhysicalAddresses(long providerLocationId)`	Retrieves provider location physical addresses.*
GetProviderLocationPhysicalAddresses	`IEnumerable<ProviderAddress> GetProviderLocationPhysicalAddresses(long providerLocationId, bool includeExpired)`	Retrieves provider location physical addresses.*
GetBillProviderLocationIds	`IEnumerable<long> GetBillProviderLocationIds(long claimId)`	Executes an ORM query (SQL-210) against CBP_BILL, CBP_BILL_STATUS_CODE, PROVIDER_LOCATION.
GetProviderIdentitiesByNpi	`IEnumerable<ProviderIdentity> GetProviderIdentitiesByNpi(string nationalProviderId)`	Executes an ORM query (SQL-211) against PROVIDER_IDENTITY, PROVIDER_IDENTITY_CODE.
GetWorkingProviderRelationshipsByParentLocation	`IEnumerable GetWorkingProviderRelationshipsByParentLocation(long providerLocationId,
DateTime serviceDate, bool includeExpired = false)`	Executes an ORM query (SQL-212) against PROVIDER_RELATIONSHIP, PROVIDER_RELATIONSHIP_CODE, PROVIDER_LOCATION.
GetExpiredRelationshipsOnOrAfterDate	`IEnumerable<ProviderRelationship> GetExpiredRelationshipsOnOrAfterDate(DateTime effectiveDate)`	Executes an ORM query (SQL-213) against PROVIDER_RELATIONSHIP, PROVIDER_RELATIONSHIP_CODE.
GetActiveWorkingRelationshipsForProvider	`IEnumerable<ProviderRelationship> GetActiveWorkingRelationshipsForProvider(long providerLocationId)`	Executes an ORM query (SQL-214) against PROVIDER_RELATIONSHIP, PROVIDER_RELATIONSHIP_CODE.
GetRenderingProviderLocationsByNpi	`IEnumerable<ProviderLocation> GetRenderingProviderLocationsByNpi(string nationalProviderId, long providerLocationId, DateTime serviceDate)`	Retrieves rendering provider locations by npi.*
GetProviderMCOPlans	`IEnumerable<MCOProvider> GetProviderMCOPlans(long providerLocationId)`	Executes an ORM query (SQL-215) against MCO_PROVIDER.
IsProviderInMco	`bool IsProviderInMco(string mcoPlanId, long providerLocationId, DateTime serviceDate)`	Executes an ORM query (SQL-216) against MCO_PROVIDER.
HasActiveRelationship	`bool HasActiveRelationship(long providerLocationId, long parentProviderLocationId)`	Executes an ORM query (SQL-217) against PROVIDER_RELATIONSHIP, PROVIDER_LOCATION.
NationalProviderId	`string NationalProviderId`	Field exposing national provider id.*
OrganizationalNationalProviderId	`string OrganizationalNationalProviderId`	Field exposing organizational national provider id.*
WorkingRelationship	`string WorkingRelationship`	Field exposing working relationship.*
ProviderQueryProvider(IRepositoryFactory factory)	`ProviderQueryProvider(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/Providers/ProviderQueryProvider.cs