EntityFramework.SqlServer

Kind: Service

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

Part of: Pams

NuGet package dependency

EntityFramework.SqlServer is a NuGet package dependency in Pams.API that connects Entity Framework data access code to SQL Server. It supports SQL Server database configuration, query execution, and persistence for API services that use Entity Framework.

Diagram

mermaid
sequenceDiagram
    participant Client
    participant Api as Pams.API
    participant EF as Entity Framework
    participant SqlServer as SQL Server

    Client->>Api: Send API request
    Api->>EF: Query or save entity
    EF->>SqlServer: Execute SQL command
    SqlServer-->>EF: Return data or result
    EF-->>Api: Map result to entity
    Api-->>Client: Return API response

Usage

ts
const response = await fetch("/api/pams");

if (!response.ok) {
  throw new Error("Pams API request failed");
}

const records = await response.json();

console.log(records);

AI Coding Instructions

• Keep EntityFramework.SqlServer aligned with the Entity Framework version referenced by Pams.API.
• Configure the SQL Server connection through the API application's database context and configuration files.
• Use Entity Framework queries and persistence methods instead of building SQL strings in API controllers.
• Check package compatibility before changing Entity Framework or SQL Server dependency versions.