Asterisk Realtime Proxies (AstDbContext)

To achieve microsecond data matching speeds during signaling cycles, Asterisk 2 configures dedicated read-only Entity Framework proxy contexts. These drivers route query expressions directly to underlying native relational tables used by active telecommunication modules.

Direct Proxy Query Routing Schema

The diagram below outlines how application LINQ expressions resolve fields from external operational storage arrays:

graph LR
    %% Application Consumer
    subgraph CoreTier["C# Routing Engine"]
        LinqQuery["Application Controller / Service<br/>(Queries DbSet Interfaces)"]
    end

    %% Decoupled EF Core Layer
    subgraph ProxyTier["Decoupled Proxy Context"]
        EF_Proxy["AstDbContext Engine<br/>(Read-Only Configuration)"]
    end

    %% Target Schema Ledgers
    subgraph ExternalDB["Underlying Realtime Store (wb_ast)"]
        Tab_End[("ps_endpoints Table<br/>(SIP PJSIP Parameters)")]
        Tab_Srv[("servers Table<br/>(Hardware Heartbeat Stats)")]
        Tab_Aud[("cdr / cel / queue_log Tables<br/>(Call Telemetry Logs)")]
    end

    %% Queries
    LinqQuery -->|"LINQ Execution"| EF_Proxy
    EF_Proxy ==>|"Direct Schema Map"| Tab_End
    EF_Proxy ==>|"Direct Schema Map"| Tab_Srv
    EF_Proxy ==>|"Direct Schema Map"| Tab_Aud

    %% Rich Tailored Palettes
    classDef coreToken fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef proxyToken fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef dbToken fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;

    class CoreTier,LinqQuery coreToken;
    class ProxyTier,EF_Proxy proxyToken;
    class ExternalDB,Tab_End,Tab_Srv,Tab_Aud dbToken;

Architectural Safeties

1. Disabled Migration Scopes

Because AstDbContext queries operational tables managed by external installation drivers, code-first data migrations are explicitly blocked. Framework builders must never execute schema mutation tools targeting this target connection mapping string.

2. Immutability Enforcement

Data integration scripts enforce strict read isolation (AsNoTracking) across proxy DbSets, preventing accidental write back loops from polluting raw signaling logic configurations.

# Asterisk Realtime Proxies (AstDbContext)

To achieve microsecond data matching speeds during signaling cycles, **Asterisk 2** configures dedicated read-only Entity Framework proxy contexts. These drivers route query expressions directly to underlying native relational tables used by active telecommunication modules.

---

## Direct Proxy Query Routing Schema

The diagram below outlines how application LINQ expressions resolve fields from external operational storage arrays:

```mermaid
graph LR
 %% Application Consumer
 subgraph CoreTier["C# Routing Engine"]
 LinqQuery["Application Controller / Service (Queries DbSet Interfaces)"]
 end

%% Decoupled EF Core Layer
 subgraph ProxyTier["Decoupled Proxy Context"]
 EF_Proxy["AstDbContext Engine (Read-Only Configuration)"]
 end

%% Target Schema Ledgers
 subgraph ExternalDB["Underlying Realtime Store (wb_ast)"]
 Tab_End[("ps_endpoints Table (SIP PJSIP Parameters)")]
 Tab_Srv[("servers Table (Hardware Heartbeat Stats)")]
 Tab_Aud[("cdr / cel / queue_log Tables (Call Telemetry Logs)")]
 end

%% Rich Tailored Palettes
    classDef coreToken fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef proxyToken fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef dbToken fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;

class CoreTier,LinqQuery coreToken;
    class ProxyTier,EF_Proxy proxyToken;
    class ExternalDB,Tab_End,Tab_Srv,Tab_Aud dbToken;
```

---

## Architectural Safeties

### 1. Disabled Migration Scopes
Because `AstDbContext` queries operational tables managed by external installation drivers, code-first data migrations are explicitly blocked. Framework builders must never execute schema mutation tools targeting this target connection mapping string.

### 2. Immutability Enforcement
Data integration scripts enforce strict read isolation (`AsNoTracking`) across proxy DbSets, preventing accidental write back loops from polluting raw signaling logic configurations.