Individual skill

orchardcore-data

Skill for configuring the Orchard Core data layer. Covers database provider selection, YesSql options (OrchardCore YesSql section), Sqlite options (Data Sqlite section), table naming presets (Data TableOptions section), document options (Documents section), connection string setup, DbConnection access, SQL dialect abstraction, table prefix and schema conventions, Dapper integration, transactions, and the Orchard Core 4.0 configuration section renames from OrchardCore_YesSql, OrchardCore_Data_Sqlite, OrchardCore_Data_TableOptions and OrchardCore_Documents. Use this skill when requests mention Orchard Core Data, Sqlite Connection Pooling, YesSql Configuration Options, Database Table Options, Creating a DbConnection, or closely related Orchard Core implementation, setup, extension, or troubleshooting work. Strong matches include OrchardCore.Data, OrchardCore.Data.YesSql, IDbConnectionAccessor, IStore, ISqlDialect, YesSqlOptions, DocumentOptions, ShellSettings, Dapper.

plugins/orchardcore/skills/orchardcore-data/SKILL.md

Read pinned source

Source commit d86d04f234b1b2bd8145368a2544490f9d557596

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: Yes
Observed behavior: Instructions only
Last checked: Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 13
Repository last updated: Oct 21, 2026
License: MIT

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

agent-skills Repository topic
ai Repository topic
ai-agents-framework Repository topic
dotnet Repository topic
mcp Repository topic
mcp-server Repository topic
orchardcore Repository topic
data Derived category
data-databases Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

SKILL.mdcore · 10,885 bytes

Read excerpt


# Orchard Core Data - Prompt Templates

## Configure and Use the Orchard Core Data Layer

You are an Orchard Core expert. Generate code and configuration for database access, YesSql settings, Dapper queries, connection management, and table prefix handling.

### Guidelines

- Orchard Core uses YesSql as its document database abstraction over relational databases.
- Supported database providers: `Sqlite` (default), `SqlConnection` (SQL Server), `Postgres`, `MySql`. For SQL Server, MySQL and PostgreSQL, create the database first; Orchard Core creates the tables, not the database.
- Provider, connection string, table prefix and schema are tenant settings (setup screen or `IShellConfiguration`).
- Prefer `IContentManager` for content items and `ISession` for YesSql documents and indexes; use raw SQL only for custom relational tables.
- Use `IDbConnectionAccessor` (`OrchardCore.Data`, package `OrchardCore.Data.Abstractions`) to create `DbConnection` instances pointing to the tenant database.
- Use `IStore.Configuration` for the `SqlDialect`, `TablePrefix` (already includes the separator) and `Schema`.