# christianulson/dbsqllikemem architecture

> Architecture diagram of the GitHub repository christianulson/dbsqllikemem, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/christianulson/dbsqllikemem
- Repository: https://github.com/christianulson/dbsqllikemem

## Overview

DbSqlLikeMem is an in-memory, multi-dialect ADO.NET database engine for tests. A test defines schema and seed data, opens a provider-specific mock connection, submits SQL through a command, and receives affected-row results or a reader/scalar result. The engine also advertises dialect/version behavior, sequences, and execution-plan diagnostics. A separate Visual Studio extension core reads database metadata for tooling. The graph follows the documented workflow and sampled execution code; parser, provider internals, and several advertised capabilities are represented only at supported directory or file paths.

Main entry points: [`src/code/DbSqlLikeMem`](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem) (SQL command), [`src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs`](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs) (SELECT executor), [`src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs`](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs) (Mock connection), [`src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs`](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs) (Provider ADO mocks)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_api["Test-facing API"]
  node_schema["Schema and seed"]
  node_connection["Mock connection"]
  node_command["SQL command"]
end

subgraph group_engine["SQL execution"]
  node_parser["SQL parser"]
  node_nonquery["DDL and DML"]
  node_ddl["DDL handler"]
  node_query["SELECT executor"]
  node_select["Select pipeline"]
  node_joins["Join service"]
  node_json["JSON table functions"]
  node_result["Query result<br/>[TableResultMock.cs]"]
  node_state[("In-memory state")]
  node_plans["Execution diagnostics"]
end

subgraph group_providers["Database providers"]
  node_provider["Dialect providers<br/>[Db2Dialect.cs]"]
  node_ado["Provider ADO mocks"]
end

subgraph group_tooling["Metadata tooling"]
  node_metadata["Schema metadata"]
  node_metadataqueries["Metadata queries"]
end

node_tester(("Test code"))
node_database(("Database connection"))

node_tester -->|"defines schema"| node_schema
node_tester -->|"opens"| node_connection
node_tester -->|"submits SQL"| node_command
node_schema -.->|"seeds"| node_state
node_connection -.->|"uses provider"| node_ado
node_ado -.->|"executes"| node_command
node_command -.->|"parses SQL"| node_parser
node_command -.->|"dispatches DDL/DML"| node_nonquery
node_nonquery -->|"dispatches DDL"| node_ddl
node_query -->|"projects rows"| node_select
node_query -.->|"delegates joins"| node_joins
node_query -.->|"evaluates functions"| node_json
node_select -->|"builds result"| node_result
node_query -.->|"reads tables"| node_state
node_command -.->|"returns rows"| node_result
node_provider -.->|"configures behavior"| node_ado
node_connection -->|"exposes history"| node_plans
node_metadata -->|"builds metadata queries"| node_metadataqueries
node_metadata -.->|"reads metadata"| node_database

click node_schema "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Models"
click node_connection "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs"
click node_command "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem"
click node_parser "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Parser"
click node_nonquery "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs"
click node_ddl "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Execution/NonQueryHandlers/AstDdlNonQueryCommandHandler.cs"
click node_query "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs"
click node_select "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs"
click node_joins "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/Joins/AstQueryJoinService.cs"
click node_json "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Query/Execution/TableFunctions"
click node_result "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Support/TableResultMock.cs"
click node_state "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Models"
click node_provider "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem.Db2/Db2Dialect.cs"
click node_ado "https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs"
click node_plans "https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Query/Execution"
click node_metadata "https://github.com/christianulson/dbsqllikemem/blob/develop/src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs"
click node_metadataqueries "https://github.com/christianulson/dbsqllikemem/blob/develop/src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlMetadataQueryFactory.cs"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_schema,node_connection,node_command toneBlue
class node_parser,node_nonquery,node_ddl,node_query,node_select,node_joins,node_json,node_result,node_state,node_plans,node_database toneAmber
class node_provider,node_ado toneMint
class node_metadata,node_metadataqueries toneRose
class node_tester toneIndigo
```

## Components

### Test-facing API

- [Schema and seed](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Models): `src/code/DbSqlLikeMem/Models`
- [Mock connection](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs): `src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs`
- [SQL command](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem): `src/code/DbSqlLikeMem`

### SQL execution

- [SQL parser](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Parser): `src/code/DbSqlLikeMem/Parser`
- [DDL and DML](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs): `src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs`
- [DDL handler](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Execution/NonQueryHandlers/AstDdlNonQueryCommandHandler.cs): `src/code/DbSqlLikeMem/Execution/NonQueryHandlers/AstDdlNonQueryCommandHandler.cs`
- [SELECT executor](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs): `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs`
- [Select pipeline](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs): `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs`
- [Join service](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Execution/Joins/AstQueryJoinService.cs): `src/code/DbSqlLikeMem/Query/Execution/Joins/AstQueryJoinService.cs`
- [JSON table functions](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Query/Execution/TableFunctions): `src/code/DbSqlLikeMem/Query/Execution/TableFunctions`
- [Query result](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem/Query/Support/TableResultMock.cs): `src/code/DbSqlLikeMem/Query/Support/TableResultMock.cs`
- [In-memory state](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Models): `src/code/DbSqlLikeMem/Models`
- [Execution diagnostics](https://github.com/christianulson/dbsqllikemem/tree/develop/src/code/DbSqlLikeMem/Query/Execution): `src/code/DbSqlLikeMem/Query/Execution`

### Database providers

- [Dialect providers](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem.Db2/Db2Dialect.cs): `src/code/DbSqlLikeMem.Db2/Db2Dialect.cs`
- [Provider ADO mocks](https://github.com/christianulson/dbsqllikemem/blob/develop/src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs): `src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs`

### Metadata tooling

- [Schema metadata](https://github.com/christianulson/dbsqllikemem/blob/develop/src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs): `src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs`
- [Metadata queries](https://github.com/christianulson/dbsqllikemem/blob/develop/src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlMetadataQueryFactory.cs): `src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlMetadataQueryFactory.cs`

### Other components

- **Test code**
- **Database connection**

## Connections

- Test code → Schema and seed: defines schema (evidence: `README.md`)
- Test code → Mock connection: opens (evidence: `README.md`)
- Test code → SQL command: submits SQL (evidence: `README.md`)
- Schema and seed → In-memory state: seeds
- Mock connection → Provider ADO mocks: uses provider
- Provider ADO mocks → SQL command: executes
- SQL command → SQL parser: parses SQL (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs`)
- SQL command → DDL and DML: dispatches DDL/DML (evidence: `src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs`)
- DDL and DML → DDL handler: dispatches DDL (evidence: `src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs`)
- SELECT executor → Select pipeline: projects rows (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs`)
- SELECT executor → Join service: delegates joins (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs`)
- SELECT executor → JSON table functions: evaluates functions (evidence: `src/code/DbSqlLikeMem/Query/Execution/TableFunctions/JsonTable/AstQueryJsonTableFunctionHandler.cs`)
- Select pipeline → Query result: builds result (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs`)
- SELECT executor → In-memory state: reads tables (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs`)
- SQL command → Query result: returns rows (evidence: `src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs`)
- Dialect providers → Provider ADO mocks: configures behavior
- Mock connection → Execution diagnostics: exposes history (evidence: `README.md`)
- Schema metadata → Metadata queries: builds metadata queries (evidence: `src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs`)
- Schema metadata → Database connection: reads metadata
