EntityFramework.SqlServer

Kind: Service

Source: Pams/Data/Pams.Data/Pams.Data.csproj (line 1)

Part of: Pams

NuGet package dependency

EntityFramework.SqlServer is a NuGet package dependency declared in Pams.Data.csproj. It provides the SQL Server provider for Entity Framework in the Pams data layer, allowing repository and data-access code to connect to and query SQL Server databases.

Diagram

mermaid
sequenceDiagram
    participant App as Application
    participant Data as Pams.Data
    participant EF as Entity Framework
    participant SQL as SQL Server

    App->>Data: Request data operation
    Data->>EF: Create query or save changes
    EF->>SQL: Execute SQL Server command
    SQL-->>EF: Return results
    EF-->>Data: Materialize entities
    Data-->>App: Return data result

Usage

ts
// JavaScript clients do not reference EntityFramework.SqlServer directly.
// Call an application endpoint backed by the Pams.Data SQL Server provider.

async function getPatient(patientId: string) {
  const response = await fetch(`/api/patients/${patientId}`);

  if (!response.ok) {
    throw new Error("Unable to load patient data.");
  }

  return response.json();
}

const patient = await getPatient("patient-id");
console.log(patient);

AI Coding Instructions

• Keep EntityFramework.SqlServer declared as a package reference in Pams/Data/Pams.Data/Pams.Data.csproj.
• Configure SQL Server connections and Entity Framework provider settings in the .NET application configuration, not in JavaScript clients.
• Use Entity Framework query and persistence APIs through the Pams data layer rather than issuing SQL Server commands from higher-level application code.
• Check provider version compatibility with the Entity Framework version referenced by the project before changing package dependencies.

Used by

2 references from 2 files. Each is a place in this repository where the symbol is actually used — go read one rather than trusting an example.

Injected or called by (2)

• Pams.API — Pams/API/Pams.API/Pams.API.csproj:1
• Pams.Data — Pams/Data/Pams.Data/Pams.Data.csproj:1