How christianulson/dbsqllikemem works
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: DbSqlLikeMem SQL command · AstQueryExecutorBase.cs SELECT executor · DbConnectionMockBase.cs Mock connection · Db2ConnectionMock.cs Provider ADO mocks
Components 19
Test-facing API
- Schema and seed
src/code/DbSqlLikeMem/Models - Mock connection
src/code/DbSqlLikeMem/Base/DbConnectionMockBase.cs - SQL command
src/code/DbSqlLikeMem
SQL execution
- SQL parser
src/code/DbSqlLikeMem/Parser - DDL and DML
src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs - DDL handler
src/code/DbSqlLikeMem/Execution/NonQueryHandlers/AstDdlNonQueryCommandHandler.cs - SELECT executor
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs - Select pipeline
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs - Join service
src/code/DbSqlLikeMem/Query/Execution/Joins/AstQueryJoinService.cs - JSON table functions
src/code/DbSqlLikeMem/Query/Execution/TableFunctions - Query result
src/code/DbSqlLikeMem/Query/Support/TableResultMock.cs - In-memory state
src/code/DbSqlLikeMem/Models - Execution diagnostics
src/code/DbSqlLikeMem/Query/Execution
Database providers
- Dialect providers
src/code/DbSqlLikeMem.Db2/Db2Dialect.cs - Provider ADO mocks
src/code/DbSqlLikeMem.Db2/Db2ConnectionMock.cs
Metadata tooling
- Schema metadata
src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs - Metadata queries
src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlMetadataQueryFactory.cs
Other components
- Test code
- Database connection
Connections 19
- Test code → Schema and seed: defines schema
README.md - Test code → Mock connection: opens
README.md - Test code → SQL command: submits SQL
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
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs - SQL command → DDL and DML: dispatches DDL/DML
src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs - DDL and DML → DDL handler: dispatches DDL
src/code/DbSqlLikeMem/Execution/NonQueryHandlerExecutionRunner.cs - SELECT executor → Select pipeline: projects rows
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs - SELECT executor → Join service: delegates joins
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs - SELECT executor → JSON table functions: evaluates functions
src/code/DbSqlLikeMem/Query/Execution/TableFunctions/JsonTable/AstQueryJsonTableFunctionHandler.cs - Select pipeline → Query result: builds result
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs - SELECT executor → In-memory state: reads tables
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.cs - SQL command → Query result: returns rows
src/code/DbSqlLikeMem/Query/Execution/AstQueryExecutorBase.SelectPipeline.cs - Dialect providers → Provider ADO mocks: configures behavior
- Mock connection → Execution diagnostics: exposes history
README.md - Schema metadata → Metadata queries: builds metadata queries
src/extensions/DbSqlLikeMem.VisualStudioExtension.Core/Generation/SqlDatabaseMetadataProvider.cs - Schema metadata → Database connection: reads metadata