skills.rest
devixlabs
devixlabsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

views-architecture

Documents a SQL-first pipeline integrating EF Core and Dapper for Blazor-ready views.

Updated Jun 6, 2025
Search Tags:#architecture#sql#views#blazor#dapper#multitenancy#ef-core
One-click install
npx skills add https://github.com/devixlabs/DotNetWebApp --skill views-architecture
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: views-architecture
Source: https://github.com/devixlabs/DotNetWebApp/tree/main/.claude/skills/views-architecture
Command: npx skills add https://github.com/devixlabs/DotNetWebApp --skill views-architecture

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill codifies a SQL-first view pipeline architecture that blends EF Core for writes with Dapper for reads, enabling fast, reliable reporting on complex multi-table queries.

Core Features & Use Cases

  • Three-service pattern (IViewRegistry, IViewService, IDapperQueryService) for metadata, orchestration, and execution.
  • SQL-First Development: DDL-driven view definitions, YAML app.yaml, and generated DTOs to keep database truth centralized.
  • Multi-tenancy and Blazor Integration: automatic tenant schema handling and UI-ready view rendering in Blazor components.

Quick Start

  • Review the architecture patterns and the data flow from sql/views to app.yaml.
  • Run the unified pipeline (DDL → YAML → app.yaml → generated DTOs) and start the sample app to verify read views.

Frequently Asked Questions about views-architecture

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I use Dapper for fast reads while keeping EF Core for writes in a multi-tenant application?▼

A SQL-first view pipeline architecture uses EF Core for writes and Dapper for reads, utilizing a three-service pattern to handle complex multi-tenant queries while maintaining fast and reliable reporting performance.

How does the DDL to DTO pipeline generate type-safe view models?▼

The DDL to DTO pipeline generates type-safe view models by driving view definitions from SQL DDL and YAML metadata, keeping database truth centralized and producing deterministic view models for application reads.

Can I use this SQL view pipeline architecture with Blazor UI components?▼

Yes, the SQL view pipeline architecture integrates with Blazor UI components to provide automatic tenant schema handling and UI-ready view rendering for fast data display.

What is the IViewRegistry and IViewService service pattern for SQL reads?▼

The three-service pattern consists of IViewRegistry for metadata, IViewService for orchestration, and IDapperQueryService for execution, structuring data flow from SQL views to application reads.

When should I use a SQL-first view pipeline instead of direct EF Core queries?▼

A SQL-first view pipeline is best for complex multi-table read queries and reporting in multi-tenant projects, where generating type-safe DTOs from DDL and YAML provides faster and more reliable reads than EF Core.

Related Skills

Explore More Software Engineering Skills→
BuggzBuggz

database-performance

Optimize database access patterns with EF Core and Dapper.

Community
Intermediate
rudironsonirudironsoni

dotnet-blazor-patterns

Explain Blazor hosting models, render modes, routing, and advanced patterns.

Community
Intermediate
FaysilAlshareefFaysilAlshareef
4

dapper

Write read-optimized SQL queries with Dapper and EF Core.

Community
Intermediate
FaysilAlshareefFaysilAlshareef
4

ef-queries

Optimize EF Core queries with AsNoTracking, projections, and split queries.

Community
Intermediate